Help

Best practices for field/table naming?

Topic Labels: Base design
156 0
cancel
Showing results for 
Search instead for 
Did you mean: 
JBJ
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everybody,

Until know, what I've been doing on my Airtable databases in terms of naming is I use:

- the singular for fields that contain only a single value
VS.
- the plural for both fields that contain multiples values and tables

Ex.: In my 'Invoices' database (see attachments), I use 'Service' in the Line Items table because each line item matches only one particular service, but I use 'Services' in the 'Invoices Receivable' table because there are usually multiple charged services on one invoice.

While battling with Documint in order to automate the generation of PDF invoices, I figured that this discrepancy might be the cause for problems in data retrieval.

=> Do you have best practices to suggest in terms of field/table naming?

I would very much appreciate our help on this one.

0 Replies 0