Hello, i’ve create a database with ingredients, recipes and meal plan tables.
I’ve linked my recipe with a list of all ingredients inside this meal plan table, then
my goal is to add a multiplier field in the meal plan table to adjust quantity of each ingredients of the list.
Is it possible to have a lookup field with a liste of values (number and text) and multiply these values (only numbers) ?
Thank you for your help
Best Regards
Brian
Multiply lookup field
Best answer by Justin_Barrett
Welcome to the community, @Brian_Cuttaz! :grinning_face_with_big_eyes: Unfortunately running the process as you describe it is not currently possible. Because there will be an arbitrary number of ingredients, and Airtable doesn’t have any built-in formula features for parsing an arbitrary number of items, it’s practically impossible to isolate the numbers, do the math, then put the new values back in place of the old ones. My next thought was to consider the scripting block, but I’m not even sure that would work (at least not easily).
Off the top of my head (which is rather fuzzy at the moment because I’ve been editing video all day), I can’t think of a way to pull this off.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.