I have a request form one of our groups to see if it would be possible to have a checklist answer populate a custom field on the asset record view. I know that the checklist tab under an asset has any item that is filled out on a WO checklist, so it is at least part of the asset, but can it then bring this information into a custom field on the record view. An example for us is what a pipe is made of. When our field personal have to dig up a pipe for a repair they are required to fill in on a checklist what the pipe is made of. We have a custom field on the record view with this information that comes form our GIS information, but it may be wrong. We would like it to correct this if it is different then what may be there. Also, some of them do not have this information at all. Any thought or possible solutions would be greatly appreciated.
Thanks John
Hi John,
Yes, it is possible using Flex SQL on r5actchecklists. I would recommend calling this procedure in the flex to easily populate/update the custom field value: o7prop.store_value(custom field code, entity, value, class, class org, record code, datatype, date format [null if not date])
Example: o7prop.store_value('NONCOMPL', 'EVNT', 'COMPLIANT', '*', '*', '123456', 'CHAR', null)
I hope this helps. Let me know if you have any questions!
Thanks,
Jaime Sanchez