How to add multiple rows to new table based on column value

1

I’ve reviewed all the similar conversations but they’re either much more technical that I can understand, or don’t quite cover all the bases.

I have a Sponsorship Tracker and when I change the ‘Contract’ value to ‘Signed’, I want to automatically have 3-4 rows added to a new table to track the regular deliverables: Logo, Social Shareables, Booth choice, etc.

I do not want to have to set up a new button for each row. Automations work, but they only get me so far as I also need these tasks to be attached to the ‘company’ in a relation column and I couldn’t figure that out with the automations.

RunActions(ModifyRows(thisRow, [Sponsorship Miami - Booth Tracking].[Added rows]
  AddRow([Sponsorship Miami - Deliverables], [Sponsorship Miami - Deliverables].Task, "Logo", [Sponsorship Miami - Deliverables].Due, Today()+30, [Sponsorship Miami - Deliverables].Owner, [Sponsorship Miami - Booth Tracking].[Main POC], [Sponsorship Miami - Deliverables].[Sponsorship Miami - Booth Tracking], thisRow.Company)
  AddRow([Sponsorship Miami - Deliverables], thisRow.[Sponsorship Miami - Deliverables].Task, "Sponsorship Deliverables", [Sponsorship Miami - Deliverables].Due, Today()+30, [Sponsorship Miami - Deliverables].Owner, [Sponsorship Miami - Booth Tracking].[Main POC], [Sponsorship Miami - Deliverables].[Sponsorship Miami - Booth Tracking], thisRow.Company)
  AddRow([Sponsorship Miami - Deliverables], [Sponsorship Miami - Deliverables].Task, "Test Deliverable", [Sponsorship Miami - Deliverables].Due, Today()+39, [Sponsorship Miami - Deliverables].Owner, [Sponsorship Miami - Booth Tracking].[Main POC], [Sponsorship Miami - Deliverables].[Sponsorship Miami - Booth Tracking], thisRow.Company)))

Tell me what I’m doing wrong and how to adjust this formula please!

I want the following tasks (rows) added to ‘Deliverables’ once the contract is signed:

Logo Due
Social Shareables
Graphics

all with Due dates Today+30, assigned to Main POC & attached to Company (relation) from ‘Booth Tracking’ table.

Here is the Doc

1 Like
2

Actions for buttons are the same as in automations, the main difference being that ThisRow is not available, but instead you have step results. The UI gives you hints about it.

image
image337×404 15.4 KB

In your example, the first step result is the ‘changed row’ that triggers the automation, so if the action you wrote works for a button it should also work for an automation if you replace ThisRow by Step 1 Result.

Let me know if this helps,

Pablo

3 Likes
3

Thanks Pablo. The automation to add the tasks works great - but the part that’s not working is attaching the relation column in that automation. This seems to only be pulling the company association from the first line company 5 vs. the Step1Result line that caused the trigger.

So I guess I need to figure out what the formula would be, and if there is a formula, to connect a column in an added row to the relation column.

1 Like
4

Hi Abby,

I created a copy of your doc and did the following changes:

  1. Created a linked relation between the ‘Booth Tracking’ and ‘Deliverables’ table.
  2. Added an extra parameter to your action, to add the company from step 1 to the recently created deliverable.

image
image1836×961 122 KB

Let me know if this helps!

Pablo

1 Like