How to create booking form

[KaysonYang]

I have been trying to create a booking form that I can choose location based on selected client ID. Each client could have multiple location. Another thing is that My Client sheet and Address sheets are linked by client id. However, in my booking form I want to use ID-Name formate so user can search client using both ID and Name. After that how can I still get the respective addresses to show in the booking form based on just ID alone?

[WillowMobileSys]

If I understand correctly, you wish to limit dropdown choice based on selection in other related fields.

If so, please review this article for more details on how to build this:

Dependent dropdowns

I hope this helps!

[PauloExpert]

To create a Booking Form in AppSheet where users can:

1. Search clients using “ID - Name” format

2. Filter available locations based on the selected client

— you’ll need to set up a dependent dropdown with a display column trick. Here's how to do it step by step:

1. Prepare Your Sheets

Client Sheet

Address Sheet

2. Create a Virtual Column: “ID - Name”

In the Client table, add a virtual column like this:

Name: IDName

App formula:

CONCATENATE([Client ID], " - ", [Client Name])

This column will show something like:

001 - Alpha Corp

3. Booking Form – Client Selection

In your Booking table, the Client column should be of type Ref to the Client table.

Go to the Client column

Under “Display”, choose the virtual column IDName

This allows users to search using either ID or Name.

4. Booking Form – Location Filter

Now you want to show only the locations for the selected client.

Create a column Location (Ref to Address table).

Under Valid_If use this expression:

SELECT(Address[Address ID], [Client ID] = [Client])

This filters the dropdown to show only locations where [Client ID] matches the selected Client in the booking form.

> If [Client] in Booking is a Ref to the Client table, then [Client] directly refers to the Client ID (or key).

5. Optional: Show Location Name Instead of ID

If your Location column is a Ref to Address, and you want it to display the Location Name instead of Address ID, just go to the Address table, and set the Label column to Location Name.

Result:

Users select a client by searching for “001 - Alpha Corp”

The Location dropdown is filtered to show only addresses linked to that client.