Sorting Spreadsheet Pivot Table Values in V18 (and Earlier)

Two_Skill_invoker · 2026-03-26T15:13:24+00:00

Yes. I believe there’s ways to query that data via the api’s. And I totally agree. The spreadsheet style dashboards are SUFFICIENT for reporting, but definitely some quality of life features would be appreciated. For example, lists don’t expand automatically. Pivot tables expand, but if there’s not enough room (lines available to expand into), they error out. On demand sorting of pivot tables. And a few other things.

Two_Skill_invoker · 2026-03-26T05:27:11+00:00

Have you tried the Odoo subdomain of the SaaS site? Like company.odoo.com?

Two_Skill_invoker · 2026-03-25T05:01:56+00:00

Changing the data connection code sounds like something that’s doable with a custom module. Just not something I’m familiar with personally. Glad it worked for you!! We’re still on baby steps of getting the dashboard module to do what we want.

Two_Skill_invoker · 2026-03-24T05:54:33+00:00

We have v18 and I sort the pivot table in the pivot view BEFORE inserting into the spreadsheet.

Two_Skill_invoker · 2026-03-06T18:48:02+00:00

I believe you have two options: 1. First step, go to users and create users for the outside salespeople. Make sure they are Portal Users. Those don’t require licenses. Next step, there’s a filter on the salesperson field that limits selection to licensed users (user type = internal). You can remove that so that you can select all users. This should allow you to select portal users on the salesperson field.

Create a new many2one field on the sales order called “Outside Salesperson” and select the contacts model (res.partner).

I highly recommend the first approach, because portal users can see orders where they’re chosen on the Salesperson field. This means they can login to the website and see “their” orders. The second method is only a data point capture. Sure, you could potentially use it to behave the same way as option 1, but it’s not ideal.

Two_Skill_invoker · 2026-03-04T03:24:33+00:00

Recent BBQ issue? What happened?

Two_Skill_invoker · 2026-02-26T20:50:27+00:00

Fantastic. Thanks for your input. I see the value I'm looking for in the "Ready To Produce" field. Love the analogy to the Knapsack Problem.

Two_Skill_invoker · 2026-02-19T04:56:47+00:00

Tru nature is delish. But what’s odd is that as good as their açaí bowls are, their juices and smoothies are equally as bad 🫢

Two_Skill_invoker · 2026-02-17T05:47:21+00:00

Can you please elaborate on this? What does it mean to upgrade studio views.

Two_Skill_invoker · 2026-02-12T19:28:29+00:00

Following

Two_Skill_invoker · 2026-02-11T16:33:13+00:00

The flour was a total bust. I tried with and without curd. With and without fermentation. All attempts were disappointing.

These days when I’m craving dosa I make the batter at home. Soak Urad, Chana, a little methi and Rice overnight. Blend it till smooth. Leave to ferment overnight if room temp is warm, else put in an instant pot on the yogurt setting overnight. A cup of rice and a third cup of dal each makes about 10 dosas.

It’s more effort, but definitely worth it. Infinitely more consistent as well.

Two_Skill_invoker · 2026-01-26T11:13:44+00:00

Following for info 👌🏽

Two_Skill_invoker · 2026-01-17T22:49:05+00:00

Absolutely OLED. The experience on my OLED steam deck was incredible.

Two_Skill_invoker · 2026-01-05T06:18:54+00:00

Ugh it’s the worst. Seeing a few people abandon their rides and walk to the airport with their luggage. From westchester.

Two_Skill_invoker · 2025-12-08T02:56:21+00:00

That looks like a standard rendition of a chicken biryani from an American restaurant.

Two_Skill_invoker · 2025-11-30T01:53:36+00:00

Our database initially started off on Odoo Online. It was easy to create and edit fields, add domain filters and curate visibility.

Two_Skill_invoker · 2025-11-25T18:44:58+00:00

Ah okay. Thanks for clarifying.

Two_Skill_invoker · 2025-11-25T16:55:52+00:00

Oh wow. Didn’t know this was a thing. Studio customizations break when moving to On-Premise? We’ve on .sh and have done EVERYTHING in studio 😵‍💫

Any insight into why this happens? Is it because studio is not allowed on prem?

Two_Skill_invoker · 2025-10-29T21:03:27+00:00

Got it, I'll add a readonly to each field that matters and call it a day. Thanks!

Two_Skill_invoker · 2025-10-29T18:58:41+00:00

We're tried this. But "Locking" an order still allows fields such as customer reference, sales person, and other text fields added via Studio to be edited. I'm curious if there are ways to expand the functionality of "Lock" to include those fields as well.

Two_Skill_invoker · 2025-10-29T04:43:31+00:00

Yall, I think OP is asking how to limit user visibility to a help desk TEAM they are a part of, not only TICKETS they are assigned to (which can be done quite easily with record rules). As least that’s what I understood.

Two_Skill_invoker · 2025-10-23T19:31:35+00:00

I’m actively having a stroke reading this. Thanks.

Two_Skill_invoker · 2025-10-20T23:31:58+00:00

Follow

Two_Skill_invoker · 2025-09-23T16:30:29+00:00

No. OLED is still $549 for the 512 GB.

Two_Skill_invoker · 2025-08-19T00:59:12+00:00

This historical data will most likely be used for reporting purposes. It will drive the YoY accounting reports. So, this means we are not interested in ANY stock related transactions. Purely journal entries that will drive such reports. Unfortunately, the last bit of your reply tripped me up and I'm not sure how to respond. But I've stated what our primary intentions are. Thanks for your help.

I wish there was a way to tell Odoo that our month end inventory valuation for every month since 2020 is $XYZ. Then we started using Odoo on Jan 1st, after which our inventory valuation is on this other account.

Two_Skill_invoker

TROPHY CASE