Custom Auto-Populate Row ID with different references

I am needing to create a Change Order (CO) sheet for one project but has more than one company with change orders. I am looking to see how I can auto populate each row with a change order # that references each company.

Example:

Project X

Three companies: A, B, C.

For Company A, I would like each CO line item to be identified as CO-Project X-Company A-001, CO-Project X-Company-002, and so on.

Then, similarly, Company B would include CO-Project X-Company B-001, CO-Project X-Company B-002, an so on.

Thanks in advance.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

How are the new rows being added?

Lani

I was hoping to have it add rows with a form but because I have multiple companies, I have created each CO to be a sub-item under the appropriate company. Therefore, I will be adding rows manually.

Lani

I was hoping to have it add rows with a form but because I have multiple companies however, because I have each company as a line with sub-items under with each CO, I am going to input the rows and information manually. I attached an example.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.