Jump to content
Sign in to follow this  
chadski021

Help Pull the selected 2nd field values instead of 1st value

Recommended Posts

Hi,

What is the possible solution for this, See my attached sample. As you can see i selected Doe and Smith from the checkbox, But the result is John and James. It should be Doe and Smith also. Sorry for my bad grammaring i hope you understand.

Example.fmp12

Share this post


Link to post
Share on other sites

That is the expected behavior: the checkbox field holds only selected values, and the selected values come from the value list which is defined to use values from the FirstName field. The second field is used only for display, to help the user select the correct value. Typically you would let the user see a name, and have the checkbox field store a unique ID.

I don't know what the real problem here is, so I can't recommend a solution. Perhaps you need to calculate a full name first, then use that for your value list. Or use a different method of selection.

Share this post


Link to post
Share on other sites

Yeah i think its a bit complicated. By the way can these be done using dropdown. I mean on the value list i only show the 2nd field which is last name. but my calclucation result should be also the last name. currently the result is showing the 1st name.

Share this post


Link to post
Share on other sites
7 hours ago, chadski021 said:

can these be done using dropdown

It makes no difference. A field set up to use a value list will contain values from the list. And the list includes values from the first field only.

 

7 hours ago, chadski021 said:

my calclucation result should be also the last name.

In theory at least, you could use a different calculation, using either a custom recursive function or ExecuteSQL() to get the result you want. But I doubt that would be a good way to solve whatever you're really trying to solve here. I suggest you rethink your entire approach.

 

BTW, I don't see why you need your current calculation field at all. The two fields (checkbox and checkbox result) contain exactly the same thing. If you want to see the real contents of the checkbox field, place another instance of it on the layout and format it as edit box (and make it tall enough to see the entire list).

Edited by comment

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.