Table key from table-to-table import error

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.

This makes sense. 

The equipment ID field in Table A was a text field - which is why the number displayed correctly. 

However, the equipment ID field in Table B must be a numeric field because we use the equipment ID in a summary field with a numeric function ("minimum").

We create variations of this summary field to bring multiple records from Table B into a single record in Table C. 

For example: 

Summary field 1: minimum equipment record ID

Summary field 2: minimum equipment record ID that is greater than summary field 1

Summary field 3: minimum equipment record ID that is greater than summary field 2

Summary field 4: minimum equipment record ID that is greater than summary field 3

etc. up to 100 . . . 

The summary field becomes the reference field in 100 relationships between Table B and Table C. 

This allows us to bring data from up to 100 records in Table B into a single record in Table C. Data must be in a single record in Table C so it can be exported to a digital form (for use in the field). 

Is there another way to bring data from many records into a single record? Or a function we could use on a text-type field to achieve the same result?


13 digits is unfortunately not enough digits for the information we need to track. What do you mean by "without rounding"? Does that allow for decimal places?

There is a new feature called combined text summary field which will summarize text fields.

Give it a try. Once you have it summarized up to the Parent, convert it to text with

ToText([my Combined Text Summary field])

Thanks your help.. Andrea is my colleague

We don't have decimals in our numbers.. so it seems like we can use up to 15 digits as it was working ok up to then. It seems anything larger Quick Base (like Excel) doesn't know what to with it. Would that be correct?

My long time understanding is that Quick Base can handle up to 13 digits accurately.  My suggestion is to convert to use text numbers as they will always be correct.  The Combined text summary fields will solve your roll up issues.  That is a new feature on the last few months.
 

ok no worries

I had a look go at the new feature and it does what we need to .. so thanks for the suggestion