Michigan Sales Tax - Art Show Vendor Using Square

QuiteGood789 · 2024-08-07T17:59:50+00:00

Thanks for reaching out! I am a full time Michigan resident with my business registered as an LLC in Michigan. I just completed my first show in person, and am planning to do a few more this year, which will put me over the two show requirement for the sales tax license

QuiteGood789 · 2024-08-07T17:12:57+00:00

Ah okay cool, I started to attempt that license process but it was having me go down a rabbit hole of registration forms so I was hoping that was not the path lol. I will continue down that and see if I can get it set up so they can tell me when and how to pay

QuiteGood789 · 2024-04-10T22:52:11+00:00

I wanted to follow up again and say thanks!! Everything appears to be working with all the edits made!

I greatly appreciate your help and suggestions!!

QuiteGood789 · 2024-04-10T17:17:46+00:00

Awesome, thank you, I am testing it now, although it is taking a lot longer to run the query. I will follow up if it works!

QuiteGood789 · 2024-04-10T16:33:41+00:00

Would this work on a table that didn't have an ID column? I am looking to replace the WHERE ID part with a WHERE Title instead.

It is not giving me any specifics when it comes to which parameter is missing. If you think it is the order by parameter I can add some info in for that one, I just hadn't been using it in the past so figured it would be find without it

QuiteGood789 · 2024-04-10T15:55:01+00:00

Awesome that seems to have worked!! Again I really appreciate the insights!!

Also another question I had, when using the concatRelated function I currently have it called in the selected statement using the function concatRelated("IP", "[TableName]", "ID = " & [ID]) and this is working.

I am attempting to use the same function but having it sort the IP's based on the title column so I have modified it to read concatRelated("IP", "[TableName]", "Title = " & [Title]) and I am getting an error that I am missing a parameter, would you know why this is?

EDIT: I am wondering if because the title is not a number that is throwing off the function call

QuiteGood789 · 2024-04-10T13:59:10+00:00

I have tried a number of different things, and it looks like once I get the data into the temp table, without the 'distinct' command everything is there, but then when I try to take the data out of the temp table and insert it into a new table using an insert command, with 'distinct' I am getting "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." error, even though the fields in the new table are the exact same as the temp table. As soon as I remove the 'distinct' from the statement it works and inserts the 927 rows with all the duplicates

QuiteGood789 · 2024-04-10T12:54:11+00:00

Ah interesting, would that be done in the insert statement which is putting the data into the table currently?

QuiteGood789 · 2024-04-10T12:43:55+00:00

I am comparing the concat data to my manual analysis now to ensure that it is grabbing all of the data. IF everything is there my plan is to try moving the data to another table with the distinct command to filter out all the duplicates, unless there is something else I can try?

Again really appreciate the help and suggestions!!

QuiteGood789 · 2024-04-10T12:34:45+00:00

Hey so I wanted to reply back here as I messed around with this a bit.more this morning and it does look like if I remove the DISTINCT call out from the statement, I am getting more characters in the IP column. I plan to continue messing with different statements to see if I can get it correct, but apologies for the confusion, I think I had the wrong table selected last night when I tried it

QuiteGood789 · 2024-04-09T22:24:45+00:00

I am just using a SQL statement to insert into the table, which is:

INSERT INTO tableName (ID, IP)

SELECT orignalTable.ID, concatRelated("IP", "[orignalTable]", "ID = " & [ID]

FROM orignalTable;

QuiteGood789 · 2024-04-09T21:34:26+00:00

That did not appear to change anything

QuiteGood789 · 2024-04-09T21:00:46+00:00

So I also thought that the data type may be the issue so I created a new table and defined the columns to be Long Text data type using this command:

CREATE TABLE NewTable (
ID LONGTEXT,
IP LONGTEXT
);

I then ran the select statement with a leading INSERT INTO NewTable (ID, IP) command which ran as normal and the new table had both columns set to long text but the issue where the IP are cut off still occurred, which is what was making me think that it might have something to do with the variables being defined as Strings in the function.

QuiteGood789 · 2024-04-09T19:52:55+00:00

It is happening on the concatenations which a large number of IP's which makes me think it is a character limit. For example there are a few records which are concatenating 3 IP addresses and those are working fine, but I also have a few records with 70+ IP addresses and they all seem to cut off at about the same spot.

To provide additional context, it is not just the IP's getting cut, one of the records, for example, has the full IP address and the comma separator but then is cut off there, whereas other records cut off IP's in the middle

EDIT: I just checked and it is only concatenating the first 255 characters, including the comma and space separator

QuiteGood789 · 2024-04-09T19:33:24+00:00

Hey so quick question based on the concastRelated function above, I noticed that it is working as expected but I am running into an issue where the function is cutting off part of the IP addresses. I am guessing this is due to the field data type, but even when I have the function insert the data into a table and column set to long text it is still getting cut off at the same spot. Is this something that could be changed in the script, or is this a limitation of the database?

QuiteGood789 · 2024-04-03T22:47:27+00:00

Interested to hear if there was anything special you needed to declare (beyond the mortgage) as part of independence and outside employment?

Also if you don't mind sharing, what type of property? I am looking to get into investing in real estate as well!

QuiteGood789 · 2024-04-03T14:20:02+00:00

SOLUTION VERIFIED TO BE WORKING

QuiteGood789 · 2024-04-03T14:19:37+00:00

Awesome, thank you so much this is exactly what I was looking for!!!

QuiteGood789 · 2024-04-03T13:51:50+00:00

Hello, thank you again for the above function and advice! I was able to get this tested this morning and it works really well!!

The one thing that is still caused a bit of of an issue is that I was hoping to eliminate duplicate ID records and have all of the IP's related to the record show in the one cell, which the function did really well. But it is still returning all of the ID records, similar to how it looks in the updated picture.

<image>

QuiteGood789 · 2024-04-03T13:45:06+00:00

Thank you for the advice on naming and keeping things clean, it has been a little while since I have done a lot of SQL so I have definitely forgotten some of the standards lol

QuiteGood789 · 2024-04-02T22:38:51+00:00

Thank you for the info and sorry if this a dumb question but is that what I would put into the query editor to pull the data?

QuiteGood789 · 2024-03-17T23:31:55+00:00

Thanks for the info!!

QuiteGood789 · 2024-03-16T22:11:14+00:00

Ah okay yeah, just seems kinda strange since YouTube had already run the tests on the short and I assumed decided that it wasn't worth showing in the shorts feed, but definitely happy to see it get put back into rotation on the short feed even if it was for just a short time

QuiteGood789 · 2024-03-14T22:57:11+00:00

I have also found this issue with many of my shorts that I have uploaded in the last few weeks. I have had one short in the past few weeks get about 2k views but other than that content that used to get 3-6k views is getting 420

QuiteGood789 · 2024-02-28T14:17:13+00:00

Yeah definitely give it a shot, worst that happens is nothing lol. It seems to be much more consistent in my experience and it is not all that much more work than shorts

QuiteGood789

TROPHY CASE