Using a client script to edit one column in a List view after editing another

[johnsgp]

I have a list view and would like to change one column after editing another.   For example, in an incidents view, I might want to clear the User when the User Group changes to ensure the person editing the list assigns a new user to the incident.   I have already done this in a form using g_form.setValue('column_name', '') in the onChange function, but in a list I would need to pick the selected row, I'm guessing using the table variable in the onCellEdit function?   I imagine I can write script includes or business rules but this feels like it should be quite straightforward to do.

This does not work (perhaps I'm using the wrong column_name?):

function onCellEdit(sysIDs, table, oldValues, newValue, callback) {

  g_form.setValue('column_name', '');

  callback(true);

}

[tkalpa005]

Hi,

onChange() works only in form view, It will not work in List View, Best option you have is write a business rule and there you can check the value.

Thanks

KB

[johnsgp]

Thanks KB.   I only tried onChange on the form.   My question was about using onCellEdit on the list.

[Pradeep Sharma]

Hi Johns,

I don't think using cellEdit you can set the value of other field.

[johnsgp]

Hi Pradeep

Do you have a reference for saying this?   I'm clarifying because you wrote "I don't think that" which sounds like you're not sure.

I would guess that it must be possible.   It seems to me that there must be an object on the client side otherwise the browser could not display the list.   So it seems entirely possible to do this with Javascript if only I knew which object I can refer to, and if that object is accessible.   However, if it is documented as impossible, I will try another approach like business rules. The disadvantage of business rules is that they only run on save/update so the user gets feedback quite late.

John