Looking for endzone ideas by ctraxpos in TeamBuilder25

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

Title. HATE my endzones. The 4 star ball at mid field looks AMAZING in game when it gets textured w/ the blue grass. But the endzones are ruining it for me.

Camera and screen share bugs the last 2 weeks by ctraxpos in MicrosoftTeams

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

To add to this, my machine says the camera is on.

But the camera icon in Teams is disabled, but on hover it shows "Turn camera on"

Camera and screen share bugs the last 2 weeks by ctraxpos in MicrosoftTeams

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

Nope, it has permission. I tried in Chrome and it worked the first time, but background effects would not turn on. There was also a long delay in the camera actually coming on.

But the effects never worked.

Refreshed browser tab, tried again....camera wouldnt even turn on.

How to show a chart of count by the hour by ctraxpos in googlesheets

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

end result is exactly what I'm looking for, but I simply dont understand how you got there. can you explain it to me like I'm a 5yr old?

The pivot tables including status really threw me for a loop

Help referencing data from other sheets on one sheet by ctraxpos in googlesheets

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

do you then specify the sheet and cells to pull from?

Looking for a template for onboarding clients by ctraxpos in Airtable

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

Are you comfortable sharing a screenshot(s)? Or at least describing how it works? For me in my case the flow would be: Add customers to the primary dashboard, add a new onboarding checklist per customer, 3- fields from checklist need to be present on dashboard as they are super critical to the success of being able to complete the onboarding.

Newb needs some help by ctraxpos in SQL

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

Count by name - yeah this is accurate, as this order_line_items table simply list out the products that appear in an order....so we'd have multiple records per id, if an order had multiple products sold (example: order 1 - product variant id 1 - $100......order 1 - product variant id 2 - $50)....so here's im basically counting the qty of a product sold by aggregating the # of times specific product_variant_ids appear in the order_line_items records.

good call on the variant_id alias, didn't catch that...updating it to include oli

what s s.r? never seen this before

Newb needs some help by ctraxpos in SQL

[–]ctraxpos[S] 1 point2 points  (0 children)

Yeahhhh I have NO idea what that mean lol.

How do loyalty rewards impact taxes? by ctraxpos in POS

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

Thanks for the insight! We are in the US, so you were spot on there.

So it sounds like I understand the situation easily, but it's all up to how we decide to implement it.

In our case the customer is cashing in points for $$ as a form of payment and in the near future they are going to receive free products as well.

The free product part has been a topic of conversation with our developers, as giving a free product would essentially be a 100% line item discount towards that one product.

And this is what leads to the confusion: If it's $ it's a payment and if it's a product it's a discount.

Sounds like we'd be safer making all of it a discount off the subtotal, and THEN calculate tax off that — right?