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?
Solved! Go to 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
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
Thank you so much!
User | Count |
---|---|
41 | |
30 | |
29 | |
16 | |
14 |