Strange behaviour from Table MultiSelect

Frappe Framework
1

So I have two MultiSelect fields in my custom doctype:

"field_order": [
...
  "section_break_izin",
  "inv_lst",
  "column_break_jawm",
  "quot_lst",
  "section_break_uahh",
...
]
...
  {
   "fieldname": "inv_lst",
   "fieldtype": "Table MultiSelect",
   "label": "List of Invoices",
   "options": "List of Invoices"
  },
  {
   "fieldname": "quot_lst",
   "fieldtype": "Table MultiSelect",
   "label": "List of Quotations",
   "options": "List of Quotations"
  },

Now, when I populated inv_lst all is well.
However, after adding objects to qout_lst and clicking save, the objects disappear from quot_lst.
The only thing happening before save is a validation script to test if a boolean is true.
very strange…

2

@abrefael go to list of quotations and go to list of invoices doctype make field mandatory
in both doctype

3

Thanks,
Tried it, but it didn’t work… :unamused:

4

@abrefael can you share ss of both doctype

5 
{
 "actions": [],
 "allow_rename": 1,
 "creation": "2024-05-16 14:24:09.272360",
 "doctype": "DocType",
 "editable_grid": 1,
 "engine": "InnoDB",
 "field_order": [
  "quot"
 ],
 "fields": [
  {
   "fieldname": "quot",
   "fieldtype": "Link",
   "label": "Quotation",
   "options": "Sales",
   "req": 1
 }
 ],
 "index_web_pages_for_search": 1,
 "istable": 1,
 "links": [],
 "modified": "2024-05-16 14:24:49.652099",
 "modified_by": "Administrator",
 "module": "Custom Module",
 "name": "List of Quotations",
 "owner": "Administrator",
 "permissions": [],
 "sort_field": "modified",
 "sort_order": "DESC",
 "states": []
}

And

{
 "actions": [],
 "allow_rename": 1,
 "creation": "2024-05-16 14:10:57.453349",
 "doctype": "DocType",
 "editable_grid": 1,
 "engine": "InnoDB",
 "field_order": [
  "inv"
 ],
 "fields": [
  {
   "fieldname": "inv",
   "fieldtype": "Link",
   "in_list_view": 1,
   "label": "Invoices",
   "options": "Invoice",
   "req": 1
  }
 ],
 "index_web_pages_for_search": 1,
 "istable": 1,
 "links": [],
 "modified": "2024-05-16 14:23:42.942756",
 "modified_by": "Administrator",
 "module": "Custom Module",
 "name": "List of Invoices",
 "owner": "Administrator",
 "permissions": [],
 "sort_field": "modified",
 "sort_order": "DESC",
 "states": []
}

¯_(ツ)_/¯

6

@abrefael please write “reqd”:1 instead of “req”:1 then check it its working

7

Doh! :man_facepalming:t4:
I will check tomorrow. …
Thanks.

8

You need to make sure the fields in your Quotations List are set to “In List/Grid View” from the field properties.

1 Like
9

This did not work (although, I did make a foolish mistake from being too tired).

10

This worked!
Thank you.
Is it anywhere in the documentation, or (this time) it wasn’t me?

11

Hi, references are already available in forum, so look at this.

1 Like
12