Friday - last edited Friday
Hello everyone
I have a question about the lookup tables。I want use formula in column。
I want to find a data start with “B”, How to write the formula in column?
Friday - last edited Friday
Dear, @FrankXu .
You can intput this formulas in input field:
lookup("TABLE_NAME", "REFERENCE_COLUMN": datapill.starts_with?("B)["LOOKUP_COLUMN"]
The preceding formulas contains the following elements:
Saturday - last edited Saturday
Hello Nguyen Duc Y
thank you for your answer
But the lookup table like the first line is column name and the next line is data. so I use app: lookup tables and the action:Lookup entry and the Setup: write formula in cloumn.
so it doesn't right
Sunday
Do you want to get the recipe ID corresponding to the Order_number starting with the letter B?
Sunday
no,I only want to get the recipe ID by formula