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
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.
User | Count |
---|---|
16 | |
11 | |
5 | |
5 | |
5 |