Use formula in lookup tables

[FrankXu]

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?

[ndy]

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:

• TABLE_NAME - The name of the lookup table.
• REFERENCE_COLUMN - The name of the column in the lookup table to be used as a reference.
• LOOKUP_COLUMN - The name of the column in the lookup table you plan to look up data for.

[FrankXu]

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

[ndy]

Do you want to get the recipe ID corresponding to the Order_number starting with the letter B?

[FrankXu]

no，I only want to get the recipe ID  by formula