Custom Form + Form Submissions

Hi all,


I've got a weird thing that's randomly stopped working and I can't work out why.



I essentially want a custom form submissions to be set "live" on create, so public user can view them in an asset listing. This has worked in the past, not sure how, but now I'm seeing the following:



[list=1]

  • User fills out custom form.
    [*] User clicks "Submit" and gets the "Thank You Page". Any emails are sent out from the form, the user's job is done.
    [*] A form submission is created in the "Submissions" folder in "under construction" status, so public user can't see it.
    [*] An administrator goes in and views submissions, picks out the newly created one, and views it. All the responses are there.
    [*] Administrator sets it to "Live" so public user can see it, and then all the responses are blanked out. The user input is lost.


    Is this normal? It's reproducible in v4.0.4 and v4.6.2, and I just don't understand how I never noticed this before, and furthermore how it's any use whatsoever. Has this always happened? Am I going mad?
  • [quote]
    Hi all,



    I've got a weird thing that's randomly stopped working and I can't work out why.



    I essentially want a custom form submissions to be set "live" on create, so public user can view them in an asset listing. This has worked in the past, not sure how, but now I'm seeing the following:



    [list=1]

  • User fills out custom form.
    [*] User clicks "Submit" and gets the "Thank You Page". Any emails are sent out from the form, the user's job is done.
    [*] A form submission is created in the "Submissions" folder in "under construction" status, so public user can't see it.
    [*] An administrator goes in and views submissions, picks out the newly created one, and views it. All the responses are there.
    [*] Administrator sets it to "Live" so public user can see it, and then all the responses are blanked out. The user input is lost.


    Is this normal? It's reproducible in v4.0.4 and v4.6.2, and I just don't understand how I never noticed this before, and furthermore how it's any use whatsoever. Has this always happened? Am I going mad?
    [/quote]

    Hi Ash,
    This shouldn't happen so I test it on my local Dev system. Setting the submission to LIVE isn't affecting the answer on it. Something else must be going on here. Is there any trigger affecting this process?
  • Actually I just figured out that if the status is changed without acquiring locks, the answers are indeed wiped off. Smells like a bug. And pretty serious one for that.


    I think you can for now workaround by making the Submissions assets LIVE after acquiring locks on the asset until we figure out and squash the Bug :wink:



    Thanks for bringing it to our attention.



    Ash (I know Right!)

    Cheers Ash, that's really handy to know.

    Excellent, glad to know it's not just me.


    The actual issue I had (and I'm kicking myself for not checking it) was because to the trigger that had been setting these assets "live" wasn't working, likely due to the bug/feature where triggers break when you modify the target root node.



    In any case, I'm happy now. Thanks for you replies. :slight_smile: