Use GlideRecord() in function field

[MiY]

Hi team,
I want to use GlideRecord() method in function definition field because need to query other table and get specific field value.

Detail requirements follows;

Create a field 1 (<-function field) in table A.

I want to set field 1 to part of table B's field 2.

table A is referenced by table B's field 3.

Can I build this function?

Please help me.

Regards,

[Bhimashankar H]

Hi @MiY ,

I hope you saw my reply. 

If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. It will help future readers as well having similar kind of questions and close the thread.

Thanks,
Bhimashankar H

[MiY]

@Bhimashankar H -san,

@Ravi Gaurav -san,
Thank you, I understand that this can be achieved by creating a Business Rule.
What I'm concerned about are records that were created before this implementation.
This requirement is occurring for an operational table that is already GoLive.
As a result, some records have already been created.
If this requirement could be achieved with a function field, it would be possible to fulfill this requirement without updating the records that have already been created.
However, I understand that with Business Rules, this implementation does not apply to records that have already been created.
Could you please tell me if there is a way to apply this change to past records even when using Business Rules?

Regards,

[Bhimashankar H]

Hi @MiY ,

If you implement this solution then you need to write a fix script to apply the functionality for previous records.

Form the query that will give you records which does not have this functionality then process those records and update in script. This way this can be moved to PROD as well from DEV.

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[Bhuvan]

@MiY 

Function field defined inside reports cannot be accessed from server side scripts. Create a new field in Table A that will store the value rather than function field and use gliderecord as per requirements. 

If you do not want to create a new field at table level, create a database view if number of records will not grow exponentially.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@MiY 

Did you get a chance to review this ?

If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan