Perspective Table Edit certain cells and write into DB

[paul-griffith]

@Gaurav.Shitole

How do I make certain cell ‘editable’ automatically when the table.props.data changes

I would recommend against trying to do this with a 'value change' script - instead, just add a transform to your data fetch.

If you're pulling the data out of a database already, then it should be fairly easy to write a transform - something like the process defined here (although that post assumes your data is coming in as a dataset, not a json array):

Perspective Table - Invididual Cell Conditional Formatting

A maybe more maintainable variation, if you ever intend on adding other columns you need to style: def cc_msval(v, r, c): style_orange = {"backgroundColor": "#F7901D"} style_green = {"backgroundColor": "#00AA00"} return { "value": v.getValueAt(r, c), "style": style_orange if v.getValueAt(r, c) < 95 else style_green } transforms = { "CC_msval": cc_msval } return [ { value.getColumnName(col): transforms.get(value.getColumnName(col), lambda v, r, c: v.getValueAt(r, c))(v…

---

@Gaurav.Shitole

I have created a script to write updated values into DB, but not sure if its a safe and standard way.

I don't see any big problems with your script. Coping the values into the updatedData list and then looping over that list is unnecessary - you could just loop through the table's data array directly:

	table = self.getSibling("Table")	
	recipeID = self.getSibling("Dropdown").props.value

	#pulling updated values from table and putting into a list
	for row in table.props.data:
		newValue = row['CONTROL SP']
		ID = row['ID']
			
		params = {
			"id": ID,
			"recipeId": recipeId,
			"newValue": newValue
		}
		
		system.db.runNamedQuery('ProjName', 'UpdateQueries/ControlSetpoints', params)
	
	table.refreshBinding("props.data")