netcode Posted January 30, 2009 Posted January 30, 2009 Hey all, I am working on a field that I want to hold the active years of a contract (ex. 2008, 2009, 2010,.. etc). I created a repeating field and I am looking to show or hide the repetitions based on weather the previous repetition is full. Is this possible? I have read about using a portal technique to show and hide fields but I having a tough time understanding that method and how I could apply it to this situation. Is there some sort of simple function to modify object properties? Thanks
mr_vodka Posted January 30, 2009 Posted January 30, 2009 What is the purpose of this? Using a repeating field may not the most correct way to handle this.
netcode Posted January 30, 2009 Author Posted January 30, 2009 The general purpose of this field is to store the active years of the contract (ex. 2008, 2009, 2010)
bruceR Posted February 4, 2009 Posted February 4, 2009 You are experiencing a problem directly caused by using repeats. Get rid of the repeating fields; use a portal and related table.
netcode Posted February 4, 2009 Author Posted February 4, 2009 It looks like that really may be the best solution, despite if I want that to be the solution or not :)
aholtzapfel Posted February 4, 2009 Posted February 4, 2009 (edited) Depending on your needs, you might try somthing like this. (Calculation based on contract dates, Start and End, see attached file. I only made this work for contracts up to 6 years long.) Finds should let you enter one year and find all jobs active for that year. Relationships will also work using this as a key field. ContractYears.zip Edited February 4, 2009 by Guest
Recommended Posts
This topic is 5771 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