Help

Fill Empty Cell Operation

Topic Labels: Automations
Solved
Jump to Solution
555 2
cancel
Showing results for 
Search instead for 
Did you mean: 
DZaunLM
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello all!

As the subject suggests, I am trying to fill in blank cells under a certain column with "N/A" when a form input leaves the column blank. This is so that when I create an automated email, instead of "the part is     ", the recipient will receive "the part is N/A." I have tried to run an automation with when I change the status of the form input, a conditional record update will trigger but only if it is empty. However, I keep getting a testing error. Does anyone have insight into this?

 

Thanks!

1 Solution

Accepted Solutions
DZaunLM
5 - Automation Enthusiast
5 - Automation Enthusiast

Sorry for the late response! I figured out that my Record ID was referencing the wrong item, therefore causing the automation to break. Thanks for reaching out to help though!

See Solution in Thread

2 Replies 2

Could you provide screenshots of the error, your automation setup, and the table with the data the automation errored on?

In theory what you're suggesting should work just fine!

DZaunLM
5 - Automation Enthusiast
5 - Automation Enthusiast

Sorry for the late response! I figured out that my Record ID was referencing the wrong item, therefore causing the automation to break. Thanks for reaching out to help though!