Expressions that uses data from spreadsheet if it exists:
Hey guys - I hope you can help me with this one. I need an expression that checks if a column has data inside it, and if it has, it should “load” that into the form, and if not, the column should just be empty and open for user input.
For instance, the user types in an order number, and if a row with this order number exists, it should load the other columns into the form for the user to edit (for instance company name, slogan or other details). So far I’ve tried with something like this:
=IF(ISNOTBLANK(ANY(Select(Data[Company], [Ordernumber]=[_thisrow].[Ordernumber]))), ANY(Select(Data[Company], [Ordernumber]=[_thisrow].[Ordernumber])), “”)
This seems to work fine with loading, in this case the company name, BUT, it doesn’t allow me to input a value myself if no value is present. Any suggestions?