Forum Discussion
EmberKrumwied
5 years agoQrew Captain
Thank you Mark, that is fabulous. I couldn't find a checkbox with the name you mentioned but there was a checkbox titled "Value Matching - Only include values if they match exactly in both fields". That did the trick!
Now, part 2 of my evil plan ; ):
So we know about the Transfers table but I have a second table, Transfer Steps. This table is linked to the Transfers table to indicate if a Parent Transfer involved multiple steps. At the Parent level I am showing the beginning and ending of a membership interest move, however (due to tax reasons) the ending result might have included intermediary steps to complete.
Example:
Parent Transfer - Partner A transferred 20% interest into Partner D.
Child Transfer - Partner A transferred 20% interest into Partner B; Partner B transferred to Partner C; Partner C transferred to Partner D.
The Transfer table and Transfer Steps table both have/use the same data columns so what would be the best way (if it's even possible) to have a single table that would show, row by row, all the rows from the Transfer table and all the rows from the Transfer Steps table.
Thanks!
------------------------------
QuickBase Admin
------------------------------
Now, part 2 of my evil plan ; ):
So we know about the Transfers table but I have a second table, Transfer Steps. This table is linked to the Transfers table to indicate if a Parent Transfer involved multiple steps. At the Parent level I am showing the beginning and ending of a membership interest move, however (due to tax reasons) the ending result might have included intermediary steps to complete.
Example:
Parent Transfer - Partner A transferred 20% interest into Partner D.
Child Transfer - Partner A transferred 20% interest into Partner B; Partner B transferred to Partner C; Partner C transferred to Partner D.
The Transfer table and Transfer Steps table both have/use the same data columns so what would be the best way (if it's even possible) to have a single table that would show, row by row, all the rows from the Transfer table and all the rows from the Transfer Steps table.
Thanks!
------------------------------
QuickBase Admin
------------------------------
MarkShnier__You
Qrew Legend
5 years agoRe: so what would be the best way (if it's even possible) to have a single table that would show, row by row, all the rows from the Transfer table and all the rows from the Transfer Steps table.
Not possible the show the results of two tables combined into one table. However the embedded report can be any report type. If Transfer Steps are Children of Transfers, then you can look up any fields from Transfers to Transfer Steps and then sort and group the report by Transfers and include in the Group by fields any Transfer fields that you don't want to be repetitive.
You can also make a Rich Text field on Transfer steps to use on the embedded report fo the Group by.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Not possible the show the results of two tables combined into one table. However the embedded report can be any report type. If Transfer Steps are Children of Transfers, then you can look up any fields from Transfers to Transfer Steps and then sort and group the report by Transfers and include in the Group by fields any Transfer fields that you don't want to be repetitive.
You can also make a Rich Text field on Transfer steps to use on the embedded report fo the Group by.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- EmberKrumwied5 years agoQrew CaptainBummer...is there a way then to display the Parent table and embed Child records where they are linked? Perhaps in a collapsed view with a plus sign to expand to show the child records, if any? Right now my screen shows two separate reports and looks a bit confusing to users. If only the Parent record was shown with the option to expand to show Child records, that would consolidate the information being presented on the screen.
------------------------------
QuickBase Admin
------------------------------- MarkShnier__You5 years ago
Qrew Legend
I think your only option is two reports because you don't always have Transfer Steps. You can have a form rule to hide the Transfer steps report if there are not any.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------