[kbarua]

I created a custom item field that populates based on the results of a search that I selected for it. The field displays a value correctly on the item record.

The issue is when I add this field to another saved search, the column results are blank. I think this is because Store Value = False in the field definition.

I found SuiteAnswers ID: 29626 that says to use a workflow. But my custom item field doesn't use any formula per the article.

Has anyone been able to show the value of a custom field in search results if that field derives its value from a search itself?
This is a cached copy. Click here to see the original post.

[JCirocco]

Interesting, I JUST posted almost the exact same question. I thought this used to work also.

---

kbarua replied on 11/27/2017, 05:03 PM: Yes, I see your post too.

[pmjeffrey]

Yup. This doesn't work as you aren't storing the result of the saved search in the database (not possible as it always changes based on your search) so it cant be accessed via a different search. The benefit of this approach is that you know when you are looking at the record itself, the field value is 100% real time accurate, but it only works when you are looking at the record in the UI.

If you also need to be able to search for records based on the value set by this defaulting the best recommendation I could make would be a workflow on a SECOND custom field with store value = T that sets the value based on your first field. If you schedule this workflow, you can ensure that your second field is as accurate as the time parameter on your schedule allows, if that makes sense. Hope that helps!

[kbarua]

Thanks, I overlooked using the "From Field" parameter of Set Field Value.

I scheduled the workflow and now the values in the second custom field do show in the saved search.

[pmjeffrey]

Perfect. Glad it helped.

[Author]

Posts