Skip to main content

Use sequences for default values of fields when creating a new record

Project description

Alpha License: AGPL-3 OCA/server-tools Translate me on Weblate Try me on Runboat

This module extends the use of sequences. It will allow you to use them in any text field.

If configured correctly, new records will have a default incremental value in the field of your choice.

Table of contents

Configuration

To configure this module, you need to:

  1. Enable developer mode.

  2. Go to the form view of the model to which you want to add the new sequential default value.

  3. Hover over the field to which you want to add the sequential default value. A tooltip with more info will appear.

  4. Make sure the tooltip says Type: char. Only those fields will work.

  5. Take note of the Object and Field.

  6. Go to Settings > Technical > Sequences & Identifiers > Sequences.

  7. Create one sequence with code named after this pattern: base_sequence_default.{object}.fields.{field}. E.g.: base_sequence_default.res.partner.fields.name to add a default sequenced name for new partners. Do not use {} when adding the model and field name to the pattern.

    Setting the sequence code properly

  8. Configure the sequence at will.

    Configuring a sequence to have date range sub-sequences

Usage

To use this module, it is necessary to:

  1. Follow the configuration instructions.

  2. Create a record of the model you configured.

  3. Leave empty the fields where you configured a sequence. If they are required fields, set value to “-” to trigger the automatic sequence on creation.

  4. Check that the field defined in the sequence is set to the next value in the sequence.

    The partner reference was auto-incremented as configured

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

  • Moduon

Contributors

Maintainers

This module is maintained by the OCA.

Odoo Community Association

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

Current maintainers:

Shide yajo rafaelbn

This module is part of the OCA/server-tools project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

File details

Details for the file odoo_addon_base_sequence_default-16.0.1.0.2.6-py3-none-any.whl.

File metadata

File hashes

Hashes for odoo_addon_base_sequence_default-16.0.1.0.2.6-py3-none-any.whl
Algorithm Hash digest
SHA256 0d5a6d5461c277079c5c1de56578f97d7f15630ad590dbbc47bdee2d3b154045
MD5 40a985f0963f07b013974fb2a9c4e4fa
BLAKE2b-256 2b7223db0bbe5e02b3c07b324c71a10ed33ab394547a70d0bf934ec06127f267

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page