htatd
April 13, 2022, 7:32am
1
V4.7.3 - Nodejs - Postgresql - Macos
Hi!
I’m trying to update a table’s multi reference values, but values are not saving.
I’m using the exact same method for the update as I did for creating the initial values, which doesn’t have any problems.
Don’t know if it’s a bug or something that I do wrong
For creating the values I did this (which works)
Which works:
Same exact method with update (Doesn’t work)
Which doesn’t work. Form submits successfully but users or products multi references are not updated. (other normal fields are updated fine):
Can’t select multi references of sub-tables in database delete & insert, otherwise I’d do this update “manually” by deleting and inserting again
Maybe related to my findings here where the fetch data isn’t working without a incremental id field on multi references in sub tables
Just to add here I setup a sub table and then in that sub table made a multi reference, unfortunately I can’t insert any data into the multi reference even if I use the view table in the database manager. If I have the multi reference in a normal table no issues maybe related to the above with the fields not filling out when created in some way or something to do with how the sub table is recognised in the insert steps and manager?
Apologies if I’m using this all wrong can multi references be …
htatd
April 13, 2022, 10:36pm
3
No… unfortunately not. I already had incremental id fields in the two multi references in the sub tables. Thanks for the suggestion though!
The update does almost the same as the insert, for the update it first deletes the old values and then inserts them all again.
Do you get some error in the server connect action? Please check in the devtools what is being returned from the server.
htatd
April 21, 2022, 11:31am
6
There wasn’t any error in dev tools. I used the exact same method as in the insert action, it was just returning “success” without updating.
