Hi guys, new to appsheet... Hope someone can...

(Russell Van) #1

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.

(Grant Stead) #2

Sure. you can use a lookup, or a select formula, to go and fetch that value.

(Aleksi Alkio) #3

You could use the LOOKUP expression like this… LOOKUP([_THISROW].[DAYS],DataTable,Days,Rates)*[DAYS]

(Russell Van) #4

@Aleksi_Alkio IT WORKS! Thank you.

(Aleksi Alkio) #5

You’re welcome