Hi guys, new to appsheet…
Hope someone can help me out please.
I’m making a parking lot management app where we charge peolpe to park per day.
The price charged per day gets cheaper the longer you book your car in.
Example: Days Set Prices/Rates 1
100 2 to 7
70 8 to 28
50 29+
25
I have made a column that auto-calculates the number of days (Date In-Date Out) on Table 1(Form Table) and put the Set Prices In Table 2 (Data Table) so that I can chage the prices/rates per day, if needed, through the app.
I’d like to have my price column on Table 1 auto-calculated Eg. Number of days multiplied by Set Prices/Rates on Table 2.
Is there a way to calculate between Tables?
Thank you.
Sure. you can use a lookup, or a select formula, to go and fetch that value.
You could use the LOOKUP expression like this… LOOKUP([_THISROW].[DAYS],DataTable,Days,Rates)*[DAYS]
@Aleksi_Alkio IT WORKS! Thank you.
You’re welcome
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |