Interactive Tables with Writeback functionality
Hi There,
This may be a complex ask. But I think it could be extremely valuable. I would love to create a table powered by Domo for our planning team that is powered by Domo but would also have a dynamic user input field. This field would adjust calculations on the card but could also have writeback functionality.
In my basic example… if I have an inventory planner… They are looking at units sold, available inventory and getting a current inventory calculation. They could then enter a "TO ORDER" number in the table that would in turn calculate a new revised inventory. I would love it if that user inputed field would also have write back functionalities.
This would be very similar to excel functionality but allow for live updates and dynamic calculations.
Comments
-
You could explore if Inline Editing in the Appstore can work for you. I am using it right now to writeback on the dataset which is then used to trigger the ETL that enriches the master dataset. What I like about it is that you can update values of a dataset and write it back directly from the Card itself (powered by this app), you can also create drop down list options with prefix values. Downside is that there is an initial one time enablement cost, the app loading is slow at times and finally you can only update one cell at a time and no fill functions like you what you can do in Excel (fill updates multiple columns or rows at one time).
0 -
Hi @STEVE T,
I used DDX Brick for a similar project. You might find this video useful, as it explains the implementation in detail:
https://www.youtube.com/watch?v=eLfWHpQqwbA
In the video, it's demonstrated as a comment field, but you can easily modify it to suit your needs. The key point is that it allows direct writing into the dataset. From there, you can use ETL processes and some logic to perform the necessary calculations. While it might not be the fastest option, it's one of the few solutions available (as far as I know) that lets you write directly into the dataset from the dashboard. And it is free :)
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive