How to save the initial value computed to the database without having to save each record

[VincyJelsingh]

Hi,

I am trying to auto-populate values using initial values field but unfortunately for this value to be reflected in the database, it requires each record to be saved. Though the initial value computed can be changed by users, we do not want them to save each record everytime for the value to be saved in the database. 

Is there any way I can work this?

[Steve]

You want to save the value without saving the value? This makes no sense.

[VincyJelsingh]

Hey Steve,

Thank you for the response.

Ideally, I want to store that initial value computed into DB as the initial data for that field unless a particular one has been overwritten. So the scenario is, we would like to allocate a field with some contact numbers based on certain other fields. There could be a single contact number or multiple for a particular select query pulled by the initial value expression. These contact numbers are retrieved as text fields and we would like it to be editable by users if required, otherwise it remains the same. As there would be 100s of records that they would have to save individually, we would like to know if there is any alternative way of still computing the initial value and storing in DB but also allowing the fields to be editable for users to alter it if required which gets overwritten in the DB.