is it possible to do a lookup in a form before a user submits.
ON my entry form, a user can select one of their dogs from their profile. Here I have selected dog name Diabolo.
On my datasheet, i have his registration number.
How would i make glide auto lookup that information and then when they click submit that it would also link that onto the entry form helper.
I have built a relation on my entry form helper table. so when you submit the form, on the datasheet it will do a lookup of the registration number. was curious if you could have a “live” lookup before you submit
I would change it around a bit and change the choice component to display the name but write the registration number value to the table. Then create a relation and lookup in the table to retrieve the name if needed.
Are you using a custom form (aka a regular detail screen) or a native glide form?
everything done on glide.
so most people remember their dogs names, but not necessarily their registration number. thus why i wanted the choice of dog in a drop down
Of course it’s done in Glide, but I’m asking if you are using a native Glide Form or you made a Custom Form in Glide from a Detail screen. They are different
in how they function. Sometimes we need to create a custom form to do certain things that you can’t do in a native form.
You mentioned a helper table, so initially assumed you had made a custom form, but now I see in your screenshot that it’s a form container, which is a native form. The form container is not linked to an existing row because it’s designed to add new rows. Because it’s not attached to an existing row, computed columns will not be accessible within the form.
That’s why I suggested changing the choice component to Display the dog name to write the registration number as the Value. The user will see a list of names, but it’s actually the registration number that is written to the table when the form is submitted. From there you can use a Relation and Lookup to retrieve the name from the registration number.
thank you.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
