Convert Formula Googlesheet to Appsheet

FILTER(

FLATTEN(MAP(PRODUKSI[NAMA MENU],LAMBDA(items, TRANSPOSE(FILTER(RESEP[BAHAN BAKU],RESEP[NAMA MENU]=items))))),

FLATTEN(MAP(PRODUKSI[NAMA MENU],LAMBDA(items, TRANSPOSE(FILTER(RESEP[BAHAN BAKU],RESEP[NAMA MENU]=items)))))<>"")

Good evening, please help to convert this spreadsheet formula so that it can be read by Appsheet. For the column ranges in the spreadsheet, I have replaced them with the names of the columns (i bold them) and tables in the database that I created in Appsheet. please advice, thank youu

0 1 89
1 REPLY 1

This formula is used for change the selected menu to a list of raw ingredients. so that the stock of raw materials can be monitored, the illustration is as follows. WhatsApp Image 2023-09-15 at 8.03.08 PM.jpeg

 

Top Labels in this Space