Jump to content
Sign in to follow this  
tomp

text fields with paragraph characters as 'values'

Recommended Posts

I have a repeated field with text content. Each entry may be multiple lines, having a 'paragraph'or enter/return character in the text string.

I would like to use the repeated fields in a value list, but when I do, the values offered in the drop down list are not the field values, but each of the individual lines from the field values.

E.g.,

Repeated field 1:

Line1

Line2

Repeated field 2:

Line3

Line4

if I define a Value List for the repeated field,

it shows 4 choices in the drop down list:

Line1

Line2

Line3

Line4

when what I want are 2 values:

Line1/Line2

Line3/Line4

Any way to make that happen?

Share this post


Link to post
Share on other sites

The only way to circumvent genuine recursive structures, I can think of here is this:

http://www.dwdataconcepts.com/dl/tw/compinv2.ZIP

...but making such a scheme fit in repeating fields - is certainly and endeavour where it's questionable if you ever will arrive to something usefull. Even as a sort of suduko, would I say it's one hell of a challenge.

You have obviously realised that what you're up against is:

http://en.wikipedia.org/wiki/First_normal_form

...and are willing to take the plunge into it, an this post/question should merely be a nod from this community to go a head, however am I not particular sure you'll get my!!! But would eagerly await your teaching on the subject ;)

--sd

Share this post


Link to post
Share on other sites

Try defining a calculation field (result is text) =

Substitute ( YourRepeatingField ; ¶ ; "/" )

Let the field have the same number of repetitions as YourRepeatingField, and use it for your value list.

Share this post


Link to post
Share on other sites

I considered the substitution as well, but the user would not see the formatted message in the drop down list, and I'd have to edit it out upon leaving the screen.

Since there are only a few possible 'messages' to choose from in this application, what I've done is display them on the screen and written a script to substitute the selected one into the form.

Thanks.

Share this post


Link to post
Share on other sites

Well, you could make the field auto-enter a reverse substitute. But I believe selecting from another device, as you have done, would be eventually simpler.

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.