Hello,
I have a form with different fields including one which is an ID in my SharePoint list.
This field cannot be modified by the user so it is automatically displayed on screen with this formula : Last(Devis).Num_devis+1
- Devis is my datasource
- Num_devis is the name of the field (Example : 500)
Everything works fine when filling and submitting form. There is variable varLastDevis initialized with Form.LastSubmit.
After submit is successful, I am switching the form to ViewMode so the user can possibly view/edit his data before going to next step.
However, just after submitting/switching to ViewMode, Num_devis takes +1 (Num_devis = 501) like it is a new form despite my variable and my formula :
If(
IsBlank(varLastDevis.Num_devis);
Last(Devis).Num_devis + 1;
varLastDevis.Num_devis
)
Worst part is here : when I go to the formula, it shows that varLastDevis is not null (Num_devis = 500). If I type one space then delete it, the correct expected value eventually calculates correctly (501 turns into 500).
I have tried to reset form, control : nothing works.
Thank you guys 🙂
