How to Create dynamic tables with the same attributes

Hey guys, I’m new to bubble but I’m loving it so far!

In my app I need companies to be able to create tables.

Each table will have a name that can be changed by the company;

Each table will need tags from a list things from another table (IDs) - If a tag is assigned to a table than it cannot be used on another one;

Inside the table I want the company to be able to create as many rows as needed.

The way I structured it every row would have the same name (as the table it is in) and the same list of tags (as the table it is in).

For example:

Create Table >; Table 1:

Table’s name: Default [button: edit name]

Tags: 1000, 1002, 1026 [ button: edit tags]

Table 1:

X Y Z [button: add row] // header

0 1 3 [button: edit] [button: delete] //row1

2 5 3 [button: edit] [button: delete] // row2

Create new table > Table 2:

Table’s name: Default2 [button: edit name]

Tags: 1001, 1003, 1017 [ button: edit tags] // cant use same tags as table 1

Table 2:

X Y Z [button: add row] // header

4 1 4 [button: edit] [button: delete] //row1

2 3 0 [button: edit] [button: delete] //row2

6 7 3 [button: edit] [button: delete] //row3

The Table’s DB would be:

Default, [1000,1002,1026], 0, 1, 3

Default, [1000,1002,1026], 2, 5, 3

Default2, [1001, 1003, 1017], 4, 1, 4

Default2, [1001, 1003, 1017], 2, 3, 0

Default2, [1001, 1003, 1017], 6, 7, 3

The problem I’m having is I dont know if its possible to filter the names on the repeating groups, so it only creates one group for each unique element while keeping the type of content as a table and not text. That way I can show each table only once.

Also Im not sure how to give all the rows the same name and tags. Is it possible to do it like this? Only one table(db) for each company? So I can link every row together by their name/tags.

Is it possible to do this with only one table for each company? Otherwise things might get messy when I have over 20 companies each with 10+ tables. In this case, is it possible to create a new table(db) dynamically - For example, make a copy of another table, change the name to [input]?

The way I was trying to do with only one table(db) to each company.

Is there a better solution to this? How can I solve this problem “The Bubble way”? :grin:

tl;dr
Tables.

Is it possible to filter a repeating group to only show unique elements but at the same time keep the type of content to a table(which is a list of things)?

How to give different rows the same name values and ids?

Is it possible to create a copy of a table (db) and change its name to [input] dynamically?

For reference, this is what I’m trying to achieve:

Link to app: help-test | Bubble Editor

I’m not sure if I was clear enough :stuck_out_tongue:

Thanks in advance!

This topic was automatically closed after 70 days. New replies are no longer allowed.