Relationships functional question
Hello! Intermediate-level user here and very much enjoyed the former QB forum - hoping to see some familiar faces on here. I am dipping my toes in the waters of fixing a Quickbase app that I didn't ...
Forum Discussion
Regarding your last comment that you can only change type of field once, this is not the case. You should be able to change the field as many times as you like. The only exception I know, is that if you change it into a multi select field (and I think also a list user field), you can no longer change the type. Other than that, you can keep changing the type of field.
Thank you!
Okay yes, that is where I've seen that transpire is if I changed a field to multi-select (including formula multi-select text).
My predecessor seems to have done what you're mentioning and set it to Maximum Date from the child. I don't know what then is misfiring on that field..... in one example, it produces 11-13-2023 as the "latest record" - and is supposed to be summarizing a specific field, which is "Date of Service". On that exact example, both the Date of Service on the child table AND the newest record were created on 11-14-2023. I'm not sure why the 1 day discrepancy.
The function here is supposed to be:
- Parent Table = Community Organizations
- Child Table = Our program's outreach to those organization
- Ideal field = Renders the date of the latest outreach onto the parent table, which could be the record date, but most accurately is pointing to the date the staff entered as "Date of Service/Outreach"
I think you are over complicating this. Mike is right what he suggested above. Just go to that relationship and make a summary maximum of the field [Date of Service]
Thanks! Any suggestion on why it's rendering the latest date minus one day? I did some exploring, that looks to be the case across the board from what I can see.
