Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4639 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Maybe someone can help me I just cant seem to get it right,

I set up a database of volunteers witch I can assign a task using a portal and a dwindling value list, I got that part to work.

But then I found out that the dwindling part only works on one record so I changed a couple of things,

1. I set up a self join relationship to keep a list of all volunteer keys used in the join table across all records.

2. I changed the calculation use that self join relationship.

The one thing I cant seem to get working at least fully is when I select a volunteer in the portal in record one in it displays a

list of all of the volunteers (so far so good) after I assign four I create a second record.

When I open the list it shows all the volunteer names including the previous four, but when I select the first one and change it

the list suddenly updates to omit the previous four.

the same happens with record three four five......

I want it to work like this: once a volunteer is selected or a task it removes him from the dwindling list, when I create another task

I want it to use the same list excluding all assigned volunteers in previous tasks.

It must be something simple but I cant figure it out.

I'm using filemaker 11 pro advanced.

Any help would be appriciated.

Testing.zip

Posted

Funny thing was i was just trying to do a simple test myself.

Do you have to have an "ESTABLISHED JOIN TABLE" in order to dwindle the list?

eg

do we need this relationship first;

task_volunteer -> JOIN <--Volunteer

& once that is established , we can then do the


task_volunteer ≠ Volunteer



that would be very nice ..

Also , can you not also use a calculation in cVoluntteer to be just

list( Volunteer) & "¶"

-thanks

This topic is 4639 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.