Is there an API to change a field type from Numeric to Formula Numeric and then back again to Numeric?
I have a situation where I have a Connected Sync table with 70,000 records where a single field needs to be updated with the value in another field.
Normally I would use API_RunImport to Merge the records from the table into itself and map one field into the other. In my experience that would run in a second or two and would be 1 API call, so very quick to set up and quick to run.
But being a Connected table, alas, Quick Base will not let me use API_RunImport even though I am not creating any new records.
I have a script that can update records, but it runs too slowly to be user friendly as even at say a rate of 4 per second, that would take 5 hours for the script to run. Also the script may blow up on that many records, and It may cause the account limits to be triggered for API calls per day.
I was wondering if there is an API call which would allow me to change the field from a numeric field to a formula numeric field, apply a formula and then another API call to change the field back to a numeric field.
I did find in API_SetFieldProperties that there is a parameter to write a formula into a formula field type. It works. But I can't find an API which would allow me to change the field type as what I want to do is to change the field type to be a formula numeric with the formula and then change it back to a numeric field type, thus allowing a mass update.
The reason for needing to go though these hoops is that I need a field which will be used in the reference field fo a relationship and I can't make a summary field on the relationships where the reference field uses a lookup.
Normally I would use API_RunImport to Merge the records from the table into itself and map one field into the other. In my experience that would run in a second or two and would be 1 API call, so very quick to set up and quick to run.
But being a Connected table, alas, Quick Base will not let me use API_RunImport even though I am not creating any new records.
I have a script that can update records, but it runs too slowly to be user friendly as even at say a rate of 4 per second, that would take 5 hours for the script to run. Also the script may blow up on that many records, and It may cause the account limits to be triggered for API calls per day.
I was wondering if there is an API call which would allow me to change the field from a numeric field to a formula numeric field, apply a formula and then another API call to change the field back to a numeric field.
I did find in API_SetFieldProperties that there is a parameter to write a formula into a formula field type. It works. But I can't find an API which would allow me to change the field type as what I want to do is to change the field type to be a formula numeric with the formula and then change it back to a numeric field type, thus allowing a mass update.
The reason for needing to go though these hoops is that I need a field which will be used in the reference field fo a relationship and I can't make a summary field on the relationships where the reference field uses a lookup.