Skip to main content
Question

Making a required field editable when rule in place to keep same response as other field.

  • November 5, 2020
  • 0 replies
  • 98 views
I'm a newbie so bare with me. 
I created an app (looks like a checklist) that has 2 fields. 
Rule created:
When- (Field 1) is equal to "No",  Action -Change (Field 2) to "No".   
User saves and closes checklist. 

I need to make the 2nd field editable so when the user goes back into checklist they can change Field 2 to "Yes" without changing Field 1. 
So, I created a 2nd rule >When (Field 1)  is equal to "No", Make Editable-(Field 2). 

So, this works on a new checklist, but does not work when user goes back into the checklist via Edit mode.  
Any suggestions?


------------------------------
Tracy Himes
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Quickbase Alumni
  • November 5, 2020
Tracy -

Can you explain your use case a bit? I'm trying to understand why you would want to do this because I have to think there's a better way.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Quickbase Alumni
  • November 5, 2020
Everybody was a newbie once and can always be a newbie to something new Tracy, no worries.

When I do what you say you are doing it works on my end:

New record:

Saved, closed, then opened in edit and Field 2 "No" changed to "Yes":
Becomes read only when Field 1 "No" changed to "Yes":

This doesn't work unless this box is checked in your form rule:




------------------------------
Adam Keever
------------------------------
AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Quickbase Alumni
  • November 5, 2020
I would suggest you add a third rule to protect the initial result:

You may want to add a formula field for current status. Something like this:

If (
[Field 1] = "" and [Field 2] = "","",
[Field 1] = "No" and [Field 2] = "",[Field 1],
[Field 1] != "" and [Field 2] != "",[Field 2],
)


------------------------------
Adam Keever
------------------------------
Terms & ConditionsAccessibility statement