How to read a cost grid from user input

[duanehumphreys]

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!

[Aurelien]

Hi @duanehumphreys 

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