https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/7997#M3350 <P>Hello everyone<BR />I have a question about the lookup tables。I want use formula in column。<BR />I want to find a data start with “B”, How to write the formula in column?</P><P>&nbsp;</P> Sat, 12 Oct 2024 01:26:04 GMT FrankXu 2024-10-12T01:26:04Z https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/7997#M3350 <P>Hello everyone<BR />I have a question about the lookup tables。I want use formula in column。<BR />I want to find a data start with “B”, How to write the formula in column?</P><P>&nbsp;</P> Sat, 12 Oct 2024 01:26:04 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/7997#M3350 FrankXu 2024-10-12T01:26:04Z https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/7999#M3351 <P>Dear, <a href="https://systematic.workato.com/t5/user/viewprofilepage/user-id/11064">@FrankXu</a>&nbsp;.<BR />You can intput this formulas&nbsp; in input field:<BR />lookup("TABLE_NAME", "REFERENCE_COLUMN": datapill.starts_with?("B)["LOOKUP_COLUMN"]</P><P>The preceding formulas contains the following elements:</P><UL><LI>TABLE_NAME<SPAN>&nbsp;</SPAN>- The name of the lookup table.</LI><LI>REFERENCE_COLUMN<SPAN>&nbsp;</SPAN>- The name of the column in the lookup table to be used as a reference.</LI><LI>LOOKUP_COLUMN<SPAN>&nbsp;</SPAN>- The name of the column in the lookup table you plan to look up data for.</LI></UL> Sat, 12 Oct 2024 03:57:20 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/7999#M3351 ndy 2024-10-12T03:57:20Z https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/8000#M3352 <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="スクリーンショット 2024-10-12 170504.png" style="width: 999px;"><img src="https://systematic.workato.com/t5/image/serverpage/image-id/1605i58044418CF8245BF/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="スクリーンショット 2024-10-12 170504.png" alt="スクリーンショット 2024-10-12 170504.png" /></span>Hello&nbsp;<SPAN>Nguyen Duc Y</SPAN></P><P>thank you for your answer<BR />But the <SPAN>lookup table&nbsp;</SPAN>like the first line is column name and the next line is data. so I use app:<SPAN>&nbsp;lookup tables&nbsp; and the action:Lookup&nbsp;<SPAN class="">entry&nbsp; and the Setup: write formula in cloumn.<BR /></SPAN></SPAN><SPAN><SPAN class="">so it doesn't right</SPAN></SPAN></P> Sat, 12 Oct 2024 08:06:13 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/8000#M3352 FrankXu 2024-10-12T08:06:13Z https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/8008#M3354 <P>Do you want to get the recipe ID corresponding to the Order_number starting with the letter B?</P> Sun, 13 Oct 2024 13:03:03 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/8008#M3354 ndy 2024-10-13T13:03:03Z https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/8011#M3356 <P>no，I only want to get the&nbsp;<SPAN>recipe ID&nbsp; by formula</SPAN></P> Mon, 14 Oct 2024 00:29:18 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/8011#M3356 FrankXu 2024-10-14T00:29:18Z https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/8033#M3364 <P>Dear,&nbsp;<a href="https://systematic.workato.com/t5/user/viewprofilepage/user-id/11064">@FrankXu</a>&nbsp;<BR />You should add two following actions</P><DIV class=""><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-10-14 151925.png" style="width: 562px;"><img src="https://systematic.workato.com/t5/image/serverpage/image-id/1612i87187CC9A02B5D21/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Screenshot 2024-10-14 151925.png" alt="Screenshot 2024-10-14 151925.png" /></span></DIV><P>Then, you can add the formula in input field you want (maybe leave to.s function).</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-10-14 152145.png" style="width: 710px;"><img src="https://systematic.workato.com/t5/image/serverpage/image-id/1611i7C6E37F94AFA06DB/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Screenshot 2024-10-14 152145.png" alt="Screenshot 2024-10-14 152145.png" /></span></P> Tue, 15 Oct 2024 06:24:28 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/use-formula-in-lookup-tables/m-p/8033#M3364 ndy 2024-10-15T06:24:28Z