Relationship foreign key displays extra characters

[zedascouves]

Hello!

I've setup a MySQL database, and established the relations I need in Budibase.

I'm using the cloud hosted version, on the latest version (2.7.24).

I've auto generated a listing page for the table VIPS_Client, with create/update forms. The table that feeds these forms has a foreign key that relates to a parent table, so I have a 1-N relationship (VIPS_Country -> VIPS_Client).

My issue is that it seems that the relationship column generated by Budibase (VIPS_Country column in table VIPS_Client) is being populated with untreated values, so my form object looks like:

"VIPS_Country":["%5B2%5D"]

Instead of:

"VIPS_Country":["2"]

What is the expected behavior here?

Thank you for any help!

[zedascouves]

Ok, I've managed to make it work, and I think it really is a (major) bug. I've ejected the form components until I get to the save action button. There, I've changed the actions a bit and I now transform the picker value like this, on the "Save row" action:

{{ toInt (remove (remove (remove (remove (stringify Details Form.Fields.VIPS_Country) '%5B') '%5D') '["') '"]') }}

So, my action looks like:

This way I can select my "foreign key" element on the picker, and it'll save the correct ID on the row.

Although this solves the issue, it doesn't fix the underlying cause, which I believe to be an incorrect parsing by the Budibase platform