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
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.
Hi just a follow-up question on combined text summary field, it seems there is a limitation of 50 child records it can summarise? Is that correct?
Also on the sorting of the text in the fields, it's limited to the being only to sort from low to high on the text field that you are combining.. is that correct? ie you can;t use another field in the child record, like a sort value, to be able to sort the combined text.?
Thanks Ian
Also on the sorting of the text in the fields, it's limited to the being only to sort from low to high on the text field that you are combining.. is that correct? ie you can;t use another field in the child record, like a sort value, to be able to sort the combined text.?
Thanks Ian