I have two multiple select fields that I am joining into one field. The items are showing in reverse order. is there a way to show them in the order in which they are entered in the multiple select field?
I don’t think so I’m afraid. I was trying to think of how to do this and what I could come up with seemed really over engineered
We’d need a table where each record represents a single option and the time it was created, linked back to the original record. We’d then need an automation that would trigger whenever an option was added or deleted, and it’d need to be able to either add or remove a record from that new table based off of the current options, and the simplest way to find the difference would be with a script I think, and then you’d use a look field in the original table to display everything, sorted by the created time of the record
Hopefully I’m overlooking something super obvious and someone else has a better idea!
UPD: just figured out you mentioned ARRAYJOIN. But I can’t remove my answer, despite I replied 2 minutes ago.
Hi,
I just tried and it added in normal order.
Question is - how do you merge them?
Do you have common options in these two fields?

Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.