Confiform Database within a Form

[Maximilian Herbert]

Hello there,

so as usual I will try to describe as precise as possible what my problem is:

I created a custom layout form via Confiform. In the end of this form I want to insert a "Capacity Matrix".

Example of this matrix:

...

*Upper part of the form where general data about the person is asked*

.....

Matrix:

Category               Type                             Amount                       Size

---

Dogfood         *ConfiFormField*          *ConfiFormField*       *ConfiFormField*

                        *ConfiFormField*          *ConfiFormField*      *ConfiFormField*

Catfood           *ConfiFormField*          *ConfiFormField*      *ConfiFormField*

                        *ConfiFormField*          *ConfiFormField*      *ConfiFormField*

........

And so on.....

The problem with that is: I cant really analyse the total amount of dogfood (Type XYZ) through all entries. Any ideas what the best approach would be to get this down?
Would the integration of a database solve this problem. But how can I do this without getting too much out of Confluence and still be able to analyse the entries.
Overall the result should be that anyone can fill in how much he needs of what and i want to analyse and interprete the results through all entries.

Best wishes 
Max

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Maximilian Herbert 

Are you using Confluence cloud or a DC/server? DC/Server version of ConfiForms has a TableViewMerger macro that should be able to help you

Alex

[Maximilian Herbert]

Using DC/Server. I have the tableviewmerger as well :)

So the only thing I dont get is:

If I look at the example I gave above:

Category               Type                             Amount                       Size

---

Dogfood         *ConfiFormField1a*          *ConfiFormField1b*       *ConfiFormField1c*

                        *ConfiFormField2a*          *ConfiFormField2b*      *ConfiFormField2c*

Catfood           *ConfiFormField3a*          *ConfiFormField3b*      *ConfiFormField3c*

                        *ConfiFormField4a*          *ConfiFormField4b*      *ConfiFormField4c*

How can I ensure that the the amount of line1 (ConfiFormField1b) is mapped/connected to the type (ConfiFormField1a) and the size of line 1 (ConfiFormField1c)?
For me it seems like I kinda need a "Primary Key" as in a Database.
Is this possible in any way?

[Alex Medved _ConfiForms_]

The question is incorrectly labeled and placed...

To answer your question - you decide what to be used as PK... 

So place the ConfiForms Field macros for Category and Type (setting field names parameters to their names) and for the Amount field, place the ConfiForms Field macro with a field name to be something like Amount:([entry.Amount])

So it does not "construct" the PK... while the first 2 fields will do

Alex

[Maximilian Herbert]

Ahh im sorry! Just saw it.

That helps a lot! What I noticed as well is that every line (in my example above) has to create an own entry. So when someone fills in the form in there should 4 entries be created- is this possible?

If so my solution would be:

I create one form "Customer" and a second one with "Demand"
In the demand form I would set a smart field as PK referencing the e.g. the customerid from form1 and other field definitions.

The entries when 2 people filling the demand form would be like that for example:

PK                  Category           Type          Amount

---

Customer1,     Dogfood        healthy           4x 

Customer1,     Catfood          healthy           2x

....

Customer2,      Dogfood      unhealthy         6x

Im sorry for these examples ... Its just so hard to describe what I wanna achieve in other ways. Thank you so much for the time and help so far tho!