プロフィール
Avatar
ロック解除可能なバッジを表示 ロック解除可能なバッジを表示
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!

We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.

View Your 2025 Community Recap

Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!

Tom Dalton · Owner · Silver Medal

コメント

  • The standard log-in that comes with any NS web store takes user to a different "customer center" that the v2009.1 custom hosted log-in described earlier in this thread. Customers that log-in to your "Customer center" through the normal customer log-in will get to YOUR store's customer center and it is impossible for them…
    で Customizing Login and Logout Tom Daltonによるコメント Mar 30, 2009 7:05PM
  • I tried using this feature today and found it to be worhtless: I have registered as a customer at OUR netsuite webstore (for when I test the user experience at our web store). I have ALSO registered (as a customer) at several other netsuite hosted webstores (like wine box warehouse). I followed the steps and added the form…
    で Customizing Login and Logout Tom Daltonによるコメント Mar 29, 2009 5:32PM
  • I would also find creating matrix items from kits very useful. -Tom
    で Matrix items and kit items Tom Daltonによるコメント Jun 1, 2009 7:49PM
  • With the new 0S3.0's support for external hardware, this would be a good way to integrate a barcode reader to do inventory counts. No barcode reader needed with the iPhone... http://www.ismashphone.com/ -Tom
    で Iphone App Tom Daltonによるコメント Jun 1, 2009 5:45PM
  • you need to know the id of each field you want to include - you can find these by using the formula popup on a formula result field, among other means. There was no "pop-up field" for tracking number. I also couldn't find the "Filed ID" for tracking numbers anywhere in the NS help. Can you tell me what it is and where the…
    で Creating Life Cycle Automation in NS? Tom Daltonによるコメント Jun 18, 2008 12:07AM
  • The NetSuite instructions say... You can include values from search results fields in this text by entering field IDs enclosed in curly braces {fieldID}. Select a field in the Insert Field dropdown to insert its field ID. The "Insert Field dropdown" seems to have ZERO effect when I use it. Is it not mac compatible? Tom
    で Creating Life Cycle Automation in NS? Tom Daltonによるコメント Jun 17, 2008 11:50PM
  • I also want to use this feature. I didn't know it existed until I read this thread. I've got to start reading the memos!! Wait ...am I getting the memos? Evan, you gave some partial instructions: You can use a transaction search and set the criteria to type=invoice, main line=true, date is 30 days ago (or 60 days ago or 90…
    で Creating Life Cycle Automation in NS? Tom Daltonによるコメント Jun 16, 2008 10:24PM
  • Evan, you may want to try it on a mac. It doesn't do anything. I tested in Safari and FireFox3. T
    で Creating Life Cycle Automation in NS? Tom Daltonによるコメント Jun 18, 2008 5:45PM
  • How would one make this… CASE WHEN {custitemitem_feed_image_url} LIKE '%JPG$' THEN ... include "GIF" So, WHEN {custitemitem_feed_image_url} LIKE '%JPG$' or LIKE '%GIF$'
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Jan 4, 2017 11:32AM
  • I need a text "availability flag" for a feed. I need it in a custom item field of "type = free form text". Any reason why this isn't working as the field's default.... [INDENT] CASE WHEN {isdropshipitem} = 'T' THEN 'in stock' WHEN type = 'Kit/Package' THEN 'in stock' WHEN {quantityonhand} > 1 THEN 'in stock' ELSE 'out of…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Jun 18, 2018 6:33PM
  • Is there any way to reference dynamic group membership in a formula? So, then a custom field can become a flag for inclusion in a specific group. So, if we have a dynamic group of customers called "one time purchasers".. could we get a field that sets to "Yes" or "True" based on if the customer is included in that group?
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 6, 2017 12:12PM
  • I need a formula (in a custom field or a saved search) to make each parent item show it's total count of orders for all of its children (previous 12 months). The same formula would also show the count of orders for non-matrix items and kits. It just wouldn't show any line items for matrix children. I like count of orders…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Oct 7, 2016 1:10PM
  • I need to remove "> " from the left side of a text field. My mass update uses the formula LTRIM({my_custom_field},'> ') and it doesn't work. If I change "> " to "> " (*its HTML character equivalent) then it works when I "preview" the update, BUT when I save the mass-update and re-open it ....it no longer works because the…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Sep 26, 2016 7:47PM
  • Thanks, I had already got it with a Regular Expression formula. It found the first digit that was A-Z and then chopped of anything before it. That worked better because I never had to find a ">" character.... which caused issues.
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Sep 29, 2016 6:50PM
  • Evan, Here is another example of the broken issue that I'm having a hard time getting support to understand. These formulas work in a custom text field .They work in a non-matrix item and in a matrix parent item and in a child item. Custom Item Field = NVL2({parent}, 'child item' , 'not a child item') Custom Item Field =…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Mar 29, 2013 12:47PM
  • Let me know how it goes.. I tried this for the storedisplayimage, NVL2({parent},{parent.storedisplayimage},{storedis playimage}), and it worked. Mondray, you are correct. That formula works for non-matrix items. It also works for matrix parent items. Now, what about matrix child items? That is where we are having the issue…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Mar 28, 2013 3:11PM
  • I experienced the same thing initially.. What I did was use the "item url" field first or the "image url" field. then i used the storediaplyimage again then it worked. Somehow there is really a defect on initial use. i think that's what's in the defect that was filed for you. Can you try that in the default value field in…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント May 5, 2013 2:58PM
  • tried again as per your post. no go.
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Apr 16, 2013 12:07AM
  • Mondray , it was Case Number 1627762 and it resulted in Defect 245256.
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Mar 13, 2013 3:13PM
  • I'm a hack, but good at copy/paste. I need a formula for a dynamic DIV ID. So, the service I'm working with says we need <div id="Reviews-productId123"></div> to show their dynamic content for each item. productId123 would be each item's actual NetSuite item ID. Can someone post an example of how that would be done? Could…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント May 18, 2016 2:51PM
  • Any formula with {parent.internalid} doesn't pull the parent internal ID. For example, we're using it in a custom field and it is used in matrix children to show their parent's internal ID. Is there a workaround? Trying to do this: NVL2({parent},{parent.internalid},{internalid}) ...so that in both children and the parent…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Nov 6, 2014 4:20PM
  • There is something very WRONG with NetSuite. This works... CASE WHEN {parent.imageurl} IS NOT NULL then 'child item' else 'not child item' end Assuming that all items have images It returns 'child item' on matrix child items. It returns 'not child item' on all other types of items. Also, if I make a custom field =…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 15, 2013 2:20PM
  • So, are you saying that this formula works in you child items??... NVL2({parent}, {parent.storedisplayimage} , {storedisplayimage}) I use the above formula in my account and I get "ERROR: Field Not Found" in ALL child items. Ask support to look at the custom item filed named "Mondray" in our NS account. It identical to…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Apr 13, 2013 2:50PM
  • Tom - That definitely seems to defy logic. Perhaps you can report to support and get an issue (not case) #, and post it here - then I can take a look. Evan, We still really need a formula field that shows the URL of the item image. I challenge you to make one. The formula for making one is fairly simple, but for some…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Apr 7, 2013 10:53AM
  • Mondray, Skip the Item search screen shot. Show me the "default Value" field in a screen shot as it displays in each item type (Not just matrix-child). So, show it for matrix parent, matrix child and non-matrix. In our case we've tried that formula in your screen shot and about a dozen variations including using shadow…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Apr 15, 2013 7:00PM
  • Actually Mondray, I emailed support on this. The found that there was an issue. They created a S3 issue. I worded it different, but the concept was similar. I'll see if I can get the issue number.
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Mar 12, 2013 11:12PM
  • Disregard.. found issue
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Feb 11, 2013 4:54PM
  • This is from the case 1627762: This formula works on Matrix Child items. Custom Item Field = {parent.storedisplayimage} This formula works on Matrix Parent items and on NON-matrix items. Custom Item Field = {storedisplayimage} Yet this formula (that uses the two fields above) works on matrix parent and NON-matrix items,…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Mar 13, 2013 10:12PM
  • OK, using the following formula (in a custom transaction body field) works... CASE WHEN {trackingnumbers} like '1ZY%' THEN 'UPS' END What confuses me is that the field shows "ERROR: Field Not Found" when viewed in the item fulfillment record. The same filed shows "UPS" when used in an email template based on an item…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Oct 31, 2011 3:37PM
  • Never mind. {trackingnumbers} is fine and was not causing the problem. It is weird. Overnight I left the formula so that {custbodyshipcarrier_cstm} = {trackingnumbers}. This morning... On the fulfillment record, it still has "ERROR: Field Not Found", yet on a 4am automated email generated from a saved search; it had a…
    で 100 Ways to Use Formula Fields Tom Daltonによるコメント Oct 28, 2011 10:47AM