Formula and Editable at the same time

AppSheet AppSheet Q&A
1

Is there a way to make this happen in a form?

IF(Condition 1, then Result 1, otherwise Column is Editable)?

2

Try:

AppFormula

IF(
  FALSE,
  "Something",
  ""
)

Editable_If

[_THIS]=""
3

Yes but what is your condition?

edit.PNG
edit.PNG765×469 17.3 KB

4

No, it did not work. It gave me this message: “Column Name ‘Column 1’ in Schema ‘App Name_Schema’ cannot use an EditableIf constraint if it has an App Formula. The EditableIf constraint will be ignored.”

I also tried…

AppFormula

IFS(

Condition,

“”

)

Editable_If

[_THIS] = “”

This displayed the column I wanted to edit if the condition was true but it was not editable.

5

Goal is…

Formula in column 2 = IFS([Column 1] < 2, “”)

EditableIf in column 2 = [Column 1] > 1

6

Go to the table, columns

Select the column, in the initial value type:

If condition met, value1 else “”.

Go editable and your condition

If condition not meet, shall be editable other wise not.

Regards

7

Yes, I’m sorry. I even wrote “AppFormula” without realizing how wrong it was.

AppFormulas make a field uneditable ipso facto.

I think you want an Initial Value instead.

If you don’t, you may want to have an Initial Value with reset on edit

8

unfortunately, “value 1” is a choice from a referenced list, so I cannot state what it would be. I also cannot assume an initial value, see below.

Another way of stating what I am trying to do -

  1. If Column 1 is 1, Column 2 is blank
  2. If Column 1 is > 1, Column 2 is a choice from a referenced list
  3. If the user completes number 2. (above), THEN goes back and changes Column 1 to < 2,

I want to automatically reset the value of column 2 to blank.

Sorry if my poor explanations don’t make much sense…

9

Another way of stating what I am trying to do -

  1. If Column 1 is 1, Column 2 is blank
  2. If Column 1 is > 1, Column 2 is a choice from a referenced list
  3. If the user completes number 2. (above), THEN goes back and changes Column 1 to < 2,

I want to automatically reset the value of column 2 to blank. Basically trying to eliminate a forward reference issue to make Valid_If statements easier on the user.

10

Your condition (3) is not possible: once the user modifies the column value, there is no way to change the column value automatically until after the user saves the form.

11

Any word about this becoming a possibility in the future?

12

I’m unaware of any plans to change the current behavior.