Hi,
I have a table with 3 columns.
I want Dropdown1 (Column 1) to display the value based on datacard1 value (Column3).
I need this to be in the default of Dropdown1 so that it does not change once saved.
I'm only submitting/updating data from datacard1 to the table.
| Dropdown1 | Something | datacard1 |
| A | 1 | 1000 |
| B | 2 | 2000 |
| C | 3 | 3000 |
So I would like to have "C" as default when datacard1 is "3000"
Anyone who can help?