Table key from table-to-table import error
We create an equipment ID field in Table A. The equipment ID is a formula field that creates a unique number: List("",[ToText: Job ID],[ToText: Sort Order],[ToText: Record ID + 100M],"3") ...
Forum Discussion
Yes this is totally expected.
Here are some notes to myself
A caveat is that QuickBase can only handle numbers up to 13 digits entered as numbers without rounding. If your digits will be larger than 13, you should use Text-type fields for data entry instead
So you need to have a formula which does not need any intermediate calculations or results which is more than a 13 digit number.
Here are some notes to myself
A caveat is that QuickBase can only handle numbers up to 13 digits entered as numbers without rounding. If your digits will be larger than 13, you should use Text-type fields for data entry instead
So you need to have a formula which does not need any intermediate calculations or results which is more than a 13 digit number.