Cateleb Posted July 2, 2014 Share Posted July 2, 2014 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 Link to comment Share on other sites More sharing options...
Cateleb Posted July 2, 2014 Author Share Posted July 2, 2014 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 Link to comment Share on other sites More sharing options...
eos Posted July 2, 2014 Share Posted July 2, 2014 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” …? Link to comment Share on other sites More sharing options...
Cateleb Posted July 2, 2014 Author Share Posted July 2, 2014 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 ? Link to comment Share on other sites More sharing options...
eos Posted July 2, 2014 Share Posted July 2, 2014 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: DateDueInPopover_eos.fmp12.zip Link to comment Share on other sites More sharing options...
Cateleb Posted July 3, 2014 Author Share Posted July 3, 2014 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3584 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now