Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Fill Empty Cell Operation

Topic Labels: Automations
Solved
Jump to Solution
1327 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!