Jump to content

Recommended Posts

wedgeman    0

I sometimes use a trick in Conditional Formatting to give fast hints in form views..

i'll place a merge field (name of field, or helpful hint) BEHIND the actual form, then will format the field to have a clear/no backcground, using a calculation of "IsEmpty(Table::FieldName) - to trigger it..

So if the field is empty, the hint is visible, but if there is any value in it, the hint disappears.  See screenshot below..
 

image.png.15c528621fe3bfbf3636b0ec8b60b1de.png

 

The problem is that this falls apart in List View.. active fields work.. inactive don't.. what ca I do?

image.png.e28dc05744f3c6026e031de18f04d7ae.png

Share this post


Link to post
Share on other sites

I really can't tell from your screen shot, but It should work for each line.  Are you sure the field does not extend into the other row?  You could also use tool tips.

If you were in a higher version than 12, you could use 'Hide Object when' or a clear button with the label/calculation as the button label.

When I used to do something similar to  this, I would use conditional formatting to set the font to 500pts to hide it when you wanted it hidden.

Share this post


Link to post
Share on other sites
Lee Smith    144

Hi wedgeman,

Why not post a copy of your file, or a mockup of it showing what it is that  you are trying to accomplish.

Please take the time to read this article by Ocean West. Anatomy of a Good Topic, it covers how to prepare a file so as to protect your confidential information.

Please feel free to contact me via Private Message if you have any questions.

Lee

Share this post


Link to post
Share on other sites
wedgeman    0

Sorry -- thought this would be pretty self-evident..

 

In the image below, the only list row which is showing PROPERLY is the one that's selected (ie., the backgrounded text is completely dissappeared, as the conditional formatting is working on that record and they're actually filling in...

i'll try to pull a record togetehr to show this..

 

image.thumb.png.00a522d668f800b4adca8f59726cd856.png

 

 

Well... in trying to show this properly, i found a work around..

using an "IsEmpty" seems to NOT work on a list view for items which aren't the current record.

 

but....

 

"not IsEmpty" **DOES** work....  so i have to just flip the command (leave field blank, but if it contains something, then make it fill)...

Share this post


Link to post
Share on other sites
wedgeman    0
Posted (edited)

here's a shot now with it configured the other way (text fields in front are 'No Fill' , and mergefield text is formatted normally but if field is "not isempty(table::field)", then the text is clear and the fill is clear..

image.thumb.png.83b4dd255f93a35c9f436c34477248bd.png

 

Edited by wedgeman

Share this post


Link to post
Share on other sites
wedgeman    0
Posted (edited)

attached..

column 1 and 4 have no format.

column 2 has format as shown in my work around (which works), but column 3 formtting does NOT work..

it appears that "isempty(x::xx) does NOT work in lines, but "not isempty(x::xx)" DOES work...

Am I missing something?

 

conditionalformat.fmp12

Edited by wedgeman

Share this post


Link to post
Share on other sites
Lee Smith    144

I'm not sure I"m understanding your problem. I modified your example as a starting point. You had labels in the list behind the fields, and you were missing one of the fields.

I forgot how hard it was to customize things in Version 12. Beside that you are using the most recent version 12.v5

 

conditionalformat_MOD.fmp12

Share this post


Link to post
Share on other sites
wedgeman    0
Posted (edited)

You're correct.  It seems we're having a communication issue. 

1. Ignore the missing field.

2.I INTENDED to put labels behind the fields, in order to show the problem.

The problem is that conditional formatting doesn't all work properly on fields shown in list view. It appears that it (conditional formatting) only works properly on the ACTIVE RECORD in a list view, under certain circumstances.

 

See the attachment.

Column A, and Column Three are unformatted.

Column 2 ("field one") formatting works ONLY WHEN the current record is highlighted.. it doesn't format properly on other records (in list view). This is formatted using "IsEmpty" calculation.

Column 3 ("Field two") is formatting properly..  it is formatted in reverse, using "not IsEmpty" calculations.

image.png.161e340987e5f8fd19a4cb60deac275e.png

3. I'm a bit unsure as to why the version matters, other than a potentially known bug (is this a bug?)

conditionalformat_MOD.fmp12

Edited by wedgeman

Share this post


Link to post
Share on other sites
Lee Smith    144

Although version 12 introduced a lot of new features, its releases were buggy. The 12.5 version stabilized somethings, thank god the next few versions improved these things. 

It looks like you are doing a workaround for the field labels. 

see if this is helpful

conditionalformat_MOD_2.fmp12

Share this post


Link to post
Share on other sites
wedgeman    0

Well....duh...  in my 10+yrs of doing FMP (albeit primarily for my businesses and not for pay) i'd never seen that option in conditional formatting....  derp!

 

thanks..  :B

Share this post


Link to post
Share on other sites
Lee Smith    144

This type of workaround is a Hack. 14 and 15 have some Hide features that are a lot better. The is also a new feature called Placeholder Text, that does this without effort.

I'm not happy with this file, there are some tweaks I would make if I were going to use this approach. I would probably put the field names in the header for the List View, and only use the isEmpty calculation as a flag in color.

Lee

Share this post


Link to post
Share on other sites
wedgeman    0
27 minutes ago, Lee Smith said:

This type of workaround is a Hack. 14 and 15 have some Hide features that are a lot better. The is also a new feature called Placeholder Text, that does this without effort.

I'm not happy with this file, there are some tweaks I would make if I were going to use this approach. I would probably put the field names in the header for the List View, and only use the isEmpty calculation as a flag in color.

Lee

thx for the thoughts.

This is not something for show.. You asked me to make a file to explain the problem.  I did it. 

Filemaker has a bug, and I made a simple (and ugly) demonstration. I'm sorry it wasn't up to your expectations.

Share this post


Link to post
Share on other sites
Lee Smith    144

Hi wedgeman,

2 hours ago, wedgeman said:

Filemaker has a bug, and I made a simple (and ugly) demonstration. I'm sorry it wasn't up to your expectations.

It's not a bug, it the technology available in FileMaker 12.  

Your file was fine. We don't judge files by their eye appeal, we are looking at the mechanics of what you are trying to accomplish. Once I understood your file, I was able to give you an example of how it could be done.

There is nothing wrong with FileMaker 12.. I only mentioned the new tools incase you were looking for a reason to upgrade.

Lee

Share this post


Link to post
Share on other sites
wedgeman    0

ok... seems to me that if some calculations work perfectly in one view but a almost identical calculation does NOT work in that view, that's a bug.   I'd be hard pressed to term it a 'feature', especially if it was fixed in a later version.

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Similar Content

    • By Julio J
      Hello,
      I am fairly new to FileMaker and I have designed an Inventory Management DB. In one of my layouts, I have a list of the current inventory. The layout is configured as a List View layout. I have 2 Groups of multiple tabs which show details of the item being viewed. 
      One thing I have noticed is when I switch tabs on the selected record, ALL of the tabs in the list also switch.
      e.g. If I have 3 Tabs: Info, Details, and Notes
      If I switch to the Details Tab, the rest of the records in the list view also switch to the Details Tab.
       
      Is there a way to make sure that only the record I am viewing in the List View switches tabs?
       
      Thank you all for your help.
       
      Cheers.
    • By benmort81
      Hello,
      I am using Windows OS for my solution.  I have a layout in list view showing events. An admin user is to add groups of people as attendees of these events by pressing a button to run a script.  The script Freezes the window, changes layout, adds the attendees in the relevant table and returns the user to the original layout.
      This all works well, except for when the script returns to the original layout and unfreezes the window, the scroll position of the active row (the record that the user is editing) jumps to the bottom of the screen.  I would like the scroll position to remain static or be returned to where it was before the script changes the layout - so a change is imperceptible to the user.
      The Window Scroll options seem limited to top, bottom, pg up, pg down.  I have also tried having the script open a new window before changing the layout, but you then see the script working - if only briefly - as the new window comes to the front.
      Has anybody got any suggestions on how I can return the scroll position to exactly where it was before the script executes?
      Thanks in advance,
      Ben
    • By amanbolat
      Hello.
      I have an a solution with some web direct layyouts for my customer. In On Open file script, when customer enter the layout will create a global variable $$Loginname and after that on all layouts they should see only their records related to the $$Loginname. 
      Right now i use a portal with filter Customer = $$Loginname.
      Question: What is faster? List view with script on enter that will find related records or portal with filter.
      Really the problem is that my customer have a big latency( because they live in Russia, and my server in China) and when they scroll portal there always an a processing bar in center of browser. 
      Or you have other options?
      Thank you.
    • By sirmatter
      Hi Everyone,
      I am having an issue with conditional formatting on a portal. Currently, I am attempting to have portal text change color when a record exists on a specific date in a related table. My problem is that it is only working for one portal row and not for the others. I have observed that it is only changing the portal row that is the "first" record created in the related table. As soon as I delete this record, the formatting is "bumped" to the next record that was created.
      Any ideas how I could have the entire portal format correctly?
      Thank you!
    • By Goetch
      I am pretty sure this is a known bug in FMGo 13, however, I was wondering if anyone might have a work around.  
       
      I am having an issue with list view in a simple FMGo 13 program.  Basically after about 20 or so records the input field of a new record disappears.  Scrolling the screen will almost always bring it back.
       
      The program is pretty simple, 3 tables, 2 input fields scan and qty.  I made the program to help take our physical inventory.  The user is only interacting with the "scan" table.  The two fields are scan and quantity.  Basically I download the program into an iPhone and pair a socket scanner with it.  I have a script trigger that runs on object save on the scan field.  The barcode and based on a preference either a new record is created or the user enters in the quantity.  Everything works great until about 20 or so records are scanned, then the user can no longer see the input field on the bottom of the screen.  Scrolling up usually fixes this.  The program seems to work flawlessly if the layout is set to form view, however, obviously the user does not see the last few scans in this view.  
       
      Like I said I have read that there are bugs in list view.
       
      Can anyone suggest a work around?  
×

Important Information

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