Hi, does anyone knows how I can autofill one of my field based on what I have selected in the previous dropdown field?
In the attachment above, I have a master data in Google Sheets which contains the following field shown above. I have created a view from a separate Google Sheets. In that particular view, the following field should be filled in by my app user. Once the app user has filled in their name and chosen their video game from the dropdown list. Then, the URL field will autofill and refer from the master data according to the name filled and chosen video game.
Please help to advice. Thank you.