AnsweredAssumed Answered

Create ordered list in field based on linked table

Question asked by ezeitgeist on Oct 11, 2017
Latest reply on Oct 19, 2017 by ezeitgeist

I have the following relationship for a Testing project:


Screen Shot 2017-10-11 at 6.03.14 PM.png

I want to add a field in TestType table: SectionOrder, which lists the order select SectionTypes appear in that specific TestType.

 

How do I most efficiently create this list? (Can I select from a portal somehow?)

There are likely going to be 20+ SectionTypes, but I'll only be ordering 2-5 SectionTypes per TestType.

(I will be pulling from this list field in a layout and aiming to create a loop that starts in the first SectionType and then goes through each until the last one is completed.)

Outcomes