Is it possible using something like the function 'ValueListItems' to alter the state of a Radio Button pair dependant on the contents of another field. I have a club membership application in FMP Adv 11 which has a Radio Button pair of Active/Inactive dependant on whether they have renewed their annual subscription. At the moment the Radio Button pair is a manual setting, but I would like to automate this based on the subscription date. Any help/advice would be appreciated

Edited April 8, 201015 yr by Guest

Hello Alan,

In the subscription system, perhaps you should capture the subscriptions for each customer in a child table with a start and end date. Then calculate the customer's status by looking to see if there is an "active" subscription record.

hth,

Barbara

Hi Barbara, what I have done up till now is create a custom function to change the 'subscription ends' date to the 31st May each year, so that if a member pays their subscription on or after 1st June it will automatically set the subscription ends to the following 31st May. Then, we have specific colours for the the tag that is stuck to the membership card for the current year, and the 'subscription ends' field is highlighted in that colour, then if the date rolls over to 1 June then the database will change the colours of the field to Amber if they are 1 year out of date(still reading 31 May) and red for 2 years out of date, that way we can have a visual check of the membership status. What I was looking for was a way to integrate that into changing the Radio Buttons automatically to Active/Inactive. ValueListItems seemed the logical thing, but I don't know if the values brought up could be declared as variables and then a calculation used to flip the Radio Buttons accordingly

Obviously, I'm not understanding. Yes, you have lots of condtl formatting going on. However, I don't understand why you cannot calculate a subscription status?

I typically do not have Active/Inactive, I just have flag_Active that equals 1. I format this to a checkbox, using a value list of 1.

Hi Barbara, yes there is lots of conditional formatting going on, I am trying to make it as simple as possible for the user to operate. I will give your suggestion a try and see how they react to the end result..many thanks for the reply