Field auto update

akin9 · ‎03-12-2024

Hello experts,

We have created a button "inactive aset" in "alm_hardware" table and confrmation

pop up also with Ok and cancel. its working fine.

Requirement

1.If user clicks ok then some of the field values needs to change automatically

on the "alm_asset" table like below.

2.This button need to visible for only "smartphone" and "computer" category only.

comments

Add comment:

1) Retired on >Date< by >User<.

2) Automatically retired on >Date< by System.

install_status

Retired -> ‘7’

I have tried with after insert BR for update fields. but no luck ,can you pls support!

any other approach

James Chun · ‎03-12-2024

Try this

function doRetire(){

	if(confirm('Are you sure?'))
	{
		gsftSubmit(null, g_form.getFormElement(), 'inactive_device');
	}
}

if(typeof window == 'undefined')
retireDevice();

function retireDevice(){
	current.setValue('install_status', 7);
	current.update();
}

View solution in original post

akin9 · ‎03-14-2024

Hi @James Chun

Thanks for your time being support!

akin9 · ‎03-12-2024

Hi @James Chun

Value is correct! pls check the picture.