woodey2002 4/18/2019 | |
Have a look here https://xlinesoft.com/articles/how_to_use_calculated_fields.htm |
J
|
jacques 4/18/2019 |
try concat with mysql |
S
|
stanbar1 author 4/18/2019 |
Hi i have a problem i have field firstname field lastname and field fullname. how can i add on load first and last name to fullname...Thank you
|
woodey2002 4/18/2019 | |
var ctrlFirstName = Runner.getControl(pageid, 'FirstName'); |
M
|
MikeT 4/18/2019 |
Hi i have a problem i have field firstname field lastname and field fullname. how can i add on load first and last name to fullname...Thank you
|
admin 4/19/2019 | |
var ctrlFullname = Runner.getControl(pageid, 'Fullname'); var ctrlFirstName = Runner.getControl(pageid, 'FirstName'); var ctrlLastName = Runner.getControl(pageid, 'LastName'); function func() { ctrlFullname.setValue (ctrlFirstName.getValue()) + (ctrlLastName.getValue())); }; ctrlFirstName.on('keyup', func); ctrlLastName.on('keyup', func);
|
S
|
stanbar1 author 4/19/2019 |
You could also create a calculated field at the database-level (my preferred method) and then load it like any other field of the table. Don't remember if you can create these from phpr, otherwise create it in phpMySQL or any other db-management tool that works with your database.
|
woodey2002 4/19/2019 | |
This code works! var ctrlFirstName = Runner.getControl(pageid, 'FirstName'); |
S
|
stanbar1 author 4/20/2019 |
This code works! Test it out var ctrlFirstName = Runner.getControl(pageid, 'FirstName');
|
woodey2002 4/20/2019 | |
Check the field names or something as it works for me in the sample add page I tested it on. var ctrlFirstName = Runner.getControl(pageid, 'FirstName'); |
S
|
stanbar1 author 4/20/2019 |
Check the field names or something as it works for me in the sample add page I tested it on. Here is SQL... SELECT id, Fullname, FirstName, LastName FROM test This code works for me on the add page... var ctrlFirstName = Runner.getControl(pageid, 'FirstName');
|