Forums

dropdown multi selection to save and read as it is

samir1903 17 Apr, 2019
Hello
I have a table on table there is dropdowns where you select student names but you need to select few student because you need to sen few student to action
and then there is an update button which updates the selected columns just like dynamic demo

howerver
i cannot save multiple names (i read names but save their codes off course) it save the last student name

how can i save selected students like T01001,T02002,T03005
and then table reads them just like selected when reading i mean with names i select three students but it only save one also doesn tlet me delete any students i dont know why


it says put brakects but when i put gives array error



healyhatman 17 Apr, 2019
You definitely need the [] at the end of the field name if it's going to be a multiselect. You're going to either want to save that cv column in your database as a json encoded string with {var.jsonen:blahblah} or split each selection out into another junction table to make it many-many.
samir1903 17 Apr, 2019
when i put [] in the end of the field gives array error
i assume this is releated with my loop function
how to use this with loop
or else i can save in different way
healyhatman 17 Apr, 2019
Answer
It's related to your SAVE function, because you're trying to save an array to the database and that's just not how it works. In your save data action, where you're updating CV, try {var.jsonen:save_update_loop_cv.row}
samir1903 17 Apr, 2019
how come you know everythink?

works like a charm

thanks
healyhatman 17 Apr, 2019
No problem. Just remember when you read it back again if you're putting it in a dropdown to use {var.jsonde
This topic is locked and no more replies can be posted.