Form Edit Error

[Patrizia Weber]

I currently have a form that has two sections.  I set up Form Mule so teachers can submit a referral which will automatically send me an email with a form edit URL so I can review the referral and then provide a response in the second section of the form (teachers only have access to the 1st section).  When I click on the link, it says "You cannot edit your response".  If I go to settings and turn on the "Allow response editing" it will change the original submission.  I'm not sure how to fix this. Help!

[Joseph Schmidt]

equestIf you want to be able to edit a form, the Edit option must be on.  That means the teachers could edit the form.

I don't know how you are preventing the teachers from getting to the parts of the form they are not supposed to see.

I prefer separate forms.  See request/approve.  It is rather old so there might be better formulas available. 

Everything is time stamped as to when it happened and there is no need for being able to edit responses.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Thu, Aug 17, 2023 at 2:58 PM Patrizia Weber <pwe...@neptune.k12.nj.us> wrote:

I currently have a form that has two sections.  I set up Form Mule so teachers can submit a referral which will automatically send me an email with a form edit URL so I can review the referral and then provide a response in the second section of the form (teachers only have access to the 1st section).  When I click on the link, it says "You cannot edit your response".  If I go to settings and turn on the "Allow response editing" it will change the original submission.  I'm not sure how to fix this. Help!

--
You received this message because you are subscribed to the Google Groups "NV Form Mule Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-mule-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/d6cd8433-cc93-46dc-97a9-644f35006d75n%40googlegroups.com.

[Bart van Dalfsen]

Hi Patrizia,

As Joe mentioned, you're trying to achieve something in the wrong way.

The form option "edit form after submit" is not meant for the receiver (you) but the submitter of the form.

If I were to submit a form to you it allows me to correct data entered in my form submitted earlier.

You as receiver should not change anything on my form because we would get a dispute over what I entered.
That's why you have to sign-in into the exact same Google account to change the data on the form.

And you with your account not being me with my account cannot change my form.

Trying to trick this is not recommended as Google will certainly fix this as a security /  data integrity issue.

My form, my responses, my changes, Google certified.

If you do not mind submitters to changes their answers on submitted forms, do not enable this feature.
You cannot use forms as a rolodex cabinet as you technically do not 'own' the cards or the data on it.

End of story.

Now from your perspective, the receiver, you might want something else based on the data (response(s)).

Add a column to the sheettab with the FormResposes next to a response-column you'ld like to have another answer,

and name/tag this in the cell on the first row with 'Adjusted' and the question name.

For example, you have a form-question "Age" and someone replies: "twelve years" or "i am 14".
You did expect a number - and did not apply any validation method for the question in the form -  so that's why you'ld like to change it.

In the new column "Adjusted Age" you could enter 14 or 12 yourself manually to avoid overwriting the actual data submitted on the form.

If you require one column with the age in numbers you could add yet another column named with a formula like:
=ARRAYFORMULA( IF ROW(X:X)=1, "Age Validated", IF(LEN(Y:Y)=0, X:X, Y:Y))

X:X being the response column with "Age"
Y:Y being your suggested data "Adjusted Age"
Z:Z being the column labeled "Age Validated" containing the Age data with your overruled data when applicable

example:
    Age     |  Adjusted Age  |  Age Validated

        23  |                |             23

i am 14     |            14  |             14

        41  |                |             41

        35  |                |             35

twelve years    |                         12  |             12 

        17  |                |             17

As a final note and thought.
In Europe the legislation on data-privacy is very strict on what you may an maynot do with personal data.

I do recommend not to just email yourself a whole copy as Google severely restricts the amount of emails you can send on a daily basis with methods like FormMule use. And you do not need yet another copy of the same data in both your sent folder AND your inbox as this is completely inefficient imho if you got everything in the sheet already :)
Besides, you can set within the attached sheet a trigger to email you when a new form has been submitted or via a notification on your phone.

Now the reason you'ld like to use FormMule is when you want to automatically notify someone her/his request had been granted, fulfilled or rejected.

Based on the conditions you define within the sheet ;)

HTH and regards from the Netherlands, Bart.

Op do 17 aug 2023 om 21:20 schreef Joseph Schmidt <glua...@gmail.com>:

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/CAPWPTOTdy_KDQsKHAn45DQRWo_2gZ48NDzEkyV7MOpN4Q9LNeg%40mail.gmail.com.