Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 17, 2024 06:55 PM - edited Feb 17, 2024 06:57 PM
I usually use linked record for choice option instead of single select, just in case of use with other tables. As my records keep growing, I am worried about the record limit.
Does number of choice in single select also count as record limit per table?
Feb 17, 2024 08:28 PM - edited Feb 17, 2024 08:28 PM
Nope, the number of choices in a single select does not count towards the record limit per table / base
Feb 18, 2024 01:33 PM
For me, the choice between whether to use Single Select or Linked Records (in another table) is largely pre-determined by whether the information in the field has related information that belongs in its own table (whether you bring that data in as Lookup fields or leave them in the linked table).
Examples of data I would change to a single select field (if you had been setting these up in their own tables for some reason)
Examples of data I would keep in a linked table:
If you try to convert the second type of information to a Select field, you run the risk of having to, for example, re-enter the same email address each time you choose a particular Client from a Select field... this leads to loss of data integrity pretty quickly when you have many instances of that Client in your base.