Add, Change or Delete a Code Table Value

Modified on Sun, 27 Sep at 9:12 AM

Your team needs a new option in a drop-down, or an old one renamed. Every Code Table works the same way, so learn it once here.

Summary

Open Settings › Code Tables and pick the table. Add Record adds a value. Click the arrow at the end of a row to open it, change it and click Update. Order sets where the value sits in the drop-down. Before you rename or delete a value, check Associated Records when you open it. That number tells you how many records use it.

How to do it

  1. Go to Settings › Code Tables and click the table you need, such as Note Categories.
  2. To add a value, click Add Record. Fill in Name, and a Description if it helps.
  3. Set Order to choose where it appears in the drop-down. Lower numbers show first.
  4. Click Add.
  5. To change a value, click the arrow at the end of its row, make your change, and click Update.

That's a value added. Read on before you rename or delete one.


Tables with extra settings

Most tables only ask for a name, a description and an order. Some have extra settings that change how NextCrew behaves. Each has its own guide:


Rename with care

Renaming a value changes it everywhere, including on records that already use it. That's usually what you want when you fix a typo. It's not what you want if the meaning changes. For a new meaning, add a new value instead.


Delete with care

Open the value and look at Associated Records. If it's more than 0, records still use it. Then choose Delete in the panel, or in the row menu (three dots).

⚠️ Watch out

Only delete values that nothing uses. Reports and saved views that filter on a value stop matching once it's gone. If you're not sure, leave it and move it to the bottom with Order.

Don't delete values created by System. Other parts of NextCrew may rely on them. Values with a globe icon are locked, so you can't rename or delete them.


If something's not right

What you seeCheck this firstWho fixes it
A new value doesn't show in the drop-downRefresh the page you're working on. Then check you added it to the right table.You
The drop-down is in the wrong orderThe Order number on each value.Your NextCrew admin
You can't see Code Tables in SettingsYour role. Code Tables are for admins.Your NextCrew admin
Delete doesn't remove the valueContact NextCrew support with the table and value name.NextCrew support

Other ways people ask this

  • How do I add an option to a drop-down?
  • How do I change the order of a list?
  • How do I remove a status we don't use?
  • Where do I edit the pick lists?
  • Can I rename a category?

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article