What am I missing? This is being used in a memo form (shared action - button). Seems simple… goto select the email addresses but nothing is placed in the field.
addresses:=@PickList( [CUSTOM] ; “customers.nsf” ; “Emails” ; “Select Email Addresses” ; “Please select the addresses needed for this email” ; 1 );@SetField(“BlindCopyTo”; addresses)
I know you normally use “” around the final @SetField value but it’s a variable.
Subject: Missing? yes I think
The syntax for @Picklist is
@PickList( [CUSTOM] : [SINGLE] ; server : file ; view ; title ; prompt ; column ; categoryname )
you do not have a server.
Even if local I think you need a “”
Subject: RE: Missing? yes I think
Just a followup… gonna rebuild the view. The picklist is pulling in the view but not as categorized like it was designed. This could be causing the “” value even though it appears that you are selecting something in the picklist. The syntax for the picklist is correct otherwise you would have no results (re: missing server in previous posting).
Subject: RE: Picklist+SetField Formula (Missing Something?)
@SetField(“BlindCopyTo”; addresses)
Subject: RE: Picklist+SetField Formula (Missing Something?)
The original posting had a typo… my actual formula is below:
addresses:=@PickList( [CUSTOM] ; “customers.nsf” ; “Emails” ; “Select Email Addresses” ; “Please select the addresses needed for this email” ; 1 );@SetField(“BlindCopyTo”; addresses)
Subject: RE: Picklist+SetField Formula (Missing Something?)
Is it still not working? If not then you might want to trap when addresses=“”,
i.e.
addresses:= @Picklist(…
@if(addresses=“”; ;@SeTField(…))
I tested (replacing database, view with names.nsf, etc) works fine.
If you still have a problem, there’s the old standby of putting an @Prompt after addresses:=, and before @SetField…
Subject: RE: Picklist+SetField Formula (Missing Something?)
Tried this… still no luck. Strange… will test with other Dbs + create temp field on the memo form. Another strange thing… even the @If(addresses=“”…) did not give an error.
Subject: RE: Picklist+SetField Formula (Missing Something?)
Odd indeed, I tried this against the NAB, works fine. So, I’m thinking it’s your lookup view. Sure you’ve got column#?