how to ref a table based on dynamic user input field or column.

AppSheet AppSheet Q&A
,
1

Dear appsheet experts,

I have a problem in creating record maintenance app for parcel shipping process. I have 3 or 4 tables (which contains courier details with tariffs and it is not a slice) . there is primary table called orders. in this order table there is column called courier name which is dynamic or ref values will be listed and it will be selected by the user. there is another column called tariff in the same primary table , this tariff column ref to the 3 or 4 tables (courier details with tariffs) which is dynamic based on the courier name given by the user at courier name column or field. my question is how to switch or ref tables based on the user given values? what is procedure ? is there any specific syntax available for selecting or switching tables ? kindly help my mail id is (PII Removed by Staff)

2

You cannot dynamically reference different tables from a single column. Period.

If you are OK NOT to use a column of ref for tariff (say currency), then you can pull values from different tables depending of the courier the user selects.

You can try something like below..

IFS(
 ISNOTBLANC(FILTER("table 1", [courier] = [_THISROW].[tariff])),
 LOOKUP([_THISROW].[courier], "table 1", "courier", "tariff"),
 ISNOTBLANC(FILTER("table 2", [courier] = [_THISROW].[tariff])),
 LOOKUP([_THISROW].[courier], "table 2", "courier", "tariff"),
 and so on
)
1 Like
3

sir, could you please share your contact number or email id? I want to connect you for an urgent help. my email id is

4

Hi, I do not provide any private services. If you require urgent support I strongly suggest you get a professional service.

There are plenty of experts in the community ready to provide excellent services.

Meanwhile if you have questions, post them here. I will try my best to answer them. Iā€™m sure others will also do the same.

1 Like