CRUD Form via App Script

[Radcliffe Bromfield]

Good evening team, I'm new to this Apps Script and have been searching for examples of a CRUD Form to enter the data to a good sheet without success, but if I could be pointed in the right direction I'll try and assist myself as I don't really want someone to create it for me although I'd very much appreciate it and edit where I can like column names etc etc. 

Task: The idea is to have my team of over 70 persons enter data via the Form that send to a Google Sheet, then they can search a name and return entries from others and even themselves but don't have the option to delete or update, editing would solely be another 3-member team to edit the information on the sheet itself.

Respect and Thanks, keep up the good work y'all

Radcliffe

[Laurie J. Nason]

Depending on your budget(some features are paid depending on your GSuite version)  and time to learn it - I have found that AppSheet is an awesome way to limit users access to spreadsheets to only enter information or view information on a sheet.

------ Original Message ------

From "Radcliffe Bromfield" <ssinc...@gmail.com>

To "Google Apps Script Community" <google-apps-sc...@googlegroups.com>

Date 10/11/2022 03:16:38

Subject [Apps-Script] CRUD Form via App Script

--
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/0e8ea495-2690-4a99-ae55-66a8d5731ad9n%40googlegroups.com.

[Andrew Roberts]

Have you seen these Youtubes?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/embe6439f2-9b50-46d9-93a4-1bd28b8cd6b2%40351599be.com.

[Laurie J. Nason]

I hadn’t but looks like a lot of work (read working in html) which AppSheet does for you in the background.

------ Original Message ------

From "Andrew Roberts" <and...@roberts.net>

To google-apps-sc...@googlegroups.com

Date 10/11/2022 12:57:25

Subject Re: [Apps-Script] CRUD Form via App Script

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAN1QPJQidBmW%3D%3DOkeSOymdVNky1nvTO61oy%3DRczd1MMtQvcwHw%40mail.gmail.com.

[Radcliffe Bromfield]

Thanks for the responses, will look at the recommendations suggested but as you said pocket is very limited so I just wanted to start this by proving it can be done and then hopefully the organization will take it from there and invest into either further development or migrate the information to a database which can give specifically formatted reports.

Keep the suggestions coming, please and thanks.

Radcliffe.

[Raymond Wood]

If all you want is for members to search and view the information you might think about using Google Looker Studio( formerly Google Data Studio). I've managed to create lookup forms there and share them. Here is an example of a Phone App to lookup passenger waivers. Looker Studio is free and not too complicated.

[Radcliffe Bromfield]

Thanks will certainly take a trip there and see if it helps me on my journey... Respect

[Radcliffe Bromfield]

Is it used to make entries also, just enquiring if it is multifunctional?

[Raymond Wood]

Just a report not a crud.

--


Raymond Wood | Director
Cycling Without Age Society
Sidney, British Columbia, Canada
email: raymon...@cyclingwithoutagesociety.org
website: cyclingwithoutagesociety.com
phone: (250)516-6803

   

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/PRMvSY7nHdY/unsubscribe.
To unsubscribe from this group and all its topics, 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/1840987d-11fd-4f46-8f54-fe3441adf4aan%40googlegroups.com.

[Riël Notermans (Zzapps)]

Is Google Forms not helping you there.?

Op donderdag 10 november 2022 om 01:16:38 UTC+1 schreef ssinc...@gmail.com:

[Paul Armstrong]

Hi

I used app-script and the CardSerivce with Spreadsheets for storing data.

It works pretty well. You wouldn't want to rely on it in a transactional way. 

Resources

• This will give you an idea of what you can build https://gsao-card-builder.web.app/ 
• Documentation for Workspace Add-ons https://developers.google.com/apps-script/add-ons/overview
• Documentation for the Sheets API, https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app

Getting it deployed (beyond testing) can be a bit opaque. I can help with that if you get that far. 

[Radcliffe Bromfield]

It help to a limit for data entry however I need persons to be able to search for the last entry in that name (multiple entries are made for the same person weekly or monthly), get the results, edit the last result and add it as a new record to google sheet instead of updating it and overwrite the last entry. Thanks for your interest in helping me...

--

You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/PRMvSY7nHdY/unsubscribe.
To unsubscribe from this group and all its topics, 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/6314eb4b-63a3-42f7-8ec2-db09ed39539bn%40googlegroups.com.

--

Radcliffe A. Bromfield

[Radcliffe Bromfield]

Thanks for your suggestions, it'll definitely take me some time as a newbie to get the full understanding of it all....

--

You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/PRMvSY7nHdY/unsubscribe.
To unsubscribe from this group and all its topics, 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/28d4cddd-eec8-40e9-9fab-04627c462fefn%40googlegroups.com.

--

Radcliffe A. Bromfield

[CARLOS III]

Hello... sorry about my english but i have two questions about scriptlock to avoid collision...

I have 10 sheets in 1 spreadsheet and several users, so i need to lock when a user will use the code with the same sheet... im thinking in use one array with sheet name when get script lock and slice that value with release lock,this way i can use a conditional before lock just to lock that sheet found in array.

This is the question, using a conditional to check if i need to lock will be faster then lock code for all sheets? 

I need to make operations with numbers and get these results in these sheets so i need to lock the code to avoid collisions and get a correct values.

Someone have used cNamedLock and can tell me if this library its better than scriptlock?

Thanks.

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/CAKVE7LofRagvg2_TjHB57wrBPkx3WFVkVQcUqQT8DF6V%2BNAzNg%40mail.gmail.com.

[Lokan Luno]

fuck you all I need CRUD with image in App script