I was also in the process of creating a hyperlink in a saved search and hope the following helps. Also a quick tip for any newbies with the concat Formula... you can only concatinate 2 items at a time. concat('<a href="http://www.test.com?id=', concat({internalid}, '">Click Here</a>'))

I don't think you can do that via CSV imports... could be wrong

right - because it has to search every record to find the matches, and to_number in oracle throws an error if the argument can not be converted. We should try to trap that error so we can get you a better indication of what is going on (though it still wouldn't tell you what is causing the problem.) You can use a regular…

nope I will try to cut the search down to 150 - 153 Will keep you posted

So I played around with the formula TO_NUMBER(case when greatest(length({zipcode}),1) = 5 then SUBSTR({zipcode},1,3) end) Please correct me if I am wrong but I believe the following parts of the above control the results Example 1 (case when greatest(length({zipcode}),1) = 5 - Means zip codes with a length greater then 1…

So if one zip code contains an error (i.e. missing a digit or had a letter rather then all numbers) I will keep getting an error? what if the zip code with the error is not between the values that I am searching? What would be a quick way to locate the error?

I have tried just about every combo 151 - 152 152 -153 and so on each results with an error

didn't work...

Will test it out!!

That is what I started with... a new contact search

You could try using a Numeric formula filter: something like "TO_NUMBER({SUBSTR(zipcode,1,3)})" and then your criterion would be between 160 and 168 for example. Thanks, Yang what is the values "1" and "3" in the above example refer to? Thanks for your help

Went I click preview I get the following response An unexpected error has occurred. Please click here to notify support and provide your contact information.

I get the following error Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit. These are the steps I take - create a new contact search - Select Formula (Numeric) for the filter - in the Formula field…

Evan, I did the search in order to locate a zip code with an error non numeric value besides a dash and or spaces however I couldn't find any with a letter value. What it did return all zip codes that included the dash ##### - ####

Ok.. so I must be doing something wrong.. Step 1 - Created a saved customer search, did not select anything as search criteria, placed a check box in the sublist option Step 2 - go to customization > sublist > Entity Tab - But because I didn't select anything as the search criteria I can't select the saved search. I search…

Evan, If you select "Contact Fields" and then Internal ID a pop up window appears and wants me to select any of or non of, what should I write for the value. I also noticed that there is an Internal ID (numeric) that you have many more options to select from Chris

Works like a charm!!!! Thank you!!

Now I can't get that saved search to show up in the drop down list for saved searches

That is what I thought I needed to filter by, however how do you tell the filter to filter by the current Contact: Internal ID? The filter popup field wants you to filter by "any of" or "non of".

I am trying to create a sublist displaying all leads for the current contact record, any suggestions to what my saved search must contain? I have been able to display a sublist in the proper location, however the search doesn't display any results.

Any chance I could use a wildcard or javascript?

Can you provide more details of what your trying to do? I think I understand the general concept but need a few more details.

Yang ????? an example.. I can't get a formula to work?

Can you provide an example that I can build on???

I believe if you adjust your preferences On the home tab at the bottom you will find Set Preferences --> Transactions --> Printing Look at the default checked value for printing hope that helps

Any update on this?

BUMP... I was able to create a 2 page html file but would also like to create a 2 page PDF.

Steph, We have built several responsive NetSuite websites on the SuiteCommerce platform (http://www.intente.net/customers.php). While it is possible to build a fully functional responsive NetSuite website using the SuiteCommerce module, customers with hundreds of categories and thousands of items will instantly get to…

It is an involved process, but it is possible. The following link has several examples of mobile friendly Site Builder websites. http://www.intente.net/customers.php

Have you tried contacting Kerrie at Intente.net?