Hello everyone!
Just wondering if I am doing something wrong or whether this is expected behaviour for the INPUT expression.
I have a ENUM column, using “Suggested values”. When I use this column in a FORM, it works as expected and allows me to choose from a list but also gives me the “NEW” option that will take me to a form and allow me to add another item to the list.
When I use this same ENUM column in a INPUT popup, there is no “NEW” option in the dropdown.
For the INPUT, I have set the type to “Text” and set an initial value from the list using ANY(SELECT(…
Has anyone had success with this working?
Cheers
Leon
Please evaluate if the following helps.
The input action is akin to having a popup form with just the fields defined in the input action.
Instead of an input action you could use a LINKTOROW() action to a form with an expression something like
LINKTOROW([Key], “Two_Field_Form”)
Where two field form is a form with just two fields on the table. The fields are key column and the column that you wish to change with the input action. Let us say this column is [Suburb]
In this column you could have suggested values list and please have this column as type text instead of enum.
With this setup you should be able to add new values other than the list in the suggested values.
The form will not be a popup form. It will be the usual form but otherwise I believe should do the needful.
Not thoroughly tested so I could have missed an edge case but generally should work.
3 Likes
I successfully used an old fashioned INPUT(“message”, “”) with a column that is a Ref to another table. It lets you select the values of that table.
That column can have valid ifs that work well as filters. i.e. your input column is [fruit] and your that column has a Valid If: filter(fruits, [color] = [_THISROW].[colors])
Note: I did not try it with the new [_INPUT].[whatever_your_input_is]
3 Likes
Hi Suvrutt
Thanks for your response - If I understand correctly, this is a work-around? If so, I can always go back to my old action of LINKTOROW which I had working already (and worked as expected)
I was trying to enquire whether my observation that the “Add” on a INPUT expression dropdown doesn’t seem to work and if anyone has had it working
Cheers anyway!
2 Likes
Hi @leonsteber ,
Correct.
I believe you are correct. I also could not make it work.
2 Likes
Hi @pbalerio
Can I confirm that using your INPUT, the drop down list had “ADD” at the top?
I’m trying this on mine but haven’t managed to get it working as I’d hoped.
Cheers
Leon
On the contrary, It has not a NEW option.
From your message I assumed that by Success you referred to this behavior, that is without the NEW.