as I am very knew to Coda, I hope that (1) I am posting this question within the correct category and (2) this question has not be answered before (I was searching but could not find a hint!)
I am working on Coda for the last four or five days and am stuck with an automation I am working on:
I have a Project table in which I keep track of the metadata of a project such as start and end date, priority, owner, etc. and I have a
ToDo table which contains all todos I am working on including the individual tasks for each project. Both tables are therefore connected in order to identify which tasks belong to which projects.
I am now working on an automation, which should include a couple of steps:
- Adding a new line to the Project table
- Opening the new record as a page
- … now I want to enter data like project name, start and end date, etc. Once I have that data entered and closed the page I want the automation to continue and
- Add a new line to the ToDo table which needs to include the project name defined in step 3.
In the last step I am having the problem: how can I (1) continue the automation once I have closed the project page and (2) use the project name from step 3 in step 4. My understanding is that Coda does not know the concept of variables so I was looking at the “thisrow” function but this did not work as well.
Any help, thoughts, ideas are appreciated - I am sure the problem sits in front of the keyboard