Jump to content

  •  

Photo

based on a calc TO


  • Please log in to reply
5 replies to this topic

#1 Cateleb  novice

Cateleb
  • Members
  • 42 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 1d 12h 54m 25s

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
  • 42 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 1d 12h 54m 25s

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,093 posts
  • LocationTegernsee, Bavaria
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 209d 17h 21m 14s

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
  • 42 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 1d 12h 54m 25s

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,093 posts
  • LocationTegernsee, Bavaria
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 209d 17h 21m 14s

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
  • 42 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Time Online: 1d 12h 54m 25s

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