I have a custom project field to be populated with a related transaction document number. The type then is List/Record and the List is Transaction. The value is to be set in the custom field is based on the results of a saved search. Is script the only option here to set the value? Summarized saved search field does not seem to be available for a list/record custom field.
m
MGBC
04/29/2023, 1:24 PM
If the summarized saved search value is the internal id of your list/record then a set field value action in a workflow can do this
Just put your sourced field as a formula in your set field value action
l
Luis
04/29/2023, 11:15 PM
Actually, the option to select a saved search in the custom entity field is not available. It does not seem possible to use a summarized saved search to populate a custom List/Record field (directly in the Field record).
m
Marc
04/30/2023, 9:39 AM
It’s for custom transaction body field or Entity field ?
because I already used a summarized saved search for a list ( I use the internal id in the saved search )
Marc
04/30/2023, 9:47 AM
1-You can create a free form text for custom field with summarized saved search
2-create a custom field 2 with store value and list
3- create workflow to set field value ( copy custom field 1 to custom field 2)
l
Luis
05/01/2023, 12:46 AM
It's a custom entity (not transaction). I was hoping to use list/record but I guess I'm stuck with a free-form text now. Thank you.
m
MGBC
05/01/2023, 2:35 AM
@Luis a free form text field can be used to populate a list record field If the free text field holds the internal id of the list/record