Dropdown values from child table

alcuino · 06-05-2023 10:00 PM

I am new to AppSheet.

The backend of my app is google sheets.

I have a parent and two related child tables. The two child tables contain the addresses of the Sender and Receiver.

As per the current setup, in my app, there are two buttons to create new sender's and receiver's addresses. On creation of these addresses they are linked to the parent table. These buttons were created automatically by the AppSheet, I guess because I created a reference in each of the child tables to the parent table.

I need an added functionality of checking and selecting if the addresses are already existing in the child tables of the sender's and receiver's table. I tried searching on the net but was not successful.

Please help

Thank you

AleksiAlkio

If the address column is in your parent table, try this .. NOT(IN([Address],ChildTable#1[AddressColumn]+ChildTable#2[AddressColumn])).

If you need the opposite, remove the NOT().