Transform a list of usernames "type text" to list of emails "type text"

Need help Database
1

Hi everyone,

I want to transform a Custom State “Type List / text” to an other custom state “Type List/text”

For example:

State Names: John, May, Edward to be converted to:
State Emails: John@google.com, May@google.com, Edward@google.com

“google.com” is a constant.

Thanks in advance

2

Set state action, pick your new element and state #2, set the value to:
[Custom state #1 list of names]:format as text
This text then click off of it, click the empty space after and manually type @google.com
Make the Delimiter,

Then close out of the window, and do :split by ,

1 Like
3

Thanks @tylerboodman ! works perfectly

1 Like