I have a cost grid for a product that is based on increments of both heights and widths, that can then e used to look up a cost - is there any way within Appsheet to both feed that data in, and then return the correct cost when width and height are entered via user input in the app? I've had a look through the different options, and I'm not seeing anything obvious.
Thanks!
You may want to consider building a database "COSTGRID" with columns:
- key column
- Item
- Width
- Height
- Cost
and use a SELECT+ANY expression
ANY(
SELECT(COSTGRID[Cost],
AND(
[Width]=[_THISROW].[Width],
[Height]=[_THISROW].[Height],
[Item]=[_THISROW].[Item],
)
)
)
For reference:
https://help.appsheet.com/en/articles/2357314-select
https://help.appsheet.com/en/articles/2357308-filter
https://help.appsheet.com/en/articles/2347632-any
User | Count |
---|---|
25 | |
25 | |
25 | |
23 | |
16 |