Formula Question - Array, Case Contact Relationship

[esforim]

Hi all,

I'm trying to get the contactId using formula, and it seem to be an array. This field is by default so I should be able to get the information but I'm failing.

From fail experiment it seem to be an array data, but I can't get the actual ID of it. Anyone know how to get it?

The entity I'm using is Cases, I have tried various formula of attribute. (contact.contactIds for example), and array\formula(), and directly getting the info just using the fieldname itself but I'm failing.

Here some example of my failure:

contactsId
contacts.Ids
contact.contactsId
contact.contactsIds
array\at(contactsIds, contact.Ids)
array\at(contact, contactsIds)
array\at(contacts, contactsIds)
array\unique(contacts)
array\unique(contactsIds)
array\unique(contactsId)
array\length(contactIds)
array\length(contactId)

I either get nothing or just the word "array", or "0" hence the reason why I think I need to use Array formula

And here a screenshot of the default field/entity:

[esforim]

Off-topic: But would anyone know if Formula get run from top to bottom? So I would need to re-order the formula around the order I want it to be executed?

[Jakub Grufik]

yes I think the formula is being executed from top to bottom (I am 99% sure)

[esforim]

Thank you.

[Vadym]

Hi esforim,

Please try to use contactsIds attribute for array fetching or contactId for fetching the first array ID.

[esforim]

Hi esforim,

Please try to use contactsIds attribute for array fetching or contactId for fetching the first array ID.

Hi Vadym, thank you for your help but the image doesn't seem to work. When I quote it I can see a "Temp" tag and a Base64 encode so it might be only visible on your computer.

Not sure what the screenshot show, perhaps it have the correct formula?

[Vadym]

esforim Updated.

[esforim]

esforim Updated.

Thank you Vadym, I can see it now.

Can you tell me how to split those array?

I want to do something like this but not sure how to separate each of them:

So it become something like this

Contact ID: "2905151"
Contact ID: "940909fa"

[lazovic]

Try use this formula scipt (first test it in Formula Sandbox):

while(
$i < array\length(contactsIds),
(
output\printLine(string\concatenate('Contact ID: ', array\at(contactsIds, $i)));
$i = $i + 1;
)
);