How can I trigger on a part of a field using a list?

[RodM]

I use Ver 9-11..

 

In a each account

I build a affiliate special field.. for displaying,  showng the differnet affiliates associated with other accounts

building  a text field that looks like;        4 digits, representing other affiliate accounts, separated by Returns

 

1000

1002

MAST

 

or the same above field could look like ".1000.1002.MAST"

 

My question

How can I make a PickList,

To pick one of these account#'s from others

Then firing a script sending a select account# or parameter to script?

 

 

Thanks -appreciate

[Matthew F]

I'm not sure I understand correctly what you are trying to do. When you ask about a "PickList" do you mean that you want to format a field as a Drop-down list or a Pop-up menu?  If your reference field is already formatted as a series of values separated by Returns, then you've already done the hard part. All you need to do is to create a value list which references this field and then format the field as a Pop-up or Drop-down list.  

 

Script triggers were introduced in Filemaker Pro v.10.  If you are using v.9 then you might want to put a little "go" button, next to your drop-down list, that the user will press after making a selection.  For later versions you can set a script trigger, on the drop-down list, which fire when the field has been saved. 

[RodM]

%TIA

This is part of a bigger app..
 

I suppose I can create a small snippet if this isn't something simple, or doesn't give  me ideas or comments .

My layout,  I am in a account 1001 that I am viewing ..  In this layout is a field created by the Admin person showing other accounts or afiliates viewed,  when in any account 1001... called:  PickList field such as below

1002
1003
MAST
1000

( no sort order considered yet )

such as a doctor offices, represented by 4 digit account numbers
or  accounts afiliates that are doctors affiliates separated by returns

You did assume right,
I have built this PickList field as above separated by returns.already.

I tried to set field  to work with popup/ drop down
using a List created called AfiliateList  selected on  this same PickList field,

 But, when I  do click on it,  I get the whole field!! .. can't move up or down the list, selecting one of the list?

1001
1002
1003  etc...      its still just the one field !  

and  BTW,  with Debug on, my trigger works at first click, getting the whole PickList field pass as a parmeter

I was hoping to click from one account, allowing operator go to and view a different accounts or afiliates, via  PickList, selecting one from list, clicking it., and then my trigger will also hopefully function

  ( PickList field is a text field. with a caculation also is my trigger script, .thus sending the selected afiliated account from pick list, as a parameter to another script)

I could even use something in  Filemaker 11

I am less familar with  even though I develope backword still to ver 9

thanks again///

Rod
 

Edited November 24, 2012 by Lee Smith
Remove extra returns

[dansmith65]

To recap: you have a return-delimited list of record ID's stored in a single field and you want the user to be able to click on one of those ID's to go to that related record. Do I understand correctly?

 

If you use that return-delimited list field as a match in a relationship, then you can put a portal on the layout that displays those related records, then you can use a simple GTRR script step to go to a different layout to view those records.

[RodM]

Yes, thats my intent and thanks,,

 

i understand what your saying..

..maybe i should re think my direction, step back,   if i need to create another relationship,,

 

 I Thought?  

  I could make a operator option to somehow, to yes, 

     click on that delimited single field, somehow, but never doing so b4

 

Now if, during the ADMIN process, when i add/ remove/ clear certain account#''s

 

I will add that account to this new relationship I will create

 

Then as you suggested,   i have that portal in place, so  to deal furher with a click on, and to go to another account

 

I can add a calc field,  tho displ portal relationship in my layout

[dansmith65]

I don't understand everything you said, but if you wanted to have the user click into the field and go to the related record, you could do that too - but it wouldn't be as easy as the method I recommended...

 

You would have to get the current selection in that field, then determine which value is selected (by searching for the previous/next return), extract the single value from the field, go to related layout, find that value.

[Raybaudi]

...selecting one from list, clicking it., and then my trigger will also hopefully function

I have a file to post for you... waiting for upload's issue solving.

It needs 11.

I could send it by mail, if you want. ( and give me your e-mail )

[RodM]

Thanks Raybaudi    i am interested,   thanks, at [email protected]

[RodM]

THKS again, 4 your reply

 

You would have to get the current selection in that field 

         

i like to extract   1002     from a string such as viewed in layout   1000.1006,1010,1002,1003,MAST

So,  i am not understanding or following your extract method..   

 

To pick from list  

   ( I understand your 1st method works... all i am doing now is trying to understand other methods when i can...

 

,,,, then determine which value is selected (by searching for the previous/next return)       

 

or Rather, i suppose I let opertor just view the string...1000.1006,1010,1002,1003,MAST

then manually enter 1002... is another easy enough to to open script showing 1002 acct

 

or/ and   to loo kat at DanSmith snippet too

 

 

THKS

Edited November 24, 2012 by Lee Smith
Removed all of the extra returns. Again

[Raybaudi]

waiting for upload's issue solving.

Here it is.

Pick List.zip