nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ConfiForm: 3 Dimensional Table

Demolag

Hi,

I am trying to make a 3 dimensional table of the following fields: Product, Mode and Feature, where the intersection between the 3 will have a status (Available, Not Available, Planned).

While Mode will have constant amount of modes, I want the user to be able to add products and features dynamically.

Currently I use one form with the product and mode fields, and for each feature I add a field manually (of type status), and I view it like that, by adding rows manually to the outer table, and for each cell I add a tableview with filters based on the mode and feature:

Screenshot 2025-02-25 142222.png

Is there a way to create this dynamically by crossing 2-3 different forms?

Accepted answers

Alex Medved _ConfiForms_

Hi @Demolag

Should probably be possible with a ListView and nesting TableView/CardViews with dynamically filtered data

Alex

Demolag

Okay, I've figured this out.

3 forms:

features: feature

products: product

featureperproduct: feature,product,status

on features form add 2 IFTTTs on add:

Copy Data: from products to featureperproduct: product=[entry.product]
Update Data: on featureperproduct, where feature:[empty] to feature=[entry.feature]

on products form add 2 IFTTTs on add:

Copy Data: from features to featureperproduct: feature=[entry.feature]
Update Data: on featureperproduct, where product:[empty] to product=[entry.product]

Since modes is a constant amount, we can just duplicate the entries.

All comments

Alex Medved _ConfiForms_

Hi @Demolag

Should probably be possible with a ListView and nesting TableView/CardViews with dynamically filtered data

Alex

Demolag

Thanks for the response,

When I have a table that already has all of the information, showing it is not the issue.
I can't find a way to dynamically add features/products while keeping the table fully updated at all time.

assuming we have only one mode, if I split the form to three:

1. features: name

2. products: name

3. featureperproduct: feature, product, status

if I currently have 3 products in the products form, for each feature I add to the first form, I will have to somehow add 3 different rows to the featureperproduct form. If one of them was constant, I could have just made duplicate IFTTTs that create a row, but if I work dynamically, is there a way to create several rows using 1 IFTTT?

Demolag

Okay, I've figured this out.

3 forms:

features: feature

products: product

featureperproduct: feature,product,status

on features form add 2 IFTTTs on add:

Copy Data: from products to featureperproduct: product=[entry.product]
Update Data: on featureperproduct, where feature:[empty] to feature=[entry.feature]

on products form add 2 IFTTTs on add:

Copy Data: from features to featureperproduct: feature=[entry.feature]
Update Data: on featureperproduct, where product:[empty] to product=[entry.product]

Since modes is a constant amount, we can just duplicate the entries.

Alex Medved _ConfiForms_

May be you can use smart fields to link forms and data, and not to copy it?

To answer your question: Copy Data IFTTT can be used to create multiple records - as many as you have in the source you are copying from. Or have multiple IFTTTs

Demolag

Thanks,
As per your suggestion, I've used smart dropdown and reffered to the products and features IDs.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

data-center

confiforms

confluence-data-center

confiform