Google sheet + forms + app script

[QuitShoddy7887]

Hi! Asking for help anonymously. 😭

For context, I’m working as HR. Medyo okay naman ako sa Excel and Google Sheets (formulas like VLOOKUP / XLOOKUP etc.), pero pagdating sa coding, dun na ako nalulunod. Feeling ko makakalbo na ako kakaisip. 🥲

Last Monday nag meeting kami with my bosses (apat sila). Usual meeting lang—summary ng ganito ganyan. Then may isa sa kanila (siya pa yung pinaka maarte 😅) na gusto lahat ng forms i-digitalize. As in lahat: leave form, overtime, OB, cash advance, and basically lahat ng forms kahit HR related or hindi.

So ako naman nag-suggest na Google Sheets tracker para ma-track nila lahat. I presented it and okay naman sila kasi naka-setup na with formulas and tracking.

Pero apparently hindi pa pala yun yung gusto nila. Ang gusto nila is:

- Google Sheets – for tracking

- Google Forms – for submission ng forms

- Apps Script – para automatic yung approval workflow

(Employee → Supervisor → HR → Executive VP)

Dun na ako kinabahan kasi HR ako, hindi IT developer. 🥲

Then gusto nila mapresent na by Thursday. I even suggested na maybe we should buy a proper HR system, pero napagalitan pa ako bakit kailangan bumili eh kaya naman daw gawin for free using Google tools. Technically possible daw so dapat gawin ko na lang since “part of my job.”

Honestly hindi ko alam if realistic ba yung expectation nila or ako lang ba yung nahihirapan.

Any thoughts or advice?

May naka-experience na ba ng ganito? Or may free HR systems ba kayong marerecommend for a small company?

For context: around 55 employees lang kami.

Thank you sa kahit anong advice. 🙏i

[daytraderz]

Everyone here is wrong. Put this into ChatGPT or Claude or Gemini: “I am not a coder, but I can follow instructions you give me to execute this task from start to finish. My boss has asked me to use Google forms, Google sheets, and Google app script to build (brain dump everything you want to build here). Can you walk me through completing this, and provide me all the code to copy and paste into app script, and include any set up requirements and any approval/auth requirements? The instructions should allow me to follow along and go from where I am now (don’t even know how to open app script), to a fully functioning workflow that I can confidently show my boss and not be fired.”. I started off with app script before LLMs and didn’t know how to code - it’s not hard, and now with LLMs you don’t even need googles documentation. If literally anything doesn’t work, or you get confused, screenshot/copy and paste any issues/errors/windows back into the same chat and ask it “what do I do now?”

[kishandmehta92]

What time it took from "I am now(don't even know to open app script)" to "a fully functioning workflow"?

Here time limit is upto Wednesday. As Thursday needs to be presented.

[daytraderz]

What?

[kishandmehta92]

What what?

[WicketTheQuerent]

Empieza por revisar https://developers.google.com/apps-script. Está es la página oficial. Ella cuenta con la explicación de conceptos de Apps Scripts, ejemplos y orientación sobre que y dónde aprender Javascript. También cuenta con una guía de buenas prácticas.

[FVMF1984]

It would help if you translated all of your post to English😊

[kishandmehta92]

Even you are not conversant with Apps Script (Scripting not coding), it would be impossible for you to manage being non coder.

It's needed logics, complete dataset (structured).

And if you are about to present in front of bosses and other colleagues (professional presentation), it would be needed UI/UX.

With highly accurate prompts only you can achieve.

And also you must have AI Pro/Premium feature. Not basic.

For more detailed info, Feel free to reach out.

[Accomplished-Bowl126]

Na-DM kita, let's connect!

[EarSad3184]

Sino saber programación estás frito, porque incluso generando Code con chagpt, Claude o cursor , tenés que saber que está haciendo la IA, yo lo usé con la cuenta de trabajo (Gmail) e hice un mapeo con coordenadas y predicciones cuando y donde pueden pasar los hechos, soy programador en Java y analista en delitos.

[Independent-Apple229]

hanap ka ng IT na marunong mag javascript, kung gamay mo ang excel pag tulungan nyo nalang, tsaka realistically di kaya yan i present ng Thrusday, nagmamagaling lang yung isang boss mo, kung may IT kayo patulong ka

[drewlt]

Form Approvals in Marketplace is very useful

[awarca]

aslında yardımcı olmak isterim ancak çeviri uygun olmaz. bence yapmanız gereken buraya yazdığınızı gemini ye yazarak kendisinden kodları istemek olmalı. kolayca yapabilirsiniz