How to clean up too many relationships?
How to clean up too many relationships. I worked on an app ~ HIT. It's a hardware app for the hospital. So it is an inventory of hardware and software assigned to employees. I just cleaned up a ...
Forum Discussion
Good morning Bob,
If the reference field is not scalar (ie. a formula or a lookup field from another table), then you are not going to be able to summarize that tables data if you change the relationship.
If you have a way to make it into a scalar field, then cleaning up the relationships is just time consuming. Then open both relationships and you can reassign each of the lookup fields and summary fields from one of the relationships. In the pictures that you showed it is unclear what fields are tied to which relationship. It seems like Related Hardware is an auto-generated scalar field inside of Assignments and the Hardware - Asset Tag was added at another point.
I don't think that QuickBase is going to be breaking that functionality any time soon. They allowed summaries against calculated fields for several years, and a lot of companies still use those legacy designs. It is relatively recently (within last 2 years) that they started preventing new summary fields in that situation. There is nothing that is going to prevent you from having multiple relationships between the same tables. I had 50 scalar fields that were references to the same parent table. I needed to create 50 dropdowns for an order form. I generally will have 2 relationships to the same table. One formula and one scalar.
Thank you,
John
------------------------------
John Crosland
------------------------------
- Thanks John,
I read your post this morning, was in for a procedure at a hospital, so a bit groggy this evening. I printed out your post to look at, lots of great information.
I also am watching Benjamin Buday's talk on Relationships and Lineage from Empower 2021 which he goes into relationships-are they necessary or problematic. So that is also useful. I think there is good information with QB Junkies, but I don't have a subscription.
------------------------------
Bob T.
------------------------------- Bob , I've been using QuickBase from 3 Years , I finally took her subscription few months back.
I regret not taking up QuickBase Junkie subscription on day 1 . Concepts I have struggled and scraped from forums are laid on beautiful pdf platter for you to consume.
HIGHLY RECOMMENDED
@Quick Base Junkie
------------------------------
Prashant Maheshwari
------------------------------- @Prashant Maheshwari Thanks for the recommendation!
For anyone wondering what he's talking about, you can find all the available Quick Base Junkie training courses here.
There is an individual course for Relationships and a Mega course bundle of all the available training that is most popular.
Quick Base Junkie is not part of Quickbase, but a company I created to help Quickbase builders learn fast and deliver more based on my experience as a builder myself.
-Sharon
------------------------------
Quick Base Junkie
Quick Base Junkie
https://quickbasejunkie.com
------------------------------
