Automation issue related to relational column

[Carrie_Fix]

Starting two days ago, my automation started acting strangely and I’m not sure how to fix it. I have not touched this automation for months so I’m not entirely sure what caused this change.

I have two tables, Job Applications and About. Job Applications has a plain text column “Company” while About has a “Company Name” relational column with value options based on the “Company” column. If trigger conditions are met, my automation is supposed to add a new row to the About table, where “Company Name” is set as the same value as its related column. (Please note that though “Company Name” is a relation column to “Company”, not every row under “Company” ends up in the “Company Name” column, just the ones that meet the conditions of the automation).

Beginning on Nov 18, the automation has simply been creating blank new rows with no value in “Company Name”. I am not sure why it’s suddenly having issues.

My automation

Step 1) Trigger

Step 2)

If

and(or(thisRow.[Step 1 Result].Stage.ContainsText(“1a”),thisRow.[Step 1 Result].Stage.ContainsText(“0a”)),not(About.[Company Name].Contains(thisRow.[Step 1 Result].Company)))

Step 3

Then

AddRow(About, About.[Company Name], thisRow.[Step 1 Result].Company)

Step 4

And then…

ModifyRows(thisRow.[Step 1 Result],[Job Applications].[Interview Page],thisRow.[Step 1 Result])

Automation Activity

Nov 18-20 Examples

Many of these were me running tests to try to fix the problem to no avail

Before Nov 18 Examples

I appreciate any help I can get from all you Coda experts. Let me know if you have any questions. Thank you!

[joost_mineur]

Hello @Carrie_Fix

I think step 4 is wrong, but it is really hard to debug this without a shared document.

You can do two things: create a dummy doc that resembles your doc, but does not contain the sensitive data, or share your doc with someone (from this community) that you trust and let them take a look at your code.

I can take a quick look if you share your doc with me (joostmineur@gmail.com, nda is obvious), but make sure to answer also in this thread because I don’t check my gmail very frequently.

Greetings,
Joost