I have an app for my company which, amongst other things, enables me to keep a track of my customers products that i have sold them as well as products competitors have sold them.
Within the 2 pics attached you will see the results and how.
My source sheet has a number of fields eg Product code, name, description and price. I’m adding the product to the customer file by a custom form. I am choosing a field from the source sheet using a choice component eg Product name. When I select the product name I want it to auto populate the additional fields if i have them eg Product code, description and price but I can’t seem to be able to figure out how to do that or even if you can.
Make a relation in “CompanyConsumables” to “Consumables” based on the name columns in both tables. Then lookup column values which should be autocompleted. I think glide can immediately use the value in the choice component even before submission.
You might need some visibility conditions in the form and some if-then-else columns in your “companyConsumables” table.
Edit: if you can’t immediately use the value of the choice component for the relation: configure a custom form with the help of custom actions setting values in user-specific columns shown on new screens.
Thanks for your reply…I’m not sure I get it completely but are you talking about lookup column in the Glidesheet? ie for example: Make the description column a lookup and essentially if the name in the customer consumable sheet matches the consumable sheet name then enter the description data from the matching row…??
yes lookup columns in glide. But then it is not shown in the form.
If you want to have it in the form, you can make 2 choice components: 1st with name; 2nd with description; both drawing data from the “consumables” table, and the 2nd choice component has filtered data based on the screen variable of the 1st choice component.