Exceeding formula-URL URL character length
I have an application that calculates quarterly financial values for each contract record in a Contracts table. Each quarterly financial value is stored in a hard-coded field in the contract record (like "2020 Q1 Cash Out").
The goal is to generate chart and tabular reports on this quarterly financial data. To do this, data stored in fields had to be mapped into records in a scratchpad table the reports are based on, one quarterly field to each scratchpad record.
I coded a formula URL button on the contract record that clears the scratchpad table, adds a new record to the scratchpad table, and copies values from the appropriate contract quarterly fields into corresponding fields in the scratchpad record. The code and the reports work great, with one exception.
Because of the number of quarterly fields, it appears I exceeded the maximum URL length, because I'm now getting an error 404, "page unrecognized" error. When I remove the last field from the code, it works fine with no errors.
A possible workaround is to use quarterly data for perhaps 3 years and then annual data further out to limit the number of fields and therefore the URL length, but i was wondering if there's a better way. Any ideas how to resolve this?
For example, can this be split into multiple URLs in one formula-URL field? Or can multiple formula-URL fields be concatenated in some way, where the end of one formula-URL field triggers execution of another? Or should I be using an automation and if so, how?
Thank you.
------------------------------
Paul Streit
------------------------------
The goal is to generate chart and tabular reports on this quarterly financial data. To do this, data stored in fields had to be mapped into records in a scratchpad table the reports are based on, one quarterly field to each scratchpad record.
I coded a formula URL button on the contract record that clears the scratchpad table, adds a new record to the scratchpad table, and copies values from the appropriate contract quarterly fields into corresponding fields in the scratchpad record. The code and the reports work great, with one exception.
Because of the number of quarterly fields, it appears I exceeded the maximum URL length, because I'm now getting an error 404, "page unrecognized" error. When I remove the last field from the code, it works fine with no errors.
A possible workaround is to use quarterly data for perhaps 3 years and then annual data further out to limit the number of fields and therefore the URL length, but i was wondering if there's a better way. Any ideas how to resolve this?
For example, can this be split into multiple URLs in one formula-URL field? Or can multiple formula-URL fields be concatenated in some way, where the end of one formula-URL field triggers execution of another? Or should I be using an automation and if so, how?
Thank you.
------------------------------
Paul Streit
------------------------------
