I have a bit of a tricky one! My app is effectively a CRM. All my customers use one app, and they store all their customers in there. Privacy rules very important so there is no overlap.
- Users need to create custom fields, and be able to attach it to another data type.
Example: Create a custom field of type “user”, against the type “customer”.
- They need to be able to add/remove these to the front end, so they can effectively configure their own view/dashboards with these custom fields.
Example: On the customer profile page, they add the above example to show who the “Assigned Sales Person” is.
- They need to be able to edit this field in the front end.
Example: They go to the customer profile page and want to change “Assigned Sales Person” from Person A to Person B.
Anyone done this successfully?
Yes, and it does not require doing something impossible like allowing users to create new data fields in the database.
You as the developer create the data structure of the app to allow for the functionality the app requires to operate successfully. In this case, all you need to do is have a data field on the Customer data type that is of type User and call it “Assigned Sales Person” then as the developer build the functionality for the user of the app to add the User to the data field via workflow actions just like you would for any other database interaction.
In a nutshell you want a pseudo bubble inside of bubble.
App should dynamic database configuration and also dynamic elements rendering.
You either can done that using a lot conditions (probably more than +1000) if you don’t have predefined use scenarios( like templates) or code all of that and wrap it into a plugin.
And this is just for 1-2
Think you’ve mis-understood. The field name, type and value all need to be specified by the user.
Each of my customers should be able to create their own unique fields that are only visible to them.
What you’ve suggested would mean I have to create unique fields on request, every time, and then configure the front-end to prevent other companies seeing the wrong fields.
Unfortunately, without some code that allows you to create the database dynamically, this is not possible. You could potentially reach out to Bubble support to see if it is possible to create the database types and fields dynamically with some code, but I don’t believe they would provide a portion of their ‘secret sauce’ since Bubble has already made clear publicly, their editor is what we pay for and is their core value proposition as a company.
However, you can Fudge it by setting up a single data type with a single data field of type text and then allow your users to interact with input elements to name their data types and fields and you as the developer will setup the app to take those input values and structure it as JSON and make everything else throughout the app utilize that JSON formatted single text field.
Thanks for the input - all makes sense. It may be that I just have to suck it up and create these manually on request.