Editing/Updating ContactList or Dropdown Items via the API
We are making good headway pushing data from our CRM to SS with the API with VB and C#.
One of our sheets needs to have a column with a list of (regularly changing) people for the users to select from in a ContactList or Dropdown control. I believe it is not possible to draw these lists from another source sheet for these controls as yet.
This list of people is automatically kept up to date on our SQL server for use locally, so I want to be able to push the updated values/list (clear and rebuild the list), into the actual list of available people in the SS sheet control, for the users to pick from manually.
I am not talking about pushing/selecting values in the cell with the API, but updating the possible selections for the users to pick from.
Is this possible?
If so, any clues please?