We can write back to source data?

#1

Say what?
I was reading this post https://dundas.influitive.com/forum/t/write-comments-to-own-database-from-dashboard/1610 and i didnt know there was to have a dashboard write back to the source database.
I recently made a dashboard where this would be absolutely fantastic to use.

My question is how would I do this and have a drop down choice picker?

The data I want to be able to update from the dashboard is pick a status from four statuses.
My four choices are Very Late, Late, On Schedule, A head of Schedule.
Each row would have this once for each Quarter.

1 Like
#2

Hi James,

Stand by for a new Off the Charts video that is going to cover data input in some detail. I will go through an example very similar to what you are describing. Should be out mid-next week.

#3

Breath holding starts NOW :rofl::joy::zipper_mouth_face::no_mouth::woozy_face:

all kidding aside.
Thanks

#4

@jeff the video you made while very interesting is not what I was looking to do. I was wanting to update the data table. In this case I do not want the selected “action” in a separate table I want it in the same DB.

#5

Isn’t that ‘correct’?
Or does ‘correct’ just change it for the user that did the correction?

#6

Not sure, but that is for values and I have a drop down selection of “words”. I could make them values by making another table and storing the ID to the matching word but then my users would have to learn that 1 = “On target” and so on, this is not a good idea.

#7

Hi James,

In my example that i showed in the video, i wanted to update a ‘table’ using drop downs. The problem is that there isn’t an easy way to embed these sorts of input controls in the table as the control was meant for viewing, not writing. So what i did was use a scorecard since you can build one to work like a table while still embedding input type controls like a drop down. This method works well with data input and the API but it’s only going to write to a data input table. Do you need the data for something outside of Dundas BI? If you do, ya, this approach isn’t going to work as you need a stored proc to update the source table. But if you need this level of input, you’re probably best writing your own form (HTML/ASP.NET etc.) and embed it into the dashboard for more control.

If you just want it to be used in Dundas BI, my method should work as joining against your source table does the trick.

#8

Correct it will not work for me.
I have a small project that the Web application team does not have time right now to write a little grid view that will have the drop down update in it for me. I got a different way of changing the data via some SharePoint Lightning Tool but they have to type the words (no drop down picker).
I was hoping I could have it all in one place, the report/dashboard and change of status.