Multivalue Separation and Report

asked on August 28, 2024

Hi Everyone,

I have an issue that I can't get my head around it, I'm hoping the community can help me.

I have a multivalue field that records data as following;

Bob - Fileno1
Bob - Fileno2
Bob - Fileno3
Chuck - Fileno4
Chuck - Fileno5
Mike - Fileno6
Mike - Fileno7
Mike - Fileno8
Mike - Fileno9
Anthony - Fileno10

As you can see the first value is a user and then unique file numbers. I've been asked to separate these values for the associated user and send it in an email with the count of their file numbers and the file names on a weekly basis.

There are over 30 users on the first value and I dont want to use 30 different conditional sequences and can't get my head around how to separate them for each individual and put it on a token.

I'm sure there is an easy way. Would you be able to point me the right direction please?

Thank you!
Onur

0 0

SELECTED ANSWER

replied on August 28, 2024

If that pattern is consistent and reliable, you could use pattern matching or token editor functions.

My approach would be to use split; you could split on the dash, include the trim function clean up whitespace, then the first index would be the name, and the last index would be the file number.

Since this is a table/collection in Forms, I'd do the following:

Use a for each row loop on the table/collection
Use the token editor functions on the current row value in the loop

If you just use the functions in the screenshot the output is a multi-value, so you could either store that to a multi-value token and reference the first/last index, or just use the split combined with the index in two separate tokens.

2 0

replied on August 29, 2024 • Show version history

Hi Jason,

Thank you for the tip, I managed to get it done with your reference.

Thanks!

0 0

Question

Question

Multivalue Separation and Report

Answer

Replies

Sign in to reply to this post.