This topic is locked

View field in Add/Edit screens

7/18/2016 11:47:58 AM
PHPRunner General questions
P
PHPRunnerExplorer author

Hi,
I need to show the current name of the customer, and some other fields, while editing a related database.
Is this possible in Designer mode? Or do I need to copy some of the html for that field in the View screen, to the Add screen?

Sergey Kornilov admin 7/19/2016

I guess you meant a related table and not a related database. This would make sense if you setup one of fields as a lookup wizard and enable autofill option to bring more fields from the lookup table to your Add/Edit form. You can set 'Edit as' type of those extra fields to 'Readonly' so they are for display purposes only.
For more info check 'Autofill' section at http://xlinesoft.com/phprunner/docs/lookup_wizard.htm
Copying fields in Visual Editor is not enough as they are just placeholders and won't work without supporting server-side code.

P
PHPRunnerExplorer author 7/19/2016

That's correct, it's a related table. Sorry about that.
Yes, I'm using the lookup dropdown for it right now. I have several concatenated fields in the drop down, sorted by Last name. But I didn't realize we could use the autofill to populate some Edit fields flagged as readonly.
Also, if I'm reading the page that you forwarded correctly, it looks like we can add records on the fly to that lookup table.
The main table is an Application table, and it's linked to an Applicant table. The Applicant table is being used as the lookup (by Applicant_Id), but we also need to Edit/Add to that table infrequently.
Ok, I'll take a closer look at the lookup screen, thanks. If you have any other suggestions or links, feel free.
Thanks and regards,
DC



I guess you meant a related table and not a related database. This would make sense if you setup one of fields as a lookup wizard and enable autofill option to bring more fields from the lookup table to your Add/Edit form. You can set 'Edit as' type of those extra fields to 'Readonly' so they are for display purposes only.
For more info check 'Autofill' section at http://xlinesoft.com/phprunner/docs/lookup_wizard.htm
Copying fields in Visual Editor is not enough as they are just placeholders and won't work without supporting server-side code.

Sergey Kornilov admin 7/19/2016

Yes, you can also enable 'Add new records on fly' option in Lookup wizard to quickly add a missing option to lookup table.

P
PHPRunnerExplorer author 7/19/2016

Perfect. Just tried it, and it works like a gem. Lookup is defined on the Applicant_Id, and some of the name and address fields are displayed, read-only.
Thanks, chief.



Yes, you can also enable 'Add new records on fly' option in Lookup wizard to quickly add a missing option to lookup table.