Hi,
I have a table where you can edit/add. I have columns with drop-down values. If I select from the enum list the next column shouldnโt be editable, but if i add a new enum value then the next column should be editable. Can someone help with the expression for this issue.
Thanks,
Surendra.
Please have a look there
This is where to type your Yes/No expression for Show_If
:
Editable_If
:Hi Aurelien,
Thanks for your reply. I get the concept of the show-if constraint, but my ask is I have a column where i can select an item from drop-down. Letโs say I add a new item to the drop-down and only then i want the next column to be editable. I was wondering if there is a way or formula to do that. But i found a work around with that. It would be great if you have any other ideas.
Thanks.
OK, thanks for this further explanation.
I did not have this situation before, Iโm afraid I canโt help you on that.
Spontaneously, and assuming that the dropdown list:
editable_if:
NOT(
IN([_THISROW].[columnEnumList], tableSourceName[columnFromSourceTable])
)
But Iโm only 50% confident into that solution.
Which workaround did you make ?
Hey thanks again for the help.
My Enum column is the key column, so obviously canโt have duplicates. I added another column where it will give the count of items in the Enum column. Also i have numbered the rows. So, just gave the expression like rownum>total count (then editable).
Try this as the second columnโs Editable? expresion:
NOT(
IN(
[enum-column],
table[enum-column]
)
)
Replacing enum-column
(twice) with the name of the column containing the Enum value, and table
with the name of the table to contain the row being edited in the form.
The IN(...)
expression answers the question, โis the enum-column
column value in the form already present in the enum-column
column of the table
table?โ Wrapping that with NOT(...)
inverts he question: โis the column value not present?โ
Note that this is the same as @Aurelienโs suggestion above, I notice as I reread it. Oops!
See also:
Thanks Steve, it works.
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |