Different In Ranges for Groups
Can I limit a range of values (dates) according to a group that a contact is in? So, if a person were in group 1A, could this limit the contents of another field (a date) to a certain range of values?
Sure. So, I want to constrain the values of a certain field to a range of dates. But, this range of dates will differ, depending upon the value of another field (Group_ID). So, if a contact is a member of Group "1A" in the Group_ID field, for example, users would only be able to enter a certain range of dates for the field "Assessment_1_StartDate." If a contact is a member of group "1B," however, users would have to enter a different range of dates for that field.
Does that make sense?
Under manage databases, click on the options for your date field. Go the the validation tab and validate by calculation.
You can use a Case () statement to deinfe your parameters.
I already told you that you can use Case (). I dont know your situation but you can use something like:
Case ( IsEmpty ( group ); 1;
group ="1A"; YourDate >= Date ( 1;1;Year ( Get (CurrentDate) ) AND YourDate <= Date ( 12;31; Year ( Get (CurrentDate) );
group ="1B"; YourDate >= Date ( 1;1;Year ( Get (CurrentDate) ) AND YourDate <= Date ( 4;1; Year ( Get (CurrentDate) )
I would do a little more research on some of the functions.
One would hope that the ranges are recorded somewhere, preferably in the group record - so you can validate the field as:
Group::StartDate ≤ Self and Self ≤ Group::EndDate
Retrieving data ...