How to auto populate cells after they are sent to a sheet from a form.

I have a form which requires roughly 10/50 of the columns being filled, since not all of the information is know at time of entry. Each row is one job, and the job has roughly 14 steps in the production process, with other information in each row.

Once the form receives the input, and the input gets sent to a new row in a sheet, how can I auto populate roughly 10 of the columns to show those steps in my process haven't started yet?

Find more posts tagged with

Accepted answers

404.IRL

Good day, @TG_Controls_PM If I understood correctly, this should do the trick:

Create a workflow for the sheet
Trigger - When rows are added
Run workflow - When triggered
Condition - None unless you have one
Change cell value - select the cells you want to populate
Repeat step above

All comments

404.IRL

Good day, @TG_Controls_PM If I understood correctly, this should do the trick:

Create a workflow for the sheet
Trigger - When rows are added
Run workflow - When triggered
Condition - None unless you have one
Change cell value - select the cells you want to populate
Repeat step above

TG_Controls_PM

When "change cell value" goes into effect, I want it to equal an equation, which I can't figure out how to do.

Andrée Starå

Hi @TG_Controls_PM

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.