I am very new to AppSheet and also have little experience working with formulas in Excel - so, please be kind.
I have an app with several tables:
- Table 1. I have a table that contains roles & wages
- Table 2. I have a table that uses roles and wages and needs to calculate a cost per step provided a duration parameter
I managed to link the tables, and I’m able to select (from Table 1) a certain role and bring it in Table 2.
What I would like to do (and I am struggling with) is when I select a certain role in Table 2, the wage field (column) to be automatically populated with the correct corresponding wage from Table 1.
Please provide specific steps instead of general documentation on expressions.
Thank you in advance!