Edit Value List

[shoon]

Sorry im still new here, now sure whether these questions are at the rite place.. just trying my luck..

Q1 : I was wondering is there any script that enable me to edit value list with a click of a button in browse mode? Other than the "Edit..." function..

Q2 : When we convert our filemaker file to php, how do we edit our value list? Will the "Edit..." still appear at the bottom of the value list and pop up a window for us to edit it?

[LaurenKuhlman]

Hi Shoon. Check out this post:

http://fmforums.com/forum/showtopic.php?tid/210249/

I would make the value list dynamic and based on a field and then script the editing of the field. It doesn't need to be one line per record, you can just put carriage returns between your values. It however can not be global because global fields are not indexable. As far as CWP, I have pinged two of my more experienced coworkers with that question.

Edited July 28, 2009 by Guest

[shoon]

Thanks Lauren for ur reply :

After I saw ur example..I kinda got what I want there..Selecting "Use values from field" instead of "Use custom values" kinda solved my problem :

With that I can add new values.. The problem now is how do I remove or edit one of the value in the list instead of removing it one by one from the database? Can it be done without going into layout mode or without the "Edit.." function?

Eg.. I have an existing database with PackagePlan DropDownList, Values : Plan A, Plan B, Plan C.. And now I want to remove Plan B from the list when Plan B is no longer available.. or move all the Plan B users to Plan D..

And thanks again Lauren for the effort for Q2.. appreciate it loads

Thanks alot for the help

Edited July 29, 2009 by Guest