Google App Scripts Newbie Help

[Jessie Quema]

Hello Everone,

I am trying to create a google app script for a user form with user restrictions. The idea is to restrict users who is not a part of the distro list. The distro list will be saved in a separate google sheets. 

Either restrict or delete the response of the unauthorized user if the email address is not present on the list.

I tried several scripts using chat GPT but for some reason the script does not delete the response of the unauthorized user.

Any help will be  greatly appreciated.

Regards,

Jessie 

[Keith Andersen]

Can you elaborate how/what data is collected from the form that indicates a user status?

Can you show us the script that evaluates the data collected from the form and deleted or doesn't show the data depending on valid users input?

We need more information in order to help.

Cheers

Keith 

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/e475f5d0-4aec-4165-98c0-7adb3af0d64an%40googlegroups.com.

[Brett Grear]

Could you add a password to the form so only people with the password can submit. Just needs a question where the validation is set to only accept a particular string and the form can't be submitted otherwise 

[Keith Andersen]

Jessie,

A script can be written to check and delete any form submissions that don't meet any criteria you set. It can be done via a time trigger or a button on the spreadsheet.

You can import the distro email list to the form response sheet. The wrote the script on that sheet to filter and delete non-distro members submissions.

To help it would be useful to see your form submission sheet. Even if you wanted to make a mock one with similar data.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/46f836ce-06aa-4095-b8b0-ee6d13563d3cn%40googlegroups.com.

[Edward Wu]

You could probably do this in Google Sheets itself if you don't want to mess with coding.

e.g. you could create a new "valid responses" tab and do something like =query(responses!A:Z,"Select * where A = 'va...@domain.com'",1) and effectively ignore non-valid responses.

On Tue, Oct 3, 2023 at 2:28 PM Keith Andersen <keith.a...@gmail.com> wrote:

Jessie,

A script can be written to check and delete any form submissions that don't meet any criteria you set. It can be done via a time trigger or a button on the spreadsheet.

You can import the distro email list to the form response sheet. The wrote the script on that sheet to filter and delete non-distro members submissions.

To help it would be useful to see your form submission sheet. Even if you wanted to make a mock one with similar data.

On Tue, Oct 3, 2023, 2:10 AM Brett Grear <brett...@gmail.com> wrote:

Could you add a password to the form so only people with the password can submit. Just needs a question where the validation is set to only accept a particular string and the form can't be submitted otherwise 

On Saturday, 30 September 2023 at 13:38:28 UTC+1 Keith Andersen wrote:

Can you elaborate how/what data is collected from the form that indicates a user status?

Can you show us the script that evaluates the data collected from the form and deleted or doesn't show the data depending on valid users input?

We need more information in order to help.

Cheers

Keith 

On Sat, Sep 30, 2023, 4:08 AM Jessie Quema <jessie...@gmail.com> wrote:

Hello Everone,

I am trying to create a google app script for a user form with user restrictions. The idea is to restrict users who is not a part of the distro list. The distro list will be saved in a separate google sheets. 

Either restrict or delete the response of the unauthorized user if the email address is not present on the list.

I tried several scripts using chat GPT but for some reason the script does not delete the response of the unauthorized user.

Any help will be  greatly appreciated.

Regards,

Jessie 

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJ8MD4zzTMrxH8xRutRB%2BYUTnMZ1CSXgwAwaQ3XVpHa%3DcGEv2A%40mail.gmail.com.

[Keith Andersen]

Excellent point Edward!👍

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CABNTzmBoB-%2BMFxbRDvfe15pLwrq6t0b7W3tToE%2B3A2Y1Pzq2Vw%40mail.gmail.com.