Well, I'm not a programmer but I think I can find my self around Google Script. PHP and others are somewhat intimidating for me at this stage :) I have a form that logs account managers' activities in a sheet named "activities". These activities can be towards either a lead or an account. There's another sheet called "contact list", in the same spreadsheet, which holds the contact details of all such accounts and leads. I have been able to populate a form question dropdown with the names originating from "contact list". The downside is that this formId is updated when a user opens the form, which results in the dropdown containing all names, i.e. both accounts and leads. How can I update the dropdown based on a previous question "are you updating an activity for a lead or for an account"? I've read numerous other posts, such as this one. All of these are based on PHP and others. I'd like to keep it simple and stay "within" Google Script. Thanks
Here's a demo sheet, which includes also a form and script. As you can see, the script populates the "client name" question in the form and it works fine (script copied from another post, which I cannot find right now. Thanks to author!). However, my goal is to have the first question "client type" populate the second question "client name" with only the names of the clients which are of the relevant type. How can this be done?
