Hi, how can i retrieve input value when add master detail form before saving process occurs.
for example in master form, i input unit name value “Excavator”, in detail table i can do ExecuteScalar query sum(name_unit). PHPMaker 2024.
If it is before saving as you said, then data is not saved to the database yet, you cannot use functions like ExecuteScalar(). If you meant you want to get the current sum from the database to input a field in the detail table on the client side, you may Create your own API to get it by Ajax. Otherwise, you may want to describe what you want to achieve in detail.
I just want to take the input form value “Excavator” from the master table to the detail table, can you give an example?
Probably you might want to use Row_Inserting and Row_Updating server event? Have you tried it?
yes I have tried but what I mean is that the value can be obtained in the detail table. not when the add button is pressed, but when the data is filled in the form field, my unit name is “Excavator” when the value is filled in the detail table, the value can be taken.
I have tried Container(“tablename”) this process only works when updating. what about when adding data?
please help me with my problem, thank you
Then you need to use arbei’s suggestion. You may see the example from the link mentioned above.