Hi, So I started out trying to use this feature to add new values to a choice list on the fly without having to republish the survey every time, but I got very confused by this: "Please note that updating the itemsets.csv file directly in the Form item via this script does not update the values in the external_choices sheet of the associated xls workbook. It only updates the generated CSV file in the media folder. If you open the survey in Connect again, or download the survey to Connect from AGOL after you have manually updated the itemsets.csv with this script, there will be a difference between the external_choices sheet in xls workbook (original values) and the itemsets.csv (new values). If you re-publish the survey via Connect again without making any changes to external_choices sheet, the itemsets.csv will be replaced with the original values that are in the external_choices sheet." Does that mean that none of the changes to the choice list in the survey will occur until the external_choices tab of the xlsx has been updated manually? What is the point of the external file if this is the case? I feel like I'm not understanding correctly. I followed this post as best I could, but the changes were not propagating until I updated the external_choices tab. Discovering this, I scrapped the external csv file and instead focussed on just updating the choices tab (using FME) and using python to republish to the AGOL. I managed to do this, but the changes wouldn't appear in Survey123 Web or the Survey123 app. However, they would appear in Survey123 Connect. I think this has to do with the .xml that published along with the xlsx. If I make the changes in the XML, the changes show up in the Survey123 app (but still not Survey123 web). Is there a way to get around this? As I understand it, manually publishing with Survey123 Connect uses some API to convert the xlsx to xml. I'm guessing publishing with python as detailed above doesn't do this. The original xml is used which doesn't have the new values. Is there some way to publish (autonomously with python) an updated xlsx (just the choices tab) to AGOL and have it generate a new .xml so that the new values will correctly display in the Survey123 App? Thanks, Aaron
... View more