Report Link Field, displaying different field
I think this is a known but haven't been able to find anything online yet. We have a Report Link field (not in a relationship) that displays records from another table. In this example the Report L...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendDo you want to get summary totals the only way to do that at this time is to create a relationship and do a summary field. There was talk at EMPOWER about improvements to the formula language which will allow us to do a query right in formula field but that does not yet exist.
The alternative is to embed a summary report on your form which will show just a summary count on a one line summary report. You may need to use a dummy field to summarize on so all records summarized onto one line of the report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The alternative is to embed a summary report on your form which will show just a summary count on a one line summary report. You may need to use a dummy field to summarize on so all records summarized onto one line of the report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I guess I should mention the error I get when using a formula as a reference when trying to create a summary...
We are sorry -- at this time, you cannot create a summary field using a relationship where the reference field is this type of formula field. Please visit our limits page (https://hardermech.quickbase.com/db/main?act=dohelp&page=quickbase_limits) or contact Care for more information.
I'm going to try a snapshot and then a webhook to a text field.
------------------------------
Jim Harrison
------------------------------
We are sorry -- at this time, you cannot create a summary field using a relationship where the reference field is this type of formula field. Please visit our limits page (https://hardermech.quickbase.com/db/main?act=dohelp&page=quickbase_limits) or contact Care for more information.
I'm going to try a snapshot and then a webhook to a text field.
------------------------------
Jim Harrison
------------------------------
- Ahh, the famous 'you cannot create a summary field at this time'. I can do a brief explanation, but lucky for you Mark, who is also replying on this thread taught me what I am about to explain, so he can expand if needed.
When a formula field is your related field, you will get that error. The solution is to make another field that is your formula field (copy paste the exact formula you are using). Then change your current related formula field to a manual entry field (I usually call mine - Related Field Formula, and Related Field Manual).
Utilize a combination of dynamic form rules, automations, or table to table imports to constantly be copying your formula field to your manual field.
Now that your manual field is the actual related field, you can use it to make summary fields.
------------------------------
Mike Tamoush
------------------------------- MarkShnier__YouMike
This part of your response is not quite correct.
When a formula field is your related field, you will get that error.
You are certainly allowed to have formula fields as reference fields on the right side of a relationship. However if that formula field directly or indirectly uses a look up field then it becomes invalid as a reference field for the purpose of making summary fields. There is a link that comes up when that error appears which explains which field types are not allowed as a reference field, But the typical problem is that the formula field uses a lookup field as part of its formula.
As you stated, the typical work around if it is necessary to make that relationship is to instead have a scalar data entry field as the Related field and have an automated process copy the formula field into the scalar data entry field. This can be done with automations, or form rules, and if you need an extra safety net you can put in a nightly saved a table to table copy to copy the formula field into the scalar data entry field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thanks for the clarification! I did think it was all formula fields, not just ones that directly or indirectly reference a lookup field.
------------------------------
Mike Tamoush
------------------------------
