Admin Garbage Help

Thank you so very much for kindly offering your help with this. It humbles me that you were willing to offer up your time-something that’s in short supply for all of us- to help me with my computer problems. Yes, I do feel like your grandma.

Right now, this is what my system looks like:

I have a google form that collects information from clients. You can look at it here. It collects basic info, tattoo details, and general availability. This produces a general spreadsheet that I then sift through at the end of every month to book appointments for the following month. The general spreadsheet does not include any reference pictures so I get these in separate emails.

I make a separate spreadsheet with my available dates for the coming month and fill in the slots with names extracted from the general form respondents. After this, I send each one of these people a standard email that’s slightly altered with the date and the amount of time the tattoo will take. I do this manually and copy paste the emails addresses from the spreadsheet into gmail, and then copy paste the standard text in.

Then I wait for them to answer. If they confirm, I colour their row green. Otherwise I go back, delete their name, and try filling the spot with another name from the general spreadsheet.

Following this, I manually fill in my calendar with the slots. And then we bounce a few ideas back and forth via email once I’ve sketched something for them.

It’s not that bad for one person, but when you’ve gotta do over 40 per month, it’s kinda tedious…

So, what do you think I can do to streamline this?

Ideally (yes, I know this probably can’t happen) someone would fill in the form, and their info would show up in some kinda calendar and then I would check their names to select them for the spot. Then the system would send out an automated email that notifies them of their allotted time… Then if they confirm, it would turn that box green automatically in the calendar (or something). I actually don’t know… I’m just tired of the way I’m doing it and it takes ages… I know maybe this a bit unspecific, but maybe one of you has an easy solution that would cut my admin time down. When I’ve gotta book appointments, pay bills, sketch, do social media, and tattoo, it can be really time consuming…

Any ideas are welcome at pokeeeeeeeoh@gmail.com (yes, I’ll answer personally, it won’t be a douchy robot). If you’ve got a real solution that takes programming time (and that isn’t just an app suggestion, although that’s also so very welcome if it exists), then I can compensate you in tattoo time for an equivalent value.

Thanks so very much!!!!!!! You’re a champ!

The shit you wanna know

Good day! Welcome to my website!

FAQ

Q: How do I book with you?

Go here

Q: Can I use your design and get someone else to tattoo them on me?

A: No. This is my work, and I need to make money off it. I also design a lot of stuff specifically for each customer, and it’s not fair to them. I do simple line drawings anyway- I’m sure you can just do your own or get someone near you to draw something unique. It’s more fun and then I won’t have a fit!

Q: How much does it cost?

A: 1000sek/hour-ish, which is a standard in Sweden. My tattoos never cost less than 1000sek and rarely more than 3500sek. This includes rent, supplies, and tax, which is about 65% of what you give me. This also includes the time I spend drawing and communicating. Keep in mind that a tattoo is an investment that lasts for a long long time. If you’re willing to buy a pair of shoes that will last you a few months for 1000sek, then you should be willing to pay for a decent tattoo that will last you til you be dead. I know it can be a lot of money for some people, but I really can’t afford to charge less unfortunately. Sorry!

Q: Are you going to visit ______ soon?

A: I always announce if I’m going to travel somewhere! If you follow me, you’ll know, I promise, cause I won’t shut up about it!

Q: What needles do you use?

A: It always depends on what I’m working on. You wouldn’t use a fat sharpie to draw a delicate flower. You get the point… I can’t really offer advice on hand poking because I’m self-taught and I don’t feel comfortable sharing something that’s so personal/might be wrong. My whole leg is covered in absolute garbage that I tattooed on myself… That’s how I learned. You have to do the same. Besides, you can’t really explain how to do it in words.

Q: Can I book an appointment with you X months down the line?

A: I book at the end of every month for the following month only. I like to stay spontaneous and I have no clue what I’ll be doing so far into the future. I’m also doing a bunch of other shit, and I don’t know what my schedule will be like with those things and I don’t want to make promises I can’t keep.

Q: You did this tattoo on someone. Can you do it on me too?

A: Probably not. I generally only do tattoos once. Some of them I do again and again, but very few. Otherwise my job gets boring af.

Q: Do you speak Swedish?

A: I understand that gobledygook but I won’t speak it because I’m shy and a coward.<<
p>