When I try to key in data from the slice form, the Enum only show the slice data not the whole list. I have tried the valid IF function but it will restrict me to key in new data which is not in enum list.
Any solution to show whole list of enum in slice and able to add new from form?
Hi @Kal66
Can you provide more information, along with screenshots? Thanks
Presumably, your Valid if expression references the slice. Instead, reference the table.
I set it reference to the main table, but after i set Valid if the “+ Use ‘xxxxx’” is missing in enum
Please post some screenshots that demonstrate the problem and that show the relevant configuration.
Hi @Kal66
Thanks for sharing additional information and screenshots.
create a table MODEL, with two columns at least: id and label (you can also add a picture column)
about your column:
Change the type of your column to “Ref”, then select the source table MODEL.
And then it will probably be OK.
EDIT : get rid of any suggested_value/valid_if expression if you use this method.
my column already set to ref, but since the form is made from slice table, so the ref model only show the SLICED Enum, for example i sliced the table to show data from date to date, then the enum in form only show the option from date to date but not the whole listing
Does your table have a security filter on it?
Use Suggested values rather than Valid if.
dont have any security filter…
I once had a similar situation, what I ended up doing was creating an action that opened the original table form instead of the slide form. There are other tweaks to be made but the general idea is that
