Hi i am relatively new to honeycode and i would just like to ask on how to return most recent matching data. I have been working with prices of items and i need to return the most recent price of the matching item. How do you go about this? any help would be appreciated. thanks
Here's a quick example I came up with the illustrate:
Two tables, Prices and Products. (Take note of the two Product A's in the Prices table).
In Builder, I have a picklist which lists the products and then a data cell that uses the =FINDLASTROW function of
What that will do is find the most recent price from the Prices table of the product chosen in the product picklist. I have IFERROR so that when first loading the screen, if a product is not selected, it'll just be a blank price.
Here it is in action. Notice Product A is using the latest price of $4.00, instead of the previous price of $2.00.