Forum Discussion

Tom_R's avatar
Tom_R
New Contributor III
2 days ago

Cannot save same value from parameter twice in SQL Table Editor

I have created an SQL table editor component for one of my applications.  One of the columns in the SQL table can be updated by the user, and is tied to a parameter that is used as a dropdown by the users. 

However, if the user tries to update that column in two rows to the same value only the first row will be saved, but if the two rows are populated with different values from the linked parameter the table is saved just fine.

Has anyone else experienced this?  Has anyone discovered a workaround?

Thanks,

Tom R

Dashboards
Parameters

1 Reply

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 days ago

    Trying to understand this better... Let's say your column is "Color", and when you update the column in two different records, to say "Blue" and "Green", your dropdown tied to this column now shows "Blue" and "Green" as choices.

    Also, if the user updates those two records to both be "Blue" and "Blue", you want the associated dropdown to list "Blue" twice?

    When you say "One of the columns in the SQL table ... is tied to a parameter" is it bound to the column?  If so, consider creating a parameter that queries the column in your table directly to get the full contents.