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.
