Lookup function

[ETS]

Hi Team,

I have created an app with one google sheet. the file has two sheet-like “customers details” and “booking”, both of them have a separate form for registration.

After the customer details entered, I want a function for a “booking form”, like when a customer is selected reset of the details like email, contact number all needs to auto-fill based on the “customer details”

Customers details