This plugin gives you an Excel-like experience for editing tabular data directly within your app. You can add, edit, sort, filter, and select rows of multiple types including, progress, rating, text, number and file. You can also customize tableās appearance by changing the color of elements and highlighting the rows on click. Editable Data Table is a powerful tool that can help you manage your data with flexibility and ease.
I recently purchased the Editable Data Table Like Excel Pro plugin, but Iām struggling to make it work for my use case. My main issue lies with my table Response Value, which has the following structure:
Member: A link to the member table.
Event: A link to the related event.
Field Title: The name of the field (dynamic).
Field Value: The value entered by the user.
I need to display these records in a table where each row corresponds to a member and the columns are dynamically generated based on the field titles for a specific event. However, I havenāt been able to configure the plugin to handle these dynamic columns correctly.
If anyone has experience with this or can share a configuration example, Iād greatly appreciate your help!
Indeed, the plugin allows you to edit and manipulate the date directly on the page, and you can also customize the table appearance. Also you can check our demo page editor to see an example on setting the plugin up: zeroqode-demo-01 | Bubble Editor
Regarding the concern you reported, to better understand what went wrong in your case, would it be convenient for you to share more details? Specifically, screenshots or a screencast showing how you set the element, the data you are using, the problem you are experiencing, and the desired result.
This information will help us better understand your use case and provide a more accurate response.
I am currently building software to help manage a sports association. One of the core features I need to implement is similar to Google Sheets.
Context:
Admins : These are the users who create and manage their associations. They can create events, and each event can have its own dynamic set of fields (stored in the fields table).
member: These are the members who register for events. Their responses are stored in the Response fields table.
Current Situation:
When an adherent registers for an event and fills out the form, their responses are stored like this in the Response fields table:
member
Event
Field Title
Field Value
John Doe
Event A
First Name
John
John Doe
Event A
Last Name
Doe
John Doe
Event A
Date of Birth
01/01/1990
Jane Smith
Event A
First Name
Jane
Jane Smith
Event A
Last Name
Smith
Jane Smith
Event A
Date of Birth
05/05/1992
Objective:
I would like to reorganize this data into a pivot table format, so each row represents one adherent and the columns represent the dynamic fields (field titles). For example:
member
Event
First Name
Last Name
Date of Birth
John Doe
Event A
John
Doe
01/01/1990
Jane Smith
Event A
Jane
Smith
05/05/1992
Issue:
Iāve purchased the Editable Data Table Like Excel Pro plugin, hoping it could help me achieve this. However, Iām struggling to implement the pivot table structure dynamically since the field titles (columns) are completely dynamic and depend on the fields created by the admin for each event.
Request for Help:
How can I use the plugin to dynamically create such a pivot table structure?
Should I preprocess the data differently in the database to make this easier to implement?
Are there specific configurations or workflows in the plugin that can handle this use case?
Thank you in advance for any guidance or examples you can share!
While the Editable Data Table plugin allows you to edit data directly from the page, it is using the Database API for handling data, and you have to set the correct permissions in the app settings as outlined in the documentation.
This means that the data you want to display should be available in the wanted format in the database before you use it in the element, it cannot change to way it is displayed as you shown in the example.
Thank you for your understanding. Please let us know if you have any other questions.
630+ Bubble Plugins
Native app builder for iOS & Android
No-code Development Services
