Can I have a form populate two different sheets?

I want to have a project intake form that can direct projects to one of two different summary sheets depending on the type of project. Alternatively, I want the form to adjust the prefix for an auto-numbered project ID depending on the type of project. i.e. I am looking to implement one of the following two ideas.

Solution 1: "Research" projects are sent to one project intake sheet that auto-numbers the projects with the prefix RS, while "Infrastructure" projects are sent to a different project intake sheet that auto-numbers the projects with the prefect INF.

Solution 2: The project ID prefix is dynamically changed depending the type of project. I don't particularly care if the numbers are sequential within a prefix grouping or across prefix groupings.

Find more posts tagged with

Forms

Accepted answers

All comments

Anne Reynolds

Never mind. I figured out that I could set up a form to populate a dummy summary sheet. Then I set up an automated workflow to move rows from my dummy summary sheet over to the appropriate summary sheet and auto-number rows within the appropriate summary sheet. It's slightly clunky to have a dummy summary sheet sitting around, but it gets the job done for sure.

Genevieve P.

Hi @Anne Reynolds

Thanks for posting your solution!

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.