About OnCellEdit in Client Scripts

Ryo Ogasawara
Tera Contributor

Is it possible to create a client script for OnCellEdit that meets the following requirements?

• Only one client script will be created
• The script will execute when a cell is edited.
• The script will execute regardless of which cell is edited.

I would appreciate everyone’s assistance.
Thank you!

1 ACCEPTED SOLUTION

Astik Thombare
Tera Sage

Hi @Ryo Ogasawara ,

 

Good day !

 

The first two requirements are achievable with the one onCellEdit client script, but the third requirement is not possible when creating onCellEdit client script. It will ask on which cell/field it should work, so basically only when that particular cell/field is edited then only the onCellEdit client script will work

 

AstikThombare4_0-1712993137090.png

 

Please Mark Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact

 

Thanks,

Astik Thombare

View solution in original post

3 REPLIES 3

Maddysunil
Kilo Sage

@Ryo Ogasawara  Please check below response:

OnCellEdit client script runs on a particular field so your last statement is not possible...

Screenshot 2024-04-13 at 12.51.10 PM.png

Please Mark Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

 

Thanks

Astik Thombare
Tera Sage

Hi @Ryo Ogasawara ,

 

Good day !

 

The first two requirements are achievable with the one onCellEdit client script, but the third requirement is not possible when creating onCellEdit client script. It will ask on which cell/field it should work, so basically only when that particular cell/field is edited then only the onCellEdit client script will work

 

AstikThombare4_0-1712993137090.png

 

Please Mark Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact

 

Thanks,

Astik Thombare

kamlesh kjmar
Mega Sage
Mega Sage

Hi Ryo,

 

Oncell edit is a field specific client script that means it will work only for the field for which you have configured it and not for all fields.

 

But if you try to modify multiple cells of the same field then yes, your script will work.

 

Thanks,

Kamlesh