Solved

FM - Conditional Formatting to Make Buttons Invisible?

Posted on 2011-03-04
2
1,016 Views
Last Modified: 2012-05-11
I have a growing need to use conditional formatting to make things invisible.  However, conditional formatting does not have an option for that.  In certain situations, such as portal rows where I alternate the background color, I can't simply match the color to make it invisible.  

For example, currently, I have a delete button and a Related Reocrd button on every portal row, but don't like the look when it shows in the blank new-row-to-be.  Ideally, I want to use a condition that says IF the RecID is empty, be invisible.  Do you all have a workaround?
0
Comment
Question by:rvfowler2
2 Comments
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
ID: 35037113
Well, my primary recommendation would be to script creating a "new record" function rather using the "Allow creation of related records in this table using the relationship" option. I almost never use the "Allow creation..." option because 1) it's confusing to users to have the seemingly blank record (but with buttons as you mention) at the end of the list, 2) it's at the end of the list rather than the top, 3) it tends to result in the creation of blank records when users enter the field and then leave it after typing text, changing their mind, deleting the text but not the newly created record.

So, I recommend a scripted "New" button, possibly combined with a sort order that puts portal records missing certain values at the top of the portal row. Either that or put up a dialog that captures some or all of the values going into the portal row record which gives you more control over validation of entered data if you need it. You can also use script triggers to start the new record process depending on layout.

I know the above didn't directly answer your question, but sometimes it's good to backup a step further and look at the larger issue. Regarding making text invisible, if security is not an issue with the field contents and if background is white or an identifiable color, I will just set conditional formatting to make the text the same color as the background (usually white) and 1 point font size, but better solutions generally involve a calculated field to show the button text or graphic under specific circumstances.

By the way, if you need some nice graphics for non-commercial projects, I recommend checking out the following open source graphics libraries. Just setup a separate table for graphics and you'll improve the look of your entire interface but getting rid of those clunky gray buttons...

Tango Desktop Library: http://tango.freedesktop.org/Tango_Icon_Library

NuoveXT: http://nuovext.pwsp.net/

0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 35037463
Thanks, Will.  Yes, I prefer someone give me a best practice rather than just answering my specific question.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now