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

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. 

%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, 201213 yr by Lee Smith
Remove extra returns

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.

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

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.

...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 )

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

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, 201213 yr by Lee Smith
Removed all of the extra returns. Again

waiting for upload's issue solving.

Here it is.

Pick List.zip