How to add thousand separator to a variable in an MRVS in the modal dialog shown when clicking 'add'

[smicloud]

I would like to add a thousand separator to a variable in the modal dialog opened when clicking 'add' to an MRVS in a record producer. 

I can find no way to do this. I think it is not possible but I hope to be proven wrong. 

On a variable in the record producer form I can do this using onChange catalog client script on the variable. Unfortunately this option is not available in the model dialog of the MRVS. 

I was thinking perhaps a custom variable using widget can be used but I can't figure out how that would be work in that case. 

Any ideas?

[Shashank_Jain]

@smicloud ,

• Direct onChange client script in MRVS modal? → Not possible.

• Best path if you need formatting in the modal: create a Custom Variable Type for numeric entry with built-in formatting.

• If “nice to have” only: format values after they’re added back to the MRVS table (not inside modal).

[smicloud]

Thank's for the answer!

I am looking into your option of "Custom" Variable Type. Could you explain a bit more how to do this? Verifying the format is possible (e.g. using "Single line text" variable  + Validation Regex). But how can I format what the user enters in the variable field using "Custom" Variable Type? 

[smicloud]

That second option doesn't work. You cannot add a custom variable to MRVS: 

[Shashank_Jain]

@smicloud ,

Use MRVS for simple data entry.

If formatting or special UI behavior is essential → build a custom widget or related list approach instead of forcing it into MRVS.