Summary Field of a Formula
I'm a longtime QB user and seem to run up against this limitation often. I was wondering if anyone has found a good workaround. My data consists of three fields, "Date", "Division", and "Amount". I...
Forum Discussion
Thanks for the info, I wouldn't have thought of using a Report Link to allow the system to relate the record to itself. Otherwise Actions only allows me to add a record, which I don't want.
I'm still running into a problem. I created the Report Link to tie the existing key to the same application, table, and field. Even tho this is a Quickbase Action, I actually receive a "Quickbase Webhook Error" email from QB saying:
400 Error: <?xml version="1.0" ?> <qdbapi> <action>API_EditRelatedRecords</action> <errcode>1</errcode> <errtext>Unknown error</errtext> <errdetail>You cannot include the record ID if it is not the key field.</errdetail> <num_recs_updated>0</num_recs_updated> <num_recs_unchanged>0</num_recs_unchanged> </qdbapi>
My key field is *not* [Record ID#]. I made the report link using my key field, which is a unique, imported text field. My link has nothing to do with the [Record ID#]. I wonder if something is hard-coded to look for the [Record ID#] even if it's not the key?
It seems your test used the [Record ID#] and it worked. Any thoughts?
I'm still running into a problem. I created the Report Link to tie the existing key to the same application, table, and field. Even tho this is a Quickbase Action, I actually receive a "Quickbase Webhook Error" email from QB saying:
400 Error: <?xml version="1.0" ?> <qdbapi> <action>API_EditRelatedRecords</action> <errcode>1</errcode> <errtext>Unknown error</errtext> <errdetail>You cannot include the record ID if it is not the key field.</errdetail> <num_recs_updated>0</num_recs_updated> <num_recs_unchanged>0</num_recs_unchanged> </qdbapi>
My key field is *not* [Record ID#]. I made the report link using my key field, which is a unique, imported text field. My link has nothing to do with the [Record ID#]. I wonder if something is hard-coded to look for the [Record ID#] even if it's not the key?
It seems your test used the [Record ID#] and it worked. Any thoughts?