I have an NewForm whose DataSource is Final_Master(SharePoint List). And I am Submitting it using SubmitForm() function.
This form has 6 text Box and 3 Combo Box(Choice Columns in SharePoint List)
Issue 1 : Now I want to Add/Delete options inside the combo box so that when a user is filling the form he can have the updated options to select from.
issue 2 : The reason i am using a combo box instead of a Drop down is with combo box i will see only the unique records.
Please help.
I do not believe that a user can add options in a Choice type column in SharePoint. However, If you changed the column type from Choice to single line of text, you could use Distinct() to create the options for a dropdown or combobox and Patch() a user created value to that type of column. It would then be picked up as another option in the dropdown or combobox subsequently.
User | Count |
---|---|
259 | |
108 | |
93 | |
57 | |
40 |