Jump to content

[FP5] comparing checks / radios...


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

Recommended Posts

  • Newbies

Hello,

I have a 'wish list' field and an 'actual' field containing multiple items (could be check boxes or radio buttons). These use the same value list. I'm trying to create a 'pending' field to automatically show me the 'wishes' that aren't yet 'actual' but can only get a blank field.

Thought I could have an auto-enter calculation to say 'wish - actual = pending', but (of course!) its not working.

I'd really appreciate any help anyone out there can give.

Many thanks in advance,

Holly

FileMaker Version: 5

Platform: Windows XP

Link to comment
Share on other sites

Hi Holly. Starting your wish list already?

This looks pretty tricky. I think it could be done in a calculation if the value list is small and isn't likely to grow. Or a script if you have many values or a more dynamic value list.

Either way is pretty complex. Involves checking for each value of Actual in Wish List and concatenating non-matches as the result.

Maybe someone has an elegant solution.

Link to comment
Share on other sites

I've built a system that does this. It's two portals side by side like the Sort dialog box. Click on an item and it moves across to the other side, so one side shows what;s available and the other what's selected.

It's complicated. The value lists need to be based on records in another file. I have attached a demo file.

FileMaker Version: 7

Platform: Mac OS X Jaguar

List.zip

Link to comment
Share on other sites

Sharing little secrets then... wink.gif

I had this one in a corner. This is the easiest way I could think about.

I tried it with 300 values and it didn't break.

Though this version wouldn't allow to go backwards though, which means "when it is checked, it is ! "

Requires 5.5 or higher

smile.gif

FileMaker Version: 6

Platform: Mac OS 9

DynCheckboxes.fp5.zip

Link to comment
Share on other sites

This topic is 6506 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
 Share

×
×
  • Create New...

Important Information

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