Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Adding a field to a pop up list


mjwood
 Share

Recommended Posts

I apologize if this has been answered - but I couldn't find it.

 

Is this possible:

 

I have a field called first name.

I would like to create a pop up list that automatically inserts the first name in an appropriate spot.

 

E.g.

 

“First name” = Bob

 

Pop up menu choices:

• At this time “First name” is working well toward his GED.

• Unable to grant “First name” his GED due to incomplete assignments.

 

I know how to create the pop up menu items, but do not know how to insert in them data from another field.

 

Any assistance is welcome.

 

Jeff

Link to comment
Share on other sites

The popup menu would have to be attached to one field while the "results" field would be a different field, a calc field.

 

 

WELLLLLLLL........ OK, what you're asking for is technically possible, but substantially messier and unFileMakerLike and I recommend against it.

 

What I would do instead is I would have a field "MessageChoice" with a valuelist of values like

 

• At this time XXX working well towards his degree

• Unable to grant XXX his GED due to incomplete assignments

• Other stuff about XXX as you see fit to include.

 

Then I would have a calc field, text, "Result", =

 

Substitute(MessageChoice, "XXX", First Name)

 

 

===========

 

If you really really really just absolutely have to have the whole composed string in the value list itself, you need a selfjoin of the table to itself based on a unique field (Record SerialNumber or Record ID or something), effectively a selfjoin of the record to itself, and a calc field, text, something like this:

 

"At this time "&first name&" is working well toward his GED."&"¶"&

"Unable to grant "&first name&" his GED due to incomplete assignments."&"¶"&

"Other stuff about "&first name&" as you see fit."

 

Let's call that field "WholeMessageVL".

 

Then you set up a value list showing values fo the field WholeMessageVL, showing only related values, and specify the selfjoin relationship.

Link to comment
Share on other sites

Tnx AHunter3 for the detailed info. All I can say is

 

YIKES!!!

 

Seems a little complicated for someone with my very limited FileMaker experience, but I really appreciate the info.

 

Jeff

Link to comment
Share on other sites

Do it the first way, it's not so complicated.

 

Create a field "MessageChoice" with a valuelist of values like

 

• At this time XXX working well towards his degree

• Unable to grant XXX his GED due to incomplete assignments

• Other stuff about XXX as you see fit to include.

 

Then create a calc field, text, "Result", =

 

Substitute(MessageChoice, "XXX", First Name)

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use