Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

SAVEDID sequence only for completed submissions

  • rcmorais
  • rcmorais's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 3 months ago #225595 by rcmorais
Please help us help you and fill where relevant:
Your LimeSurvey version: Versão 3.18.0+190923
Own server or LimeSurvey hosting:
Survey theme/template: IHRU
==================
Hello,

Each time a user interacts with a form the system gets a sequenced id, is it possible to get that sequence only for the completed ones (only when the user clicks on "Submit")?
If the user access to the form, interacted with some questions but didn't complete it, I get a number id for that. Let's say the first three users are in this scenario and the fourth fill-up the form until the last question and effectively submit it, he'll get the number 4, when it should get the number 1.

How can I get to a solution for this?

Thank you

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 3 months ago #225599 by tpartner
This is not possible, the ID must be created when the first page is submitted because a response row must be created in the database table.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: DenisChenu, rcmorais

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
3 years 3 months ago #225616 by DenisChenu
Replied by DenisChenu on topic SAVEDID sequence only for completed submissions
With 5.X : maybe an idea : adding an expression question at the last group with {sum(statCount("id"),1)}

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The following user(s) said Thank You: tpartner

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose