Greetings - I’m using arrayunique(value) for rollups to scan shopify orders and copy over information to my customer, including phone number and delivery day. Problem is when I receive 2 or more different values, I need the most recent one only. How would I compare date values and return the most recent non-blank value?
How to select the most recent arrayunique(value)
+27Try using MAX(values)
Try using MAX(values)
I did - that returns zeros. I also tried Max(arrayunqiue(values)) and got zeros as well. So - I need to check the Created Date of each unique record and only return the text fields from the most recent created date. I just don’t know how to do that yet.
+27I did - that returns zeros. I also tried Max(arrayunqiue(values)) and got zeros as well. So - I need to check the Created Date of each unique record and only return the text fields from the most recent created date. I just don’t know how to do that yet.
You’ll need a similar process as described here:
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.