What should we use to insert a unique Id along with the responses?

  • Profile Image
    Asked on October 21, 2019 at 05:38 PM

    I want to make sure that there is a unique submission ID assigned to each request.  We are using a thirdparty bot to take the information from jotform to smartsheet.  I didn't know how to display (as read only) the submission ID so I used the unique ID widget.  I want this ID to be listed on both the traveler's request form (although it's not a big thing) and I want it listed on the supervisor's approval form.  Is this the best ID to use or should I use the submission ID?

    Currently when my bot  receives the information it is adding a new record when a person submits a new request, when the supervisor approves/deny the requests and when a person edits their information.  I want the bot to recognize the ID so that it just updates the record when it sees something unique.

  • Profile Image
    Answered on October 21, 2019 at 09:09 PM

    You can use any of them. Both submission Id and unique Id should work. It seems your bot is not recognizing the unique Id the second time when the submission is edited. In your logic, you can make a check if the unique Id is the same then update the table.

    You can also give a try with the submission Id.

    Let us know if you have further questions.