@Mel H I've used this for one of our forms. <#if item.custcol_wrm_reg_hid_trackwarranty=="T">${item.inventorydetail}</#if>

Hi @Elychelle Gulen-Oracle I think I've worked it out. I rebuilt the criteria and it seems to have worked. I also used #display in the field brackets and created a new formula field as a string.

Hi Johanvl, I've utilised the following formula though it is not perfect. round(max/* comment */({messagedate}) over (partition by {customer.entityid} order by {internalid} desc rows between 1 following and 1 following) - {messagedate})

Hi @JohanvL The emails come from customers directly, so I'd need to do the saved search off the Customer Record linking the messages associated with it. The message table doesn't (that I can see) have a field for an associated message. I probably need to write a query which, per row, returns the previous row which has the…

Hi All, Excuse me for jumping on this thread though I have a separate but related query which @Elychelle Gulen-Oracle your response may solve. If @JohanvL you've your solution I'd be very interested to know about it too. I'd like to be able to report (via saved search) the time between an incoming email and the subsequent…

Thank you for this! @User_HIG7E

@3955366 Hi, I'd be interested in an answer to this too. My issue is slightly different. We have a drop down then a sub drop, currently we have to create a list for the main drop down, then individual drop downs for the options based on the first choice. For example say if had a choice of shape, then colour, is there a way…

Thank you @Gregz-Oracle and @Veronica Steluta Mincior-Oracle It is a bit odd that Created Date isn't an available filter. If required at a later stage we may need to create the additional custom field, though best practice would be to keep additional fields to a minimum. As Gregz noted, we may need to run formula. Many…

Edited original comment/post, it should read - "we can't filter by Created Date"!

Hi @Tris Mendoza-Oracle For me it is status reference key 8. It was a status I set to inactive, though have since reactivated it. Is it showing the error because I still have entities with that status? I tried to replicate in Sandbox and didn't get the error. I've also made other statuses inactive without getting the same…

Hi @James Parkin and everyone, I too am a weary traveler! We made the mistake of creating too many entity statuses and have since started to set a number of them to inactive. Is the error message related to a workflow or just to the field in general, as in, is there other options to remove the message and still keep the…

@Michelle Jabanes-Oracle Hi Michelle, As attached, the Funding Record field on the Opportunity is set to Edit

Hi All, just seen there are 2 formula's depending on if it is from Client or Server. Have tried using + and it has worked!

Hi @Ivy Lopez-Oracle, Josh and All, I have been trying to attempt this too. I find that whether I use 'text' or field labels I can only get the first value to display via the workflow. What am I doing wrong? The example above I'm trying to pull a custom field which is before the Title field and a random word to add to it.…

Zoomed in on the Funding Record.

@Able Wilson @Michelle Jabanes-Oracle Hi Both, For example if you took a Customer Search you are able to select "Transaction:Transaction Number" which when run would display all the Related Records against that Customer. We do have a field on the Funding Record which is 'Opportunity' and this is auto populated when an…

Hi Michelle @Michelle Jabanes-Oracle The "Funding Record" is a Custom Record, though the Opportunity (and its Document Number field) is standard NetSuite Record. The Saved Search is against the Funding Record, where I'm trying to pull in the Opportunity Document Number from Opportunities rows within the Related Record tab…

Hi All Sorry to jump onto this post but I have a similar problem. @Michelle Jabanes-Oracle Michelle, We have a custom record (Funding Record) which has Related Records which include Opportunities, etc. You can view the Related Record but I can't see the "Transaction" fields available to select in the Results area for the…

UPDATE, please ignore. Found the help guide

@Michelle Jabanes-Oracle The trouble is we keep having to change the links, as it works for a while, then they get broken, it seems really unstable. Does Oracle run tests for users (companies) like us who use a secure link through like us for example Stratokey for encryption, before releasing new updates? Many thanks…

@Michelle Jabanes-Oracle Hi Michelle, Emails we are sending out to external people, the images are broken? If we send them to internal recipients they work fine? This only just started happening in the last few weeks? Has something happened? Please help, this is affecting everything in our business.

Is this happening again? @3955551?

Hi @Lewalsh11741 Have you got an example I could compare with ours. We lost the links, then tried to change them, they worked fine then failed again. We initially had to put all the images into our google drive and link them across to NetSuite, then they broke. So we then put them into our NetSuite and it worked, then they…

Thank you Nathan @User_8ZIY6 For us we had a couple of users experiencing problems in 2023 and the above worked. Then suddenly (and literally over night from last Friday) multiple users are having exactly the same problem. Clearing the cache wasn't solving it, so fingers crossed pausing the extensions will work, though I'd…

Thank you @Micah Timbol-Oracle I've requested users to do this and report back if they continue to have further issues. I'm not sure if the problem gets worse as time progressing from first logging in at the beginning of their day. Regards Richard

Hi @Micah Timbol-Oracle and @NKusiak We continue to have the issues with Chrome. 3 different users are struggling when in Chrome, when using Edge it works fine. We have tried all the suggestions but still it continues. When in NetSuite the users are unable to select from the drop down in fields, the + (plus) sign sometimes…

Hi @Tigran Shahnazaryan Is NetSuite iFrame Custom Portlet an add on? Not being able to have Pie Chart views on anything other than "Report Snapshots" is extremely restrictive. Many thanks Richard

That's awesome, Thank you @Jervin Nicholas Teopengco-Oracle

I think I've found it. && is what I required.

Hi @Kristoffer Viray-Oracle This is really useful though I need to combine 2 if conditions. For Sales Order I need to show a sentence if the Billing Country is (Belgium) and the Total VAT amount is 0. I can run them separately but I don't know where to add the "and" function! Can you help? <tr><#if…