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

Supported by

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