Forum Discussion

HaroldCristian's avatar
HaroldCristian
Qrew Member
1 month ago

Queries

Good evening Quickbase Community!

I have several numeric formula fields that include queries. Due to the volume of data in the table, the queries are no longer working properly.

The permanent solution is to move all the queries to a pipeline so that calculations are performed when a new record is entered, but right now I need to recover the data we already have.

Until two weeks ago, you could change the field type from numeric formula to plain number, and it would simply display all the data.

Now it won't let me do that. It says the data is too large and to ask for help.

Any ideas?

formula query

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    1 month ago

    You could try making a new field to hold the scalar values and running a saved table to Table copy to copy the value of the formula query into the scalar field.  It is possible that the table to table copy will time out and fail. 

    If it fails, you could have a pipeline which similarly would search for all of the records, which do not already have a scalar value and then in a for each loop it would update the scaler field. The pipeline might take a long time to run, but you could leave it run overnight.  

  • Roy-Wanyoike's avatar
    Roy-Wanyoike
    Qrew Assistant Captain
    1 month ago

    Changing the field type resolves to calculating each row per operation done. How about you create a report which includes the formula fields then add filters to help offload the size of the data maybe by dates fields and export to csv. To my understanding quickbase will render the data in computated values.