SELECT

[leo]

Here is the sample query

SELECT  Amount FROM Tuition Fees
WHERE YearLevel=@YearLevel AND Semestral=@Semestral

How do i write the above query in appsheet?

[Aurelien · Accepted solution]

Hi @leo 

SELECT(Tuition Fees[Amount],
  AND(
    [YearLevel]=[_THISROW].[YearLevel],
    [Semestral]=|_THISROW].[Semestral]
  )
)

I suggest you read this:

https://help.appsheet.com/en/articles/2357308-filter

https://help.appsheet.com/en/articles/2357314-select

[leo]

Thank you so much!