Re: [Apps-Script] How to create HTML From using googlesheet as a database

81 views
Skip to first unread message
Message has been deleted

Jacopo Rumi

unread,
Dec 12, 2019, 3:01:51 AM12/12/19
to google-apps-sc...@googlegroups.com
Why don't you use Google Appmaker for that?
It would as easy as 1,2,3 :)

Il giorno gio 12 dic 2019 alle ore 06:36 Techies HR <hire.t...@gmail.com> ha scritto:
I have a google spreadsheet, where some rows append on daily basis and using the google spreadsheet, the customer feedback team follows up.

Google Spreadsheet Data.

    Ref ID        Company Name       Contact No.1     Contact No.2     Project Name Agent ID Client Name Product      Ref Code         Date        Days Passed     Status    Comment    Notes      Final_Status
    ITUL-1        XYZZZZ             +1 804           +1 804           Alpha        12345    Karl        Lite         LIT-1            12/12/2018  6               Accept    Satisfied  Need call  Submit & Next

The above mentioned Google Spreadsheet always have the below mentioned data at backend:

Ref ID
Company Name
Contact No.1
Contact No.2
Project Name
Agent ID

Rest of the mentioned details would be captured from the HTML UI basis the user response and finally click on 'Submit & Next' or 'Next'.

The User has to first enter the 'Agent Id' on HTML UI and accordingly one by one `Ref ID` detail would be given to particular 'Agent Id` user. 

As mentioned in the attached screenshot, The left side of the information would be static as per the googlespread sheet, and right hand side information would be filled by the user basis the telephonic conversation.

Below mentioned particulars will be drop down or radio options basis user input:

    Product : Lite, Lite-I, Elite
    Ref Code: LIT-1, LIT-2, LIT-3
    Status  : Accept, Reject, Pending
    Comment : Satisfied, Call Back, Pending

Below mentioned particulars will be derived:

    Days Passed: It will be derived from the current system year - year mentioned in the `Date`

Below mentioned particulars will be user input as a free text.

    Client Name
    Notes
    Final_Status

**Note:** The agents will be assigned and shown only those `Ref ID` where the `Agent ID` is not blank and `Final_Status` is either blank or other than 'Submit & Next' marked in Googlespread Sheet.

We need to add one more column in the Googlespread sheet, Which capture the Date time stamp as per the system date as soon as the `Final_Status` marked as 'Submit & Next` or 'Next'

Submit & Next button would only be enable if all the details are captured by user. 
Next Button would only be enable if `Comment` option is selected.

Test.PNG


--
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/8e363429-43fb-4cac-845a-b4361fe145fe%40googlegroups.com.

Techies HR

unread,
Dec 12, 2019, 3:25:20 AM12/12/19
to Google Apps Script Community
Hi Jacopo Rumi,

Thanks for your comment, It really relived me ;)
I am not much familiar with Google Script that why I have posted this question to understand how I can achieve the required output.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.

Mani Doraisamy

unread,
Dec 12, 2019, 3:33:21 AM12/12/19
to google-apps-sc...@googlegroups.com
Do you want to try Formfacade - https://gsuite.google.com/marketplace/app/formfacade/743872305260 ? (Disclaimer: I created it) 

It's converts Google forms into the UI you are looking for. Google forms can update Google sheets automatically without the need for code. 



To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

--
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/78e66d53-0202-485b-bd3c-7fadffdbd2ee%40googlegroups.com.

Techies HR

unread,
Dec 12, 2019, 3:40:01 AM12/12/19
to Google Apps Script Community
Hi Mani,

I Need to create a very basic UI, of which url can be shared to multiple user who will do the data entry and response get captured into the googlesheet accordingly.

The details of next Ref ID automatically gets populated on UI after user click on the 'Submit & Next' or 'Next' as per the logic mentioned below trail.

Thanks :)
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.

--
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-community+unsub...@googlegroups.com.

Jacopo Rumi

unread,
Dec 12, 2019, 6:33:59 AM12/12/19
to google-apps-sc...@googlegroups.com
My pleasure!
There is a group dedicated to AppMaker, which uses Apps Script as its language, where you can ask for help.

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

--
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/78e66d53-0202-485b-bd3c-7fadffdbd2ee%40googlegroups.com.

Techies HR

unread,
Dec 12, 2019, 6:38:04 AM12/12/19
to Google Apps Script Community
Please help me to get the desired solution.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.

--
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-community+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
Message has been deleted
0 new messages