Backfilling from one table to another

AppSheet AppSheet Q&A
1

I’m new to AppSheet so using the free version. Not sure if it is missing EVENTS on behaviour for fields.

I created a AppSheet database two tables… ADDRESS table and TRIP table. In short I want to lookup an address in the ADDRESS table and backfill this address into TRIP table. My key is a field called NICKNAME which appears in both tables.

Logic… I created an APP to input trip records into the table. while in the TRIP input , I click on NICKNAME field (drop down) and select a nickname. Then want it to take the associated address in the ADDRESS table and backfill to ADDRESS field in TRIP table.

I created an ACTION that will facilitate the backfill. The problem i’m having… where is the event trigger programmed. I don’t see any behaviour for the NICKNAME field in the VIEWS section / Trip Records / field properties like “ONCHANGE” to activate this.

2

In your TRIP table, you want to define the NICKNAME column as REF type to the ADDRESS table. Make sure that NICKNAME column in the ADDRESS table is set as the Label column.

Then you can set the Address in your TRIP table using “dot” notation like this:

[NickName].[Address]

Place this expression in either Initial Value or App formula - depending on what behavior you want.

When NickName is chosen in your Trip entry, the Address field will automatically be set.

I hope this helps!