Finance | Project Operations, Human Resources, ...

How to assign values to custom fields based on a standard field available in the same table

(0) Share

Report

Posted on by Ganesh Potnuru

172

Hi There,

I have a requirement that I need to add some custom fields in SMMActivities form and already in the activities form there is some data for the standard fields available, I need to add these custom fields and update the custom field data according to available data.

So I have added custom fields in smm activities table and I'm not getting which method or event handler I need to take. I have tried with init method extension of smm activities form but unable to get the current smmactivities record because i need smm activity number to update custom fields. Please help me to achieve this.

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

So that means you have added few custom field in a standard table and you need to update it based on the already present data. Then you need to write some custom batch job to update these records. Else if you have an entity and Excel file with required data, you can use that to update these fields.

Was this reply helpful? Yes No
Ganesh Potnuru 172 on at

Like (0)

Report
Copy link

Link copied!

Hi Bharani,

Thanks for the suggestion.

Need one more clarification, if I want to assign some values to these custom fields I can write code in table level init() method right? So that next time if I create a new record, data will insert in these fields right?

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

At table you have initValue method. Init is for forms.

Yes to assign a default value you can write code at initvalue of the table. But kindly check if these default values should reflect on all forms where this table is used.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, If this is one time activity then I would suggest to create a runnable class and write logic to update all records. If the logic is simple then you can write SQL query and save time of code deployments.

However, if your requirement is to populate values of the custom fields always based on existing data then table method initvalue as suggested by Bharani. If not works then please provide need more details of the requirement

Was this reply helpful? Yes No