Column edit constraint

AppSheet AppSheet Q&A
1

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.

2

HI @Surendra_Vasudevan

Please have a look there

This is where to type your Yes/No expression for Show_If:

3X_b_6_b67c9df939f5c6ad44e609ba658e4e62f35927a4.png
3X_b_6_b67c9df939f5c6ad44e609ba658e4e62f35927a4.png1172×255 13.9 KB

and for Editable_If:

3X_9_9_995617cac321d44f32c178e279d966eda69aa35a.png
3X_9_9_995617cac321d44f32c178e279d966eda69aa35a.png1166×337 18.5 KB

1 Like
3

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.

1 Like
4

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:

  • comes from a column that I will designate as “columnFromSourceTable”
  • and this columns belongs to a table named “tableSourceName”,
    I would use an expression like:
    editable_if:
NOT(
   IN([_THISROW].[columnEnumList], tableSourceName[columnFromSourceTable])
 )

But I’m only 50% confident into that solution.
Which workaround did you make ?

1 Like
5

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:

2 Likes
6

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).

2 Likes
7

Thanks Steve, it works.

2 Likes