Is this achievable ?

(0) Share

Report

Posted on by Archetype

411

Hello mates,
I hope you all are fine, i need your help for an encountering issue. My customer normally used to use excel to define automatically the id of his project. Every new projects he increments + 1 to the ID number like the example below :

My idea is to get the ID from the field order number in PSA and to paste it in another field, but i dont know how to achieve this. I think its with JavaScript :

Cordialy

All responses (2)

Answers (1)

Archetype 411 on at

Like (1)

Report

RE: Is this achievable ?

Hello, thanks you very much, its working perfectly ;)
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

RE: Is this achievable ?

Hello,

I believe you don't need JavaScript for that purpose. You can use the "Calculated" field instead - docs.microsoft.com/.../define-calculated-fields

To be more specific formula should look like the following - TRIMRIGHT(TRIMLEFT(IDFieldHere, 4) , 7)