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
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?