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
LinkedIn
Twitter
