Multiple Values, One Field, Extract multiple values from field

rss

Posted by Jdubs - Apr 26 ’16 at 08:25

I have a business requirement to Add a Date field and a Text field for each possible checkbox option. My checkbox has a total of 26 choices (currently).

 

Is there a better way to approach this problem rather than adding One Date Field and One Text Field for each option (for a total of 52 additional fields on my form)?

 

I didn't know if there was some programmatic way to store multiple values in one field and then later (for reporting) extract each of those values and match them to one another.

 

*sigh*  Don't think too hard on this; not really your problem, but mine.  Just wanted to make sure before I went down this dark path.

 

Thanks yall!

  • rostislav
    rostislav
    Moderator
    Member for: 4 years 1 month 13 days
    #1 by rostislav Apr 26 ’16 at 12:22

    What are you trying to do exactly - why do you need those additional fields?

  • Jdubs
    Member
    Member for: 4 years 6 months 2 days
    #2 by Jdubs May 2 ’16 at 02:45

    [#1]: I'm trying to display a Text field and a Date field for every checkbox option, if checked.

    For example, let's say I have a checkbox with the following options:

    • Option 1
    • Option 2
    • Option 3
    • Option 4
    • Option 5

    Let's say the user selects Options 1, 3, and 5 (since they are check boxes).  I want the form to now look like this:

    • Option 1 [Text Box] [Date Field]
    • Option 2
    • Option 3 [Text Box] [Date Field]
    • Option 4
    • Option 5 [Text Box] [Date Field]

     

    I know that I can do this by creating a Text Box and Date Field for every single option, and then unhide them when the options are chosen.

    My question is if there's a way to do this without having to add these extra fields.  Because in my scenario there's 26 options (instead of the 5 given above), with the potential to grow much more.

     

    Does that help?

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 8 months 29 days
    #3 by Dmitry Kozlov May 3 ’16 at 01:16

    [#2]: Hi,

    Possibly, it's better to use the Related items control for this case. If a user needs to pick an option, he just adds a new item to the related list, selects the name of the option, and sets date and text fields.

  • Jdubs
    Member
    Member for: 4 years 6 months 2 days
    #4 by Jdubs May 3 ’16 at 08:08

    [#3]: Thanks Dmitry.

     

    I thought about related items control, but every morning at 1:00a.m. I'm archiving the SharePoint item to a SQL database and then deleting the SharePoint item.

    From an architecture perspective, I can't picture in my head how to bring over the correct Related Item entries (that could be multiple) for the Correct SharePoint item.

    Perhaps I'm overthinking it.

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 8 months 29 days
    #5 by Dmitry Kozlov May 5 ’16 at 01:14

    [#4]: Well, you can retrieve the related items of the current item through the lookup field.

Displaying 1 to 5 of 5 messages