Using an Options Picker in an Update form - how to update the underlying field

[simon-lewis]

I am using an Options Picker connected to its own datasource for its values. It is linked to a table where I want to update the underlying value. On loading it correctly displays the current value of that field in the schema. When I change it and save the row, the underlying value does not get updated. I cannot see any particular problem. Do I have to code in an On Change action to the Options Picker to change the value of the field in the Form Schema record ?

(Relates to #11284 - this is the new form where I want to replace Relationships with Options Pickers for editing the underlying record)

[simon-lewis]

Hi Folks,

Looks like this is because I kept the defined Relationships in the table - so CouchDB / BB got its collective knickers in a twist when I tried to update them via other means (an options picker and data source separate to the current form).

When I deleted the underlying relationships then the Option Pickers on the Update form just worked. Yay !

I'll close this but wanted to post it up for information as the performance issues when using Budibase relationships may be a problem for others. You can relieve these but using your own JOINs and then using Options Pickers in place of Relationship Pickers in forms. Just make sure you delete the Relationships from the Data section in the Builder (I am using an external SQL Server database).

Si