Jump to content
  • 0

Rows vs Columns / matrix


biota
 Share

Question

Hi all 

My app is essentially moving a survey from MS Word, to a smart form with autocomplete fields etc. I am currently figuring out app logic, after which the whole admin side can be built on top hopefully.

The Word doc has several 'tables' that don't really conform to entity vs attribute data normalisation. Essentially the first column of the tables is kind of a subheading of the column heading, rather than an attribute.

It may be more accurate to call this a matrix, rather than a table?

Anyway, using the standard DP reports, the only way I can see to manipulate and display the data is to have each new instance of a survey fire a Trigger to duplicate a dummy/template table, whereby the first column contains the subheadings, and the subsequent data can be added/edited.

Is this the wrong way to go about this and/or likely to have other consequences?

It seems like quite a conundrum. 

TIA

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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
Answer this question...

×   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.

Loading...
 Share

×
×
  • Create New...