Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

How to create editable table with Studio (odoo.sh v13)

Subscribe

Get notified when there's activity on this post

This question has been flagged
list
7 Replies
8653 Views
Avatar
FD Displays

I'm trying to create a new table (or list) in Sales Quote List View, with some columns that should get some text entries as well as some float entries.

These entries are not related to any other fields and need to be editable.

How can i do this? I thought it was goind to be easy, but i'm a bit lost.

Can anyone help me out?

0
Avatar
Discard
Avatar
Paresh Wagh
Best Answer

Hi:

I'm assuming you want to add new fields to the sale.order list view that is displayed when you click on the Sales menu.

To do this:

  1. Go to the list view and open Studio

  2. In the New Fields section on the left, you will see various data types. Click on the appropriate data type and drag it to the column where you want to display the new field. Studio will now prompt you for the properties of the field in the left pane. Specify the Label and any other properties you want to set.

  3. Then go back into the Add tab and add all the fields that you need and set their properties.

  4. Go to the View tab and select one of the two values in the Editable field.

  5. Then click Save to save your changes.

  6. You should now be able to edit the fields inline in the List view.

1
Avatar
Discard
FD Displays
Author

Hi! Thanks for the help, but i'd actually like to add a new tab with a new table in the sale order.

Paresh Wagh

You will to add a new model, add a new One2many field to the sale.order model that references the new model, and add a new tab with the field in it on the Quotation/Sales Order form.

FD Displays
Author

Sorry, i just saw your comment. I don't understand how i can acomplish that. By new model, you mean a new app?

FD Displays
Author

I made a new post that can better explain what i'm trying to accomplish.

https://www.odoo.com/pt_BR/forum/ajuda-1/question/add-spreadsheet-to-quote-odoo-sh-v13-165114

Avatar
Marco
Best Answer

On that case, I think you may need to create new fields, which you're going to edit. These are going to be related the each sales quotes. Maybe you want to have values that are not related to any other field, but they need to be related to something, in this case, with an individual sales quote. 

Try adding text fields (or whatever you need) to the sales quote view. Important, make them editable (do not check the "read only"). Then, on the list view add those columns. 

1
Avatar
Discard
FD Displays
Author

Oh, that's a begining :)

But how can i create the table itself? An empty table.

Marco

Hmmm no, I think creating an empty table isn't possible.

FD Displays
Author

Oh well... That's disapointing. Thanks Marco.

Marco

Yeah, It isn't as custumizable as we'd like sometimes.

You're welcome, please vote up and mark as asnwered, thanks.

Avatar
Marco
Best Answer

It depends of what variables are you willing to show. But mostly, I think they should be related to a field.

0
Avatar
Discard
FD Displays
Author

I don't want to create any relations. I just need to insert some text values, like Place, and other fieds with float values, like other costs.

These values should be inserted manually and have no relation to other fields.

Isn't this possible?

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
how to remove the duplicate number of elements in list? Solved
list
Avatar
Avatar
Avatar
Avatar
Avatar
5
Dec 23
19758
How to save a list of float / string on .py file?
list
Avatar
Avatar
1
Mar 17
5969
Saved Shopping Carts for Vendors, for large POs? Solved
list purchase_order
Avatar
Avatar
1
Jan 22
2714
how i can update list in Directory odoo 12 Solved
list dictionary
Avatar
Avatar
Avatar
2
Aug 19
5273
List of tasks that were finished in the last month Solved
project list
Avatar
Avatar
3
Jan 19
2782
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now