Help

Pull Linked Record in order

Topic Labels: Formulas
518 0
cancel
Showing results for 
Search instead for 
Did you mean: 
asejm_2
4 - Data Explorer
4 - Data Explorer

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

8b0aa644ca6f70487f74b67461d78328d47bf653.png

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?

0 Replies 0