I have a scenario where I have folks importing data into a table that gets written to another table. There is a column in the import table that I would like to have the contents of that column be as a lookup in another table and if it finds the value in a column pull a value in that same row but a different column in that row and then take that value and write it to the imported value.
When the row is imported the item in Branch Number column is a long string. I'd like to do a lookup against a table that has the same strings but in the column next to it has a simple value.
In my Import table, for the Simple Value column, I am using the following expression: =FINDROW(Lookup,"Lookup[Label]=%",[Branch Number])[Value]. Using the FINDROW function here will find the row from the Lookup table that matches the Branch Number column. If there is a match, then it pulls the second column from the Lookup table, which is Value. Here's a screenshot:
Are you sure the FindRow example using another column as a substitute is still valid in the current version of Honeycode? I keep getting an error, but I suspect the reason is that the column type is a rowlink/picklist. For example, how would the FINDROW example cited above work if the Branch Number column is a PickList?