I have two screens in my app, but on the first screen I send a form and then I need the same line with some fields and I am not getting it right, here is my code:
In the "OnSuccess" of my form there is this code:
Set(varLastID;Last(Table).ID))
SubmitForm(Form1);;
NewForm(Form1);;
Patch(Table;
LookUp(Table;ID=varLastID);
{IDFORMATED :"PERL"&Last(Table).ID);
Column1:TxtInput1.Text;
Column2:TxtInput2.Text;
Column3:TxtInput3.Text});
My mistake here is not saving the ID correctly, it saves the last ID in the previous item and the new ID in the new item, i.e. it looks like this:
ID: IDFORMATED (Columntext):
2 PERL3
3 PERL2
And I want it to do that:
ID: IDFORMATED (Columntext):
2 PERL00002
3 PERL00003
