How do I connect a data input to unque value?

#1

I have a dashboard that has a table that shows Project ID, Project Date, and Project Type.

I wan to add the ability to select a line in that table and submit notes in a textbox to add to that table.

I have gone through the data input instructions, but I’m not sure how to connect the unique IDs to the user submitted notes.

Any ideas what I need to do?

2 Likes
#2

Hello,

Are you searching for this feature of data annotations? Or do you want to create a write-back interaction?
https://www.dundas.com/support/learning/documentation/design-view/data-annotations

#3

@costin.manea

Not a data annotation, this is inputting a string into a table. Not a write back either as I don’t want to alter the sql server database table.

I’m just wanting to add notes to a table based on the 3 above reference unique IDs.

#4

Hi Brandon,

Sounds like you’re looking for the Data Input feature. You can use this to write data to a table in Dundas BI (not your SQL Server) and you could even join back to your original data to augment it with comments.

I’m putting out a video on this next week on Off the Charts and it will provide a walk-through. Stay turned or go through the support site if you want to give it a go earlier.

Please let me know if you need more info.

#5

Jeff, is https://www.dundas.com/learning/adding-writeback-capabilities-to-your-dashboard the video? The part about “how to connect the unique IDs to the user submitted notes” (the join), isn’t mentioned in detail.

Does the user have to manually input the field to join on too?

Thank you

#6

Hi Richard,

In my sample, I used an API to update the notes being added to a user. To do this, you need to make sure that the recordId has been added to the input table and the recordId needs to be available in the visualization so that we know what they clicked.

See how i am adding the recordId to the first label? It’s part of the data set, but i’m not displaying it in the text to the user. I do this by removing it from the text binding in the visualization button.

image
image.png1045×562 34.2 KB

In the code: i reference the Id.

var recordId = dataLabel1.metricSetBindings[0].dataResult.cellset.rows[0].members[2].caption;
var customerId = dataLabel1.metricSetBindings[0].dataResult.cellset.rows[0].members[0].caption;
var selectedAction = ‘’;
for (i=0;i<dropDownList1.items.length;i++)
{
if (dropDownList1.items[i].isSelected)
{
selectedAction = dropDownList1.items[i]._caption;
}
}
var inputService = dundas.context.getService(“DataInputService”);
var del = inputService.deleteDataStorageRecord(“041163cf-c162-49df-b4e6-89293897f2d7”, “9049c9ed-6f1c-4d50-b664-6b919ecba836”, recordId);

del.done(function (message) {
var def = inputService.insertDataStorageRecord(“041163cf-c162-49df-b4e6-89293897f2d7”, “9049c9ed-6f1c-4d50-b664-6b919ecba836”, [selectedAction, customerId]);
def.done(function (message) {
// reload the scorecard
this.parentView.reset();
}.bind(this));
}.bind(this));

Please let me know if you need any more information.