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

[Chris_Jeal]

I think LINKTOFORM() may help you here:

help.appsheet.com

LINKTOFORM()

Constructed deep link to form

[ETS]

Please advise… how can i do that

[ETS]

@Steve hello… could you please help me for this

[Steve]

@Chris_Jeal’s suggestion seems good to me.

[ETS]

How to make that formula…can you please help me. I’m a beginner of appsheet

[Steve]

What you’re trying to do is not “beginner” level. I’m not inclined to help you work so far ahead of your experience because I’ll end up doing all the work.