:truncated to give zero or only 1 character result instead of 4 or 3

I want to generate a code from User VAT ID first 4 + last 2 characters + user’s company name’s first 3 character. truncated to 4 gives no result, truncated to 3 gives 1 character.

See this example - screenshot from database and Workflow change user referral code

VAT ID: DE314842978
Company Name: PepMelon

result should be: DE3178PEP
it gives: 78P

I tried write it out preview, the result is the same. User Data saved before calculation, in another workflow. VATID is in the database at the user. Also not a privacy question, because in that case “:truncated from end to” would not work either. So it should do the work.

Any idea?
Thanks in advance!

Screenshot 2022-05-04 at 13.47.52
Screenshot 2022-05-04 at 13.48.55

Hi there, @eva.puskas… I’m guessing you are running into an order of operations type thing because I just created an example using the new (experimental) parentheses feature, and it works like a charm.


Hope this helps.



Works like a charm! thank you so much! Hopefully it will be launched, I don’t know how it worked at other apps before this… Anyway, thank you very much!

1 Like