Database Builder v1

[Keith Andersen]

Video: https://youtu.be/Nldg7lIqjdU

Greetings All,
Sharing a project I worked on for a while. It is a Google Sheets / APP SCRIPT no code database builder with auto adjusting sidebar for CRUD operations. Build as many as you like - one sidebar that creates forms based on database schema data. 

Includes a Database to CSV option for backup for each database created.

I'm not perfect, in fact I'm a novice coder who loves Google Sheets and APP SCRIPT. I've tested it...but I could have over looked something. If you find flaws/errors please email me or let me know in response to this thread. Comments, ideas or improvement suggestions welcome.

Make a copy of this VIEW ONLY link to give yourself editor access. I will ignore requests to give editor access. 

Sheet Link here: https://docs.google.com/spreadsheets/d/11V6sGn6N1dBwyT2gYcFlSFjRiRoGdXi4LztE-X00RmA/edit?usp=sharing

And link in video.

Cheers - hope it's useful to someone.

Keith  

[GRADD - Jim R.]

Keith,

I am interested in looking at this. I do Genealogy, and I can see a purpose for using this. I will let you know as I don't have a lot of time in the day to work on it, but I will do what I can.

[Keith Andersen]

Tks

 Hope it's useful for you. 👍😁

Keith 

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

--
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 visit https://groups.google.com/d/msgid/google-apps-script-community/36ca1ca9-1a3f-4216-84ab-877fcd8a3ed7n%40googlegroups.com.

[GRADD - Jim R.]

Keith,

The Sheet won't allow me to make a copy.

[Keith Andersen]

I made it accessible with anybody who has a link. Try replacing edit in the URL with copy. 

I'll be on the computer in about an hour and a half. I'll look into it then more. Sorry for this.

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/0109c04b-3638-4b65-b8ec-47ca534a71c1n%40googlegroups.com.

[Keith Andersen]

Seems to be working now. I got the link from the video and opened it in incognito and it allows me to copy.

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

[GRADD - Jim R.]

Keith,

That worked. Thank you so much!

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/CAFKgK%2BGhDdSHcA6w9DYzMgdj5pgw6CciyRoPfiEOvuspD3xrtQ%40mail.gmail.com.

--

 Jim Ray

Retired, but still vigilant

FAASTeam DronePro

[Júlio César Valladares da Fonseca]

Não vi, ainda, mas já gostei da ideia.

Parabéns!

Júlio César Valladares da Fonseca
(21) 97396-1195, (21) 2681-4885 e (21) 2695-5877

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/CAJYcAc_YANRsP75X6xiBqF2xWWC%2Bpp51Y3%2BpRWvMBaWzb6iQLw%40mail.gmail.com.

[GRADD - Jim R.]

Keith,

This  APP Script is awesome!  My mind is exploding with the uses this APP Script can be used in my Genealogy research.

This is a great start, and I look forward to seeing your progress on the script.

Well done!

[GRADD - Jim R.]

Keith,

This is the only question I have. What is the Exclude GID, and when building a list, how do I know what the Exclude GID is?

Gender

Exclude GID

Male 

1179454792

Female

577512990

Other

1830943958

[Keith Andersen]

In the Simple Menu there is an option to add rows or subtract rows and columns. You want to protect the sheet from this menu item. You can add the GID to that range and if someone tries to add or subtract a row on that sheet it will tell them it's protected..

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/02e4af01-3b68-4480-bdaa-bada424d696fn%40googlegroups.com.

[GRADD - Jim R.]

Keith,

Excellent and thank you again.

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/CAFKgK%2BFGh63DpXWWVhyGRyTtC8Lq36QJP2qiDwhF0rHDz%2B2Dnw%40mail.gmail.com.

[Keith Andersen]

And thank you for the kind words. I hope it's useful for you.

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/CAJYcAc9YULm0cwZikZBxuP_guHHD9X7QKD7uPsLv1YDeVUt3vA%40mail.gmail.com.

[GRADD - Jim R.]

Keith,

I was good talking to you today brother. Your APP is teaching me a lot and I hope to learn more by looking at it deeper.

I look forward watching your Youtube to learn even more.

Here is a link to my APP. I plan on merging some of my functions into one. Please feel free to comment on it. I want to do more with it, but not sure what yet. LOL

https://docs.google.com/spreadsheets/d/1HdNcwH0zADR0wMY0a9cLEihF92gYxpAGVT4F3EwdQ7M/edit?usp=sharing

I have included a sample GENCOM to play with.

Here are the steps to take.

Place the file on your local drive.

1. Select GEDCOM Tools

Be well my friend and God Bless ya!

--

 Jim Ray

Retired, but still vigilant

FAASTeam DronePro

[GRADD - Jim R.]

Keith,

Thanks again and the Google sheet looks great! 

I screwed up my lower back the other night. There were supposed to be 4 of us setting up 140 drones. One didn't show up and the other one didn't do crap. So old man did what was needed and in the process, I screwed my lower back up.

These are old injuries from being an LEO and I knew better, but things needed to get done. 

Still it was fun and I have included a link to my Google Photo so you can see what we do.

I'll check back in later this week.

Take care and be well brother.

https://photos.app.goo.gl/wf4StZ97ixRaKSRg6

[Keith Andersen]

Thanks for sharing that. Those were cool pictures and videos. Lots of work. 

I hope you're back gets better soon. 

Cheers 

Keith 

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

--

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 visit https://groups.google.com/d/msgid/google-apps-script-community/CAJYcAc-prGKEhLNN%2Bug1EGLyax5MjV5Qv%2BAQ7B756mWDkCTMqg%40mail.gmail.com.

[GRADD - Jim R.]

Keith,

Thank you buddy and talk to you soon.

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/CAFKgK%2BG3%2BGLk33GUMXBgoLON0fGhYZ7cNbp334y7v9H04fEDZQ%40mail.gmail.com.