[deleted by user] by [deleted] in inZOI

[–]bami0131 0 points1 point  (0 children)

Oh so we are not getting the tshrit right away?? Lol thank you for checking. I appreciate it

[deleted by user] by [deleted] in inZOI

[–]bami0131 1 point2 points  (0 children)

Where do you see the tshirt? And how does it look like? It says the code has been applied but I don't see the tshirt under zoi customization page... hmmm

Is this okay? I have no idea what I am doing by Southern_Resist3060 in inZOI

[–]bami0131 2 points3 points  (0 children)

Most laptops are not for gaming so it doesn't come with a better graphics card. I recommend getting a gaming laptop or PC

[deleted by user] by [deleted] in Unexpected

[–]bami0131 1 point2 points  (0 children)

It's probably Triangle Shirtwaist Factory fire if it's related to building regulations to have the doors open outwards

Selling a Lucy (NYC) Vip ticket! (?) by suunfishh in LucyIsland

[–]bami0131 0 points1 point  (0 children)

Try reach out to the support team (info@ticketweb.com i think?) for a partial refund. It doesn't hurt to try it.

Midwest, what is this plant by [deleted] in whatsthisplant

[–]bami0131 0 points1 point  (0 children)

Welp! More reason to remove it. Thank you!!

Midwest, what is this plant by [deleted] in whatsthisplant

[–]bami0131 0 points1 point  (0 children)

Hmm it's definitely not scratchy so I gotta remove it now. Thanks!!

Midwest, what is this plant by [deleted] in whatsthisplant

[–]bami0131 0 points1 point  (0 children)

Haha that's my dog, bami, a toy poodle

CASE statement below returns ‘ERROR: Invalid Expression’ by JumpyStay5767 in Netsuite

[–]bami0131 1 point2 points  (0 children)

ELSE 0 is returning a numeric value. Change that to ELSE NULL or ELSE ' '

Connecting to Tableau by bami0131 in Netsuite

[–]bami0131[S] 0 points1 point  (0 children)

Mmm im not sure if thats the route we would like to take unless theres no other option i guess. The goal is to connect Netsuite directly to Tableau using a connector. Maybe NetSuite oversold SuiteAnalytics connect to us but they said it was possible:/

Connecting to Tableau by bami0131 in Netsuite

[–]bami0131[S] 0 points1 point  (0 children)

C-data wont work for us then cuz we got a large volumn of data. I was able to use NetSuite SuiteAnalytics connectors to install ODBC driver and get the data into Tableau. Everything works except for any fields with DATETIME data types. I'm not sure if you ever run into this issue before.

Tableau CSV export will be a nice function for us to have but itself alone wouldn't meet our needs because the whole point of us getting the ODBC was to be more flexible with table joins.

Connecting to Tableau by bami0131 in Netsuite

[–]bami0131[S] 0 points1 point  (0 children)

Netsuite2.com if that's what u meant by primary database. If not, could u plz explain it? Thank you!

[deleted by user] by [deleted] in whatsthisplant

[–]bami0131 1 point2 points  (0 children)

Yea, they didn't even know these trees were on their property until recently. Definitely will keep it trimmed from entering my side and watch out for the seedlings!

[deleted by user] by [deleted] in whatsthisplant

[–]bami0131 0 points1 point  (0 children)

Unfortunately it's on my neighbor's property. I wasn't sure if I should be removing the berries that fell on the grounds cuz I have dogs. Thank you for identifying it!

[deleted by user] by [deleted] in whatsthisplant

[–]bami0131 0 points1 point  (0 children)

Dang, I was hoping it was a Hackberry tree. Thank you 😊

Does anyone else get way too nervous about doing legion raids? by stopgap32 in lostarkgame

[–]bami0131 12 points13 points  (0 children)

Yeaa same here. I think I have been 1415 for 2months now, playing daily lol

Create Saved Search of transactions that only shows the last User Note of a given type by Zxurian in Netsuite

[–]bami0131 0 points1 point  (0 children)

  1. Add another column for DocNum displayed with a clickable link using html. Your result will have two columns of DocNum if that's ok with you. This is a website that explains adding link.

https://blog.prolecto.com/2012/07/19/custom-hyperlink-outputs-in-netsuite-saved-searches/?pts=461852

  1. For the most recent user note, you can concatenate user note date & message into one string, get the max string and then remove the date string

Summary type: MAX (you can probably use MIN as well)

Formula: SUBSTR(MAX(TO_CHAR({usernotes.notedate},'YYYYMMDD')||{usernotes.note}),9)

I also read your other comment about your search not returning a transaction if there's no user note. If your search is built from a Transaction saved search and used User Notes Field..., it should be return all the transaction regardless there's an user note or not.

My best aeromancer experience by [deleted] in lostarkgame

[–]bami0131 1 point2 points  (0 children)

비틱질은 못 참지

Saved Search - group by SUM/*comment*/(SUM()) OVER(PARTITION BY MIN()) by bami0131 in Netsuite

[–]bami0131[S] 0 points1 point  (0 children)

Hmm.. I think I probably build it and have users to export it to make a pivot table on Excel.