My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges

Cloud Red Ribbon

Comments

  • I also tried this : SUBSTR(char, 3,2), CASE WHEN NVL({custitemcustitem_item_weight},0) < 50KG THEN '£3.50' ELSE '£35.00' END but it doesnt work. sometimes the 3 may chage to 4? like 100KG I will go back and take then KG off.
    in Using Formula (Text) and CASE statements Comment by Cloud Jun 10, 2011 6:03AM
  • Richard, Sorry for asking this stupid question (not good with scripting) but is that a .js file? I just entered it in the Timer CRM field I created. and it doesnt work :) Thanks
    in Timer on Event Page Comment by Cloud Jun 17, 2011 11:05AM
  • Morning, @Khultquist, I tried it and it worked. :D thank you thank you thank you :D to be honest, I did try CASE WHEN last night but it didnt work, tried it again and still didnt work, so I realized as I set the custom field as 'currency' I might aswell remove the £. and voila :D so then changed the custom field to Free…
    in Using Formula (Text) and CASE statements Comment by Cloud Jun 10, 2011 4:11AM
  • Hi, Any ideas with this? I am really struggling lol .. CASE {custitemcustitem_item_weight} <= '50' THEN '£3.50' ELSE '£35.00' END
    in Using Formula (Text) and CASE statements Comment by Cloud Jun 9, 2011 12:33PM
  • Hi Elie, Thanks for the super fast answer :D , I tried this and still appears as a Invalid Expression : CASE WHEN {custitem_ebird_pre_order} IS NULL THEN '' WHEN {custitem_ebird_pre_order}= 1 THEN CONCAT(CONCAT( '**Please Note: This item is currently out of stock, Pre-Order now for delivery Week Commencing ',…
    in Using Formula (Text) and CASE statements Comment by Cloud Jun 17, 2011 9:52AM
  • Sorted out :D thanks hard to find system help!! I used {onlineprice}*1.20 and set it as currency. I guess I set it up as numeric or other. but after 24hours of trying to find a way... its finally working.. Yaaaay!!
    in Online Price to show under Pricing Tab - With Picture :) Comment by Cloud May 27, 2011 6:39AM
  • Oops lol. Thanks once again Elie. Have a Great Weekend.
    in Using Formula (Text) and CASE statements Comment by Cloud Jun 17, 2011 12:17PM
  • is there a way, I can set it to 0? as a default? I did try using : CASE WHEN {custitemcustitem_item_weight = 0 THEN '£0.00 WHEN {custitemcustitem_item_weight <50 THEN '£3.50' ELSE '£35.00' END but that too didnt work :( thanks
    in Using Formula (Text) and CASE statements Comment by Cloud Jun 10, 2011 11:58AM
  • Have some items where the price shows NULL. Even though it has a base price.
    in Online Price to show under Pricing Tab - With Picture :) Comment by Cloud Jun 20, 2011 8:53AM
  • Sorry Elie. I tried nesting it and its working fine :D I am using this : CASE WHEN {custitem_ebird_pre_order} IS NULL THEN '' WHEN {custitem_ebird_pre_order}= 1 THEN CONCAT(CONCAT('**Please Note: This item is currently out of stock, Pre-Order now for a 10% discount by using voucher code : EBIRD. Item will be in stock week…
    in Using Formula (Text) and CASE statements Comment by Cloud Jun 17, 2011 11:51AM
  • Thanks Khultquist, we created another field to display the same formula and it has worked fine, on the searches, Do not know why it didnt work from the original field. However another thing im having difficulties filtering is _. we have some matrix items and child items and normal inventory items with _ in front of it. E.G…
    in Problem with Saved Search : Custom field with Formula Comment by Cloud May 20, 2011 9:55AM
  • THANK YOU,THANK YOU THANK YOU ELIE!!! :D :D its worked !! :D I would kiss you if you was here lol.. but seriously your answer is greatly appreciated. :) CASE WHEN {custitem_ebird_pre_order} IS NULL THEN '' WHEN {custitem_ebird_pre_order}= 1 THEN CONCAT('**Please Note: This item is currently out of stock, Pre-Order now for…
    in Using Formula (Text) and CASE statements Comment by Cloud Jun 17, 2011 10:21AM
  • Hi, I have made this case formula and it works however I cannot get it to display another field. The below formula works fine. CASE WHEN {custitem_ebird_pre_order} IS NULL THEN '' WHEN {custitem_ebird_pre_order}= 1 THEN '**Please Note: This item is currently out of stock, Pre-Order now for delivery Week Commencing & Get…
    in Using Formula (Text) and CASE statements Comment by Cloud Jun 17, 2011 9:12AM
  • Any help? Please ...
    in Margin Comment by Cloud May 13, 2011 12:09PM
  • sorry which area? the criteria or the result? am I still to use the formula? Thanks
    in Margin Comment by Cloud May 18, 2011 4:05AM
  • Sorry Evan, I forgot to say, Thank You... :)
    in Margin Comment by Cloud Jun 16, 2011 5:32AM
  • Criteria subtab: formula(numeric) {cost}-{vendorcost} is not equal to 0 hi thanks, I have used it and Its working :) its found 28 items. So I changed a random item and changed the vendor price and its changed to 29 items :D THANK YOU!! :D
    in Finding the Difference Comment by Cloud Apr 8, 2011 9:34AM
  • Is there a way to display this new sublist as the default view? instead of having to click onto the list everytime? I can't see anything under customize form. Thanks Cloud
    in Showing quantity of Matrix items on Parent Comment by Cloud Mar 29, 2012 8:26AM
  • I know this is a really old post... but wondering if anyone figured this one out. Trying to make a custom field for the thumbnail to put on forms. or in Custom Tab. Thanks
    in Custom Item Thumbnail Field Possible? Comment by Cloud Jun 29, 2011 10:24AM
  • Hi T.Watz, 1. I'm using the formula <code>case when {transaction.trandate} between to_date('11/01/2017', 'MM/DD/YYYY') and to_date('04/30/2018', 'MM/DD/YYYY') then {transaction.quantity} end</code> It's working but the problem is I'm facing is when an item changes it's pricing it's being duplicated. So for example - Item A…
    in 100 Ways to Use Formula Fields Comment by Cloud May 7, 2018 10:09AM
  • Try "Formula Text", not "Formula Numeric" - since you want the date printed in a particular format, you need the result as text. Hello, Thanks - It worked. I replaced the {today} to {lastmodifieddate} so now it's TO_CHAR({lastmodifieddate},'YYYY-MM-DD HH:MM:SS') However I have no idea what it's showing lol. The date shows…
    in 100 Ways to Use Formula Fields Comment by Cloud Oct 25, 2017 9:14PM
  • Hello, I'm trying to do achieve 3 things - 1. Find sales for the last 6 months. I can do this manually (the below formula isn't working) - case when {trandate} between to_date('04/11/2017', 'MM/DD/YYYY') and to_date('04/05/2018', 'MM/DD/YYYY') then {transaction.amount} end 2. EXT Cost - is Extended Cost - the total amount…
    in 100 Ways to Use Formula Fields Comment by Cloud May 4, 2018 1:24PM
  • I'm running a Customer Saved Search and I want the Last Modified Field to be formatted YYYY-MM-DD HH:MM:SS = 2012-11-14 13:30:00. I tried adding this to the Results tab -> Formula Numeric and used TO_CHAR({today}, 'YYYY-MM-DD') but I keep getting Invalid Expression. I can use this TO_CHAR({today}, 'YYYYMMDD') and that…
    in 100 Ways to Use Formula Fields Comment by Cloud Oct 24, 2017 11:32AM
  • is there a way to run a search to show me all child items which are inactive/display in website is false but the parent item is still active i.e. Display in Website to be true. I've tried using member items display in website is false and parent display item is true using expressions with 'And' but I'm getting our full…
    in 100 Ways to Use Formula Fields Comment by Cloud Jun 22, 2018 4:26PM
  • try CASE WHEN {custrecord_date} IS NULL AND {custrecord_checkbox} = 'F' THEN 'A' WHEN {custrecord_date} IS NULL AND {custrecord_checkbox} = 'T' THEN 'B' WHEN {custrecord_date} IS NOT NULL AND {custrecord_checkbox} = 'F' THEN 'C' WHEN {custrecord_date} IS NOT NULL AND {custrecord_checkbox} = 'T' THEN 'D' END Evan, I am…
    in 100 Ways to Use Formula Fields Comment by Cloud Feb 21, 2012 10:55AM
  • Lol thanks mate :D
    in 100 Ways to Use Formula Fields Comment by Cloud Feb 21, 2012 11:58AM
  • oops I forgot that, added 'AND' into formula.. still brings up 20.00.
    in 100 Ways to Use Formula Fields Comment by Cloud Feb 21, 2012 11:46AM
  • Acranmer, I've added more bits into the formula, but only the 20.00 shows.. it's skipping the first bit. like a bed option is {custitem40} , and the headboard {custitem48} is not checked. The 3rd and the 4th we don't have at the moment but will do in 2-3 days. WHEN {custitem40} IS NOT NULL {custitem_carrier}='Limelight…
    in 100 Ways to Use Formula Fields Comment by Cloud Feb 21, 2012 11:32AM
  • After having wasted many hours doing trial-and-error because of no documentation, here is what I've learned. It needs to be confirmed/clairfied by NetSuite. Constraints & Limitations of Using Formulas in Custom Fields (draft) [LIST=1] [*]The formula can not contain references to OTHER formula fields (this may be true also…
    in 100 Ways to Use Formula Fields Comment by Cloud May 23, 2011 4:54AM
  • yes, I have checked it is null. it's a checkbox. Assuming it is null and not null for checkboxes? I've tried that one line, now shows 0.00
    in 100 Ways to Use Formula Fields Comment by Cloud Feb 21, 2012 12:21PM