Hi all,
I want to create an Interface page that helps my team with a recurring task, that involves three tables:
- Choose a single project, presumably using a record picker ("Projects" table)
- In a grid or list below, choose multiple records ("media outlets" table) with a check-mark
- Upon clicking a button, an automation creates entries in a third table ("status" table). These entries are linked to the project from step 1 and the selected media outlets from step 2 and also are assigned a certain status (i.e. "new")
It sounds simple, but I fail to pass the info from both the record selector and the grid on to the script.
Seriously hoping this is doable. I would appreciate any hint as to where I should be looking as I am quite lost at the moment.
Thank you!