We've got a table that uses values from another wpDataTable:
Table: Lookup: drs_member (id: 100), Show column: zwift_id, Value from column: drs_member_id
We've set the editor input type to "Single-value Selectbox", so users can pick the ID from the list.
As we just started with these new tables, not all website users will have their zwift_id already filled in. This means that the Selectbox shows over 1400 empty values before listing the zwift_id's that are already filled in.
Is there a way to hide these empty values, but allow the "Add an empty value to the list" to still work?
Sorry to disappoint you, but currently it is not possible to remove the blank/empty values that are being pulled from the possible editing values of the foreign key column.
This is a limitation for the columns that are foreign key relations.
For them, we are unable to define to only load specific values for editing/filtering.
-
If we were able to do that, the solution would be to define values like this :
Then the plugin would remove/ignore any other values, including blank ones,
but for the foreign key columns, we currently don't have this possibility.
We might work on somehow bypassing that limit in the future, but I can't say if and when that might be possible.
Hi there!
We've got a table that uses values from another wpDataTable:
Table: Lookup: drs_member (id: 100), Show column: zwift_id, Value from column: drs_member_id
We've set the editor input type to "Single-value Selectbox", so users can pick the ID from the list.
As we just started with these new tables, not all website users will have their zwift_id already filled in. This means that the Selectbox shows over 1400 empty values before listing the zwift_id's that are already filled in.
Is there a way to hide these empty values, but allow the "Add an empty value to the list" to still work?
Thank you in advance for your reply!
Hi, Kevin
Apology for the late reply
-
I can see what you mean, and I just made a test.
Sorry to disappoint you, but currently it is not possible to remove the blank/empty values that are being pulled from the possible editing values of the foreign key column.
This is a limitation for the columns that are foreign key relations.
For them, we are unable to define to only load specific values for editing/filtering.
-
If we were able to do that, the solution would be to define values like this :
Then the plugin would remove/ignore any other values, including blank ones,
but for the foreign key columns, we currently don't have this possibility.
We might work on somehow bypassing that limit in the future, but I can't say if and when that might be possible.
Let me know if you have any questions. Thanks
Kind Regards,
Miloš Jovanović
milos.jovanovic@tmsproducts.io
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables