Pain point · Reliability & bugs · Blocks work
Relationship dropdown value is malformed so foreign key is not saved
3 source threads · first seen 2021-10 · last seen 2023-08
Summary
A relationship picker in a form returns a field value with unparsed characters, so rows with a foreign key to MySQL or MariaDB cannot be saved. The user cleaned the value with a long Handlebars expression.
- Affects
- user with MySQL/MariaDB relationships
- Workaround
- Clean the form field value in the Save row action with Handlebars helpers
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“A relationship picker does not render selections properly, and does not provide all the available rows for selection”
“This prevents the row from being saved, as the foreign key is invalid”
“Trying to use PostgreSQL v13.4, getting an error while editing a row”