Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Beginner Conditional Formatting question...

Featured Replies

I'm a newbie.  I am trying to create a checkbox that, if checked, the text in an edit box next to it will go from black to grey.  I have spent hours trying to figure this out.  Here is what I have:

1228250700_ScreenShot2019-02-20at5_52_05PM.thumb.png.adbc55df6e7c4f73f8f7ef760a484cd7.pngFilemaker won't accept

this for me to see if it is correct or not.  I keep getting the following message.

 Screen Shot 2019-02-20 at 5.53.24 PM.png

What am I doing wrong?  No matter what I do I get this message.  I have created a file just to practice this.  It only has 1 table - the one in the photo and I've clicked on those fields on the left to populate the formula.  

 

Thanks for any help! 

 

Edited by Dellana

Assuming that the checkbox field is using a value list comprising of a single value "1",  your conditional formatting formula should contain only this:

Practice::Checkbox 1

This returns True when the checkbox field is checked, False otherwise. That's all you need for conditional formatting. The actual format to use when the condition is true is selected in the Format section, not in the calculation itself.

 

Hi Dellana

Since you seem so new to all this, and may be approaching this the wrong way, I did you a little sample file so you can take a look at how it might be done.

Hope it helps.

Checkbox.fmp12

  • Author

RWoods:  Yes!  This helps immensely!  I've tried this and it now works!

 Thank you so much for taking the time to make this file and help a newbie.  (It took me a bit to understand that //... isn't part of the formula.  Yes, I'm THAT new.  Lol.)  

Apparently, I was way overcomplicating.

(I wish there was (maybe there is and I just couldn't find it) a tutorial with multiple practice examples that one could learn from.  Example.:  Solve this problem:  'Using a checkbox, make a text field text color change from black to grey when the texbox is checked.'  And then the answer on another page.)   

Edited by Dellana
Get rid of duplicate screenshots. I have no idea how or why they were posted.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.