Populating form fields with DoQuery results

Question

Hello. Apologies if I've missed a similar conversation. Within a form, I'd like a user to be able to fill in some fundamental data, then click a button and have a field within that form populated with a value returned from a DoQuery call that would reference those fundamental inputs. Note: the value to be populated would not be attainable via table to table relationships.
I've only recently started working with formula URL buttons and the API, and I'm struggling to get the two to work in tandem.

Any guidance would be much appreciated.
Thanks

anomDiebolt · Answer

What I understand from your description is that:

you are creating a new record or editing an existing record
next, you want a button on the form the will take various values sitting in the open form and make an API_DoQuery request
finally, you want to take the response of the API_DoQuery call and parse the results and stuff them into some other field on the open form

This is easy to do with script but there are two issues. (1) To the extent that the values sitting the open form are used in forming the API_DoQuery it is possible that these values may be changed by the user after the API_DoQuery returns a result. This may create an inconsistent state as the results of the API_DoQuery do not reflect the values of the fields that were changed. (2) Likewise, I suppose it is possible for the user to modify the field that received the parsed results of the API_DoQuery if they make their change after the button is pressed. Again when the form is saved it is possible that it may reflect inconsistent or state information.

Other than that this is easy to do with script once the details of the fields and query are supplied.

Sign up

Login to the community