Catalog Item with large number of variables to be selected multiple times

[Sam Ogden]

Hi All,

We currently have an excel spreadsheet that we use for our customers to raise a certain request to us.   This spreadsheet has around 35 columns and each of these need to be filled out.   They can then fill this out multiple times (i.e. multiple rows).

We would like to be able to incorporate this spreadsheet into a catalog item that can be put on our customer portal.   We would therefore need around 35 variables that a user could fill out, then add to the item, then re-fill out several times.

On the share I found a table variable option where you could add columns and it allowed the user to add multiple rows, this then wrote back as a html table.   The issue I ran into with this is that once you added more than 10 columns, the column widths started to truncate and by the time we added all the ones we needed they were too small and untidy for it to be useable.

Is there anyway that we could create a form with all these variables (doesn't have to look like a table to the user, i.e. we split the current excel spreadsheet into sections and have these sit in different containers).   Then have the user fill out all containers, with an add button at the bottom.   This would then save all the details they have added and then clear all the fields so they can re-enter a second or third time etc.

We would then need this to populate in an easily readable version (such as a html table) in the backend.

Currently we just have people send in the spreadsheet that gets added to the request item, but we want this in variables so we can produce a workflow using some of the information the user inputs to determine the route of the workflow.

Any help and/or suggestions on how we could best achieve this would be greatly appreciated.

Thanks

Sam

[Sam Ogden]

Hi All,

Was wondering if anyone has any tips/tricks on how to amend this to achieve what we are looking for from the above details?

Thanks

Sam

[M Iftikhar]

Hi Sam, Not sure if you have resolved this issue. I looked into this issue and created similar excel sheet widget. Please see attached screen shot. It will also allow you to add/update cells/delete rows as well. Original idea here : http://embed.plnkr.co/eRhL9O/ For more control you can use this component with cell edit function. http://ui-grid.info/docs/#!/tutorial/205_row_editable also if you are going to develop using this route then I would suggest to save the data in JSON form and read it from JSON as it make your life easy to save/read otherwise it would be difficult to save/read based on individual fields in table. I have attached the widget code in a text file attached. Please see each section in the text file. Let me know how you getting on with this? Thanks ifti