We have a custom field that is being sourced from a saved search on our Item records. The thing is, when that custom field is shown as a column in a saved search view, it just shows blank values instead of the values that are being dynamically sourced. Is there any way to make it so that this custom field shows the dynamically sourced values in a saved search view?

It's b/c your custom field doesn't have Store Value checked. Solution I've used for this is to create a 2nd custom field with Store Value = T and then use a script or workflow to copy the value from the main field to the duplicate one.

Brilliant workaround @Justin B. Thank you, I'm going to try this out. For my sanity's sake, would you be able to confirm the following Netsuite mechanic for me: if you have a sourced field and "store value" is true, will it not dynamically update anymore? I could NOT find anything ANYWHERE online explaining how this works... Thanks very much 🙏 .

if you have a sourced field and "store value" is true, will it not dynamically update anymore?

That's true

Is there a way to make the workflow trigger on all item records without doing a bulk CSV import?

In your case, I would probably make it a scheduled workflow

@Justin B I made it a scheduled workflow, but it still seems like that the workflow "thinks" that the sourced field is null and the duped field doesn't receive any data in it. Did you set yours up in a particular way?

Have you create a good saved search for your scheduled workflow? And set up the workflow on testing mode And use set field value Select your custom field stored and from value custom field not stored Execute your workflow and check the log

Yes so I did all of the steps that you outlined above, but for some reason, whenever I hit "execute", it doesn't show on ANY of our inventory items' workflow execution logs... really confused as to what is happening @Marc.

have you summarized the saved search you use on the dynamic field?

Yes I have. The dynamic field is showing the correct data for each inventory item.

Modify the workflow to create or update ( not scheduled) And edit an item and save And check if you have a value in your custom field stored

message has been deleted

you should already check if it already works with the Create or update .

Okay I'll try that first

You are on testing mode on your workflow ?

Yes I am

This is normal when you are in testing mode. Only the 1st results of your saved search will be submitted to the workflow, you must be released

Ohhhhhhhh

Ahaha yess

Okay well I just set it to "Released" status now, hopefully this works. I'll let you know! Thank you so much for your help 🙏 🙏 🙏 🙏 🙏

my pleasure you’re welcome

@Marc typically how long does it take for Netsuite records to get updated (1 field update) from a workflow? I see that it updated only 294 item records and some items that have the dynamic field sourced still don't have the searchable field populated by the workflow.