I know using IF-THEN-ELSE is possible, but if I have 20 different conditions, then it becomes a bit tedious to set up and less flexible if I need to use it across multiple tables.
The equivalent of a vlookup in Glide is generally a query or relation, together with a lookup column.
If you can provide some more specifics of your use case (screen shots are always helpful), we can help guide you.
1 Like
For example that’s my Lookup table. In my base table, I want it so if Height of a door is 17, then the Post_Interval_Value is 197. If Height is 55, then 142. Picture below is an example of the result I want.
Please let me know if you need more examples.
The easiest would probably be too use a Query column. Filter it where Height_Ins <= your input height. Sort by Height_Ins in descending order. Uncheck Match Multiple. This should give you the one result that is equal or the next lowest. You can then use a Lookup column to pull the Post_Interval_Value out of the Query.
2 Likes
I still don’t understand too much about how Query works, but your method solved my issue. Thanks!
1 Like
A Query basically says, I want certain rows from another table. The filter tells it which rows you want (just like the filter on a collection), and the sorting tells it which order you want those rows (just like the sort on a collection). The benefit of a Query is that you can set the filter to use values from the current Row, so if you have multiple rows, the query could return different results for each row.
In the end, you can retrieve specific values from the query, or you can use it as the source of a collection on the detail screen for the current row.
Query is similar in function to a Relation as far as returning rows if data. A relation looks for a matching between the Origin and Destination tables. A Query can do the same thing, but with additional flexibility as far as filtering and sorting. A relation is generally faster, but for a use case like yours, only a Query will work.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.