Pull Linked Record in order

I feel like this question has been asked before, but I cannot find an answer or post that really applies.

I have a form where users can input/sort options from one table (a hacked ranking system). Once they the form is submitted, I then want to figure out an automattion using basic text fields, or have multiple formula fields pull the records 1 by 1 into the separate fields in the order they’ve been input by the user’s form submission.

A, B, C record order

Field 1 = A
Field 2 = B
Field 3 = C

I’ve looked at arrays, converting to strings, tried the string lengths by using the shorthand info, this seems like something I used to do all the time in others, but it’s very clear arrays of data are not well managed in this?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.