Foreign key labels

When you have a foreign key in your table, Flashboard will automatically select a human-readable label to display instead of a raw ID. This makes your data easier to understand and work with.

There is a set of rules to infer the best label from the related table.

Label selection

Flashboard looks for a column in the related table that can serve as a good label. It prioritizes columns in the following order:

1. Title or name: It first looks for columns named name, title, or full_name that are not nullable (i.e., must have a value).

2. Email: If no title or name is found, it searches for an email, email_address, e_mail, or e_mail_address column that is not nullable.

3. Identifiers: If neither of the above is available, it looks for these common identifier columns: sku, product_sku, model_number, code, identifier, catalog_number, barcode, bar_code, or isbn that are not nullable.

If a column matching one of these criteria is found, Flashboard will use it as the label.

Fallback labels

If no single, non-nullable column can be identified using the rules above, Flashboard will create a fallback label. It takes the first available value from the following columns, in order of priority:

1. A title or name column.

2. An email column.

3. An identifier column.

4. The table's primary key.

5. The first column that is non-nullable.

6. The first column in the table.