Skip to main content
Question

Need to set column value using client script

  • February 9, 2026
  • 3 replies
  • 5 views

Forum|alt.badge.img+6

Hi,

I need to set a column value and save changes where the field is not present in UI. I tried using setControlValue, but it is not updating the field. How can we perform setvalue for a field using client script where the field is not present in UI but in the backend.

3 replies

Forum|alt.badge.img+10
  • Hero (Employee)
  • February 9, 2026

Hi ​@preethi.a05 ,

Have you tired setting the value using a client script sql in your client script?

 

Best Regards,

Morris


Forum|alt.badge.img+6
  • Author
  • Sidekick (Partner)
  • February 9, 2026

Hi ​@Morris ,

But I tried using setDBValue.


Forum|alt.badge.img+10
  • Hero (Employee)
  • February 9, 2026

Hi ​@preethi.a05 ,

I believe that setDBValue is only for mobile. but what I am suggesting to try is use getDBValues and instead of finding a value to return, try to use an update table set xyz = ‘zyx’ where abc =’{0}’

Something like that. I know it been attempted but I don’t recall the end results. but it would be worth a try. I know you are not trying to return anything, but this might be enough to work. btw are you trying to do this in the smart client or web client. 

Or another option is to put the field on the UI but make it hidden, then you should be able to update using the setControlValue option. In fact that would likely be the less cumbersome route

 

Morris