Hi @Erick Dela Rosa-Oracle I was able to extract the value from a message field and store it in another field (custevent_case_creation). I then had a workflow action script that looks up the record referenced in the workflow state field(custevent_case_creation). and stores it against another…

Thanks Erick I am still trying to work through getting this formula into a script. I will let you know if this works once I am done testing.

Thanks @Mikko De La Fuente-Oracle I am currently looking at a few different options to achieve what I need... One of the other things I wanted to look at is the use of a Suitelet to capture information from the user and create create transactions. From my research on Suitelets, I can find information about it being used to…

Hi @Mikko De La Fuente-Oracle The only functions I can see from the moment library is // Moment prototype object function Moment(config) { copyConfig(this, config); this._d = new Date(config._d != null ? config._d.getTime() : NaN); if (!this.isValid()) { this._d = new Date(NaN); } // Prevent infinite loop in case…

Thanks @Mikko De La Fuente-Oracle Is there a way to have validation on the line so that it can only be committed for the quantity available? Anything above that cannot be saved?

Hi @Joy Noreen Magoling-Oracle I have found that even after the transaction is saved, the quantity for back order is not updated on the transaction. Or in this case, there is reference to the item being on back order if you create another transaction with the same item. However, the back order column is not populated on…

Hi Jack I haven't had a chance to test this yet sorry. I will do and post the results here. Thanks

Thanks Erick. Would a script use the same formula functions as, for example, a saved search? I have currently got a saved search formula which uses REGEXP_Substr which correctly extracts the value of the sales order number from the 'message' field. I'm not sure how that would be used in a script so that the extracted value…

Hi Ivy I realised why the issue was occurring. I had toggled the auto numbering feature on and off which was causing the name to appear in the hierarchy format. I switched it off and so didn't get a chance to test the formula sorry. I will mark this as answered as this does seem to be what I was after :) thanks

Hi Mikko. Did you mean checking the original third party library to see if there is a function or the script calling the function? With the script calling the function, this is the script being used: /** * Prompts the user if the current project has not been re-baselined in some time * * @copyright 2020 Stoic Software, LLC…

Thanks for looking into this @Joahnna Given Uy-Oracle Is this something that can be scriptable?

Update: It looks like when the email case capture first occurs, the html code and other elements of the original email are preserved. This is what is affecting the workflow. The workflow is applying the rule to the html version of the email and not the plain text version which is stored with the case once it is created. Is…

Thanks @Jack Daryl Espiel-Oracle I have noticed I am getting a different result for the exact same email message depending on where it is sent from When the email is converted to a case, the images or other elements of the signature are not preserved. What is it looking at in that case to classify this differently? These…

Hi Jack I am testing this in Sandbox (apologies I did not mention this earlier). I have found the cause of the workflow failing, I created the case in the UI and found that I received an error message on invalid syntax. I have corrected the formula. It previously was using either 0 or null in the case when statement…

With the internal ID of the base record, is there a way for this to be set to an array? The workflow needs to be initiated for more than one record. Basically, the script needs to be running continuously (every 2 minutes for example) on existing records. This will apply to more than one record. If I can store an array of…

Sorry @Jack Daryl Espiel-Oracle , I forgot to include a screencap of the case created via email capture:

Hi @Jack Daryl Espiel-Oracle I had amended the workflow to the following However, when I do, the email case capture fails to create case records. It only does when it is set to 'testing'. I had tried one other variation on the workflow: 1 I changed the status back to 'testing ' 2 Changed the workflow triggers to 'All'…

This is the case profile that relates to that email address The message creating the case I sent an email to the email address under the field inbound email address (on the case profile screen). A case record was created from that. Is that the information you were wanting for the email captures? EDIT: I have changed the…

Hi @Joahnna Given Uy-Oracle That is correct. The 'case issue' field doesn't populate once the record is created through the email case capture. If I create a case through the UI, when I save the record, the field value for 'case issue' changes to 'returns' in line with the workflow. The case created through the email case…

Looks like once the summary fields are taken out, the code seems to work. Posting it here in case it helps someone else: /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/search"], function (search) { function pageInit(context) { var customerSearchObj = search.create({ type: "customer", filters: [["stage",…

HI Jack So this will work when the email case capture first initiates and creates a case? I am currently stuck with the testing as somehow the email case capture has stopped creating cases

I don't actually know how to do that sorry so haven't been able to

That didn't work for me.... I was able to upload the script once I fixed the amdconfig file so that the file path for the third party library was and didn't reference the file extension or the '.' before the SuiteScripts location However, once the script is deployed, I am getting the following error: The third party…

Thanks @Erick Dela Rosa-Oracle That link is describing how to create an email alias so it masks the underlying netsuite system generated email address used for the plugin in implementation. What I was after was a way to change the email address that is used with the plugin implementation itself So for example, if I have a…

@Jack Daryl Espiel-Oracle A few additional questions: If I change the trigger to 'before user edit', how would this action trigger on existing cases since they are not being edited? With the examples mentioned in your post, they all seem to deal with changing the value of a field as part of the formula. In this case, I…

Thanks @Jack Daryl Espiel-Oracle So based on the linked threads and the Suiteanswers, my understanding is that I would use a suitescript/javascript api formula to work out the condition (in this case, to search the body of the message for certain keywords in the string) and then set the field value as a single selection?…

I have tried both 2.x and 2.1. This is the error message I get with 2.1: The amd config json file (saved in the same location---this being the Suitescript folder): { "paths": { "moment": "./SuiteScripts/moment-with-locales.js" } } I have tried this with a min.js file too The script I am trying to upload: /** * Prompts the…

That doesn't appear to initiate a scheduled script though (at least not according to the code samples)

I have this exact same issue @ChrisH though this is in the Sandbox and demo accounts

Thanks @Mikko De La Fuente-Oracle Is it possible to use a script to trigger a scheduled workflow though?