--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_StatusITUL-1 XYZZZZ +1 804 +1 804 Alpha 12345 Karl Lite LIT-1 12/12/2018 6 Accept Satisfied Need call Submit & NextThe above mentioned Google Spreadsheet always have the below mentioned data at backend:Ref IDCompany NameContact No.1Contact No.2Project NameAgent IDRest 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, EliteRef Code: LIT-1, LIT-2, LIT-3Status : Accept, Reject, PendingComment : Satisfied, Call Back, PendingBelow 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 NameNotesFinal_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.
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.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.
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.
--
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.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@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.
--
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.
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.
--
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.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@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.
--
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.