Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

based on a calc TO


  • Please log in to reply
5 replies to this topic

#1 Cateleb  novice

Cateleb
  • Members
  • 39 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 1d 8h 16s

Posted 02 July 2014 - 02:10 AM

Hi, I want to do a conditional format of a button based on a self TO which the relationship is based on a get(currentdate) field .. but it's not working

 

ie Table::datedue < [self]Table::Get(currentdate)

 

I do tons of conditional formating but it's always been TOs which are not based on any calc fields .. so maybe it's a fundamental thing... or I'm missing something  

 

thanks

Cate

 

 


  • 0

#2 Cateleb  novice

Cateleb
  • Members
  • 39 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 1d 8h 16s

Posted 02 July 2014 - 02:33 AM

sorry, meant to also say the conditional formatting button is for all the records (100,000 odd) not the record you've looking at .. hence the TO 


  • 0

#3 eos  Paris 2016 … :-)

eos
  • Members
  • 1,032 posts
  • LocationTegernsee, Bavaria
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 204d 14h 59m 16s

Posted 02 July 2014 - 03:22 AM

What fact is it that you want to signify with your CF? That the record's date is < current date? Then why a relationship, and not simply use 

Table::dateDue < Get ( CurrentDate)

as the formatting condition?

 

Hi, I want to do a conditional format of a button based on a self TO which the relationship is based on a get(currentdate) field

 

In order for a Get() function to update properly in a calculation field, the field must be unstored – but then you cannot use that field as the right (data) side of a relationship.

 

I do tons of conditional formating but it's always been TOs which are not based on any calc fields .. so maybe it's a fundamental thing... or I'm missing something  

 

A TO is based on a table, and nothing else; do you mean “relationship” …?


  • 0

#4 Cateleb  novice

Cateleb
  • Members
  • 39 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 1d 8h 16s

Posted 02 July 2014 - 01:48 PM

thanks eos, I probably worded it wrongly.  I was trying to find a way of showing all the records where the due date exceeds todays date and displaying them using a portal in a popover .. the popover button would be a different colour if there are any records .. I was wanting it to be dynamic in so far as when they gotorelated record from the popover/portal, they can reset the due date and that record will disappear from the popover/portal  ie without the need for scripting perform find etc 

 

You comment about no get() on the right side of the relationship seems to be the prob and why my current won't work .. but I'm taking it I can have the get(currentdate) as a calc field on the left side of the relationship ?


  • 0

#5 eos  Paris 2016 … :-)

eos
  • Members
  • 1,032 posts
  • LocationTegernsee, Bavaria
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 204d 14h 59m 16s

Posted 02 July 2014 - 03:44 PM

You comment about no get() on the right side of the relationship seems to be the prob and why my current won't work .. but I'm taking it I can have the get(currentdate) as a calc field on the left side of the relationship ?

 

Yes, you can; but maybe just use a global field and set it to the current date, which gives the user the chance to enter and check on other dates manually.

 

See here:

Attached Files


  • 0

#6 Cateleb  novice

Cateleb
  • Members
  • 39 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 1d 8h 16s

Posted 02 July 2014 - 05:14 PM

Hi eos,  worked it out, did get(currentdate) > due date and added a couple of connectors to filter out jobs closed and branchID and the CF and portal works. 

 

I'll remember the Get() only on the left .. supposed I'd learn those sort of things if I did a course ! .. thanks again  


  • 0




FMForum Advertisers