Updating Value List (based on calc that takes value list items and adds some custom items)

[stefwef]

I have a self-joined relationship: key_copyright = copyright holder so that I can filter records according to what shows in copyright holder field.

In List view, i've created a drop down with a "show" button next to it to filter my records according to what's displaying in the drop down. Eg. selecting "public domain" from dropdown then clicking "show" shows all records that have public domain in the self-joined field. This works fine.

I have a value list 1=values from copyright holder for the copyright holder field, and this works and updates pretty immediately.

I have a calc field = evaluate(valuelistitems from valuelist 1 + "all copyright holders" + Public domain)

This calc field updates well whenever a new copyright holder is inputed.

I use this calc field to then generate the valuelist for the filter dropdown, and that's where it gets stuck: It keeps displaying old data and does not update.

It works fine as is, but would be nice if the dropdown could update. Every now and then it looks like the values update, but I can't figure out what triggers it. I could easily add that trigger to the "show" button.

Any thoughts? Am I doing this in a roundabout way? Thanks!

Edited February 4, 2008 by Guest

[comment]

I don't quite see the need for the Evaluate() calc. If there are records that have "public domain" in the CopyrightHolder field, then the value list based on this field should already include it. To add "all copyright holders", you could define a calculation field = CopyrightHolder & ¶ & "all copyright holders". Then define your second value list as values from this calculation field, and change the self-join to use this field as well.

[stefwef]

Hello, Thanks!

I think it will be easier if I copy and paste my calcs. I think I've already done what you're talking about. The need to "add" public domain is that I want it to display even when no copyright holders have that value.

copyright holder = manual entry / drop down is value list of all copyright holder values (Materials used - Copyright holders)/ this works great.

KEY_copyright key selection is a global that is just used for user to choose from dropdown of options. This dropdown is valuelist of copyright_display (see below) and is the one that keeps showing old values / does not update when new copyright holders are entered or old ones are deleted.

GLOBAL KEY_copyright (matches copyright holder in self join relationship.)

GLOBAL KEY_copyright=If(KEY_copyright key selection= "All Copyright Holders"; ValueListItems( Get ( FileName ); "Materials used - Copyright holders"); KEY_copyright key selection)

copyright_display=Evaluate(Quote("All Copyright Holders¶Public Domain¶" & Substitute(ValueListItems( Get ( FileName ); "Materials used - Copyright holders"); "Public Domain¶"; "")); Copyright holder)

I added the evaluate because the value list based on this did not seem to be updating. Still does not update with the evaluate there...

Thanks,

Stephanie

Edited February 4, 2008 by Guest

[comment]

Perhaps it would be better if you posted a file. Your description cannot be correct (two fields named "copyright holder", for example).

[stefwef]

Sorry I can't post the file due to legal issues. I fixed the confusion in initial post. there is only one copyright holder field, which matches to GLOBAL key_copyright.

Thanks!

- S

[comment]

What legal issues? Just make a copy of your file and delete everything except what's needed to see the problem. Or make a new file with just the elements you have described.

FWIW, I still don't understand your description: first you say you want to ADD the "Public Domain" value, then you show a calc that REMOVES it. What's worse, I don't understand the purpose behind this. If you need to show values that may not be in any record, use a custom value list. What makes "Public Domain" special in this regard?