How to fetch total cost field in contract record an

chandana karnat
Tera Contributor

Hi,

 

I need to fetch total cost field from selected contract record in my catalog item and auto populate that fetched total cost value into cost variable (single line text)

 

Thanks in Advance

9 REPLIES 9

Ankur Bawiskar
Tera Patron

@chandana karnat 

is contract a variable on your form?

share your screenshots.

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar 

Yeah, it is reference variable refers to contract table(ast_contract) but total cost from selected contract record is not auto populating correctly in total cost variable (single line text) 

chandanakarnat_0-1769765503448.png

 

total cost from above selected contract record 

chandanakarnat_1-1769765604485.png

Thaks and Regards,
Chandana.

@chandana karnat 

no scripting required

you can use auto populate feature in catalog item

Auto-populate a variable based on a reference type variable (Utah) 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar 
i used auto populate feature for total cost variable it not working as expected.