Using ID in a form

[d3ell]

Hi, hope someone can help,

In order to make all my records unique I have adopted a job reference which incorporates the ID of the record as part of it.
I have a field in my form for job reference and it creates a value which consists of the record ID reference / the property address / our error code

What seems to be happening when I save the form is that the job refernace which should look something like 34/254/E5 is coming up as /254/E5 so the field is saving the value of the property address “245” and the error code “E5” but it seems to not be able to get the reference ID until after the record has been saved once using ‘SubmitForm’

Is this because the ID reference of the record isn’t issued until the form is saved?

Once the form is saved you can see the full reference in the files, but you have to press save again so that it writes it too the data source.

I have tried SubmitForm(formname);SubmitForm(Formname) but I just get an error.

Is there a way to update the record, before the form is submitted so that the job reference is written to the data source correctly first time?

Sorry if this doesn’t make clear sense, found it hard to explain what I’m trying to achieve!

Thanks

[RandyHayes · Accepted solution]

@d3ell 

Is this because the ID reference of the record isn’t issued until the form is saved?

Yes, that is exactly why.  An ID is not issued until the record is created.

What you can do easily is just adjust your submit to something like the following:

SubmitForm(FormName); Patch(yourDataSource, FormName.LastSubmit, {jobReferenceField: FormName.LastSubmit.ID & FormName.LastSubmit.jobReferenceField})

This will prepend the last submitted jobReferenceField value ("/254/E5" in your example) with the ID ("34" in your example.  Result is what is desired.

Give it a shot and I hope it helps.

[d3ell]

Thank you that has worked !

Much appreciated! 🙂