I seem to have run up against a restriction in QuickBase that I didn't know existed.
I have a table that contains "Work Instances." Each Work Instance has a date.
I have another table called "Work Weeks" that is in a many Work Instances to One Work Week relationship to Work Instances.
I wanted to automate the process of associating Weeks to Instances, so I set the Work Key Field to a Date field representing the first day of every week, and then set the Reference Field In the Work Instances table to a Date formula field that takes the Date the work was done and uses the FirstDayOfWeek() formula function to find what the first day of the week was that the Work Instance was done on.
This works great! Except that when I try to create a Summary Field in this relationship, I get a message telling me that:
"We are sorry -- at this time, you cannot use this formula and have a summary field using this relationship."
That's a bummer, but I'm wondering if there's a workaround? Or maybe an entirely different way to go about what I'm trying to do? (Basically, the whole reason I got myself into this mess is because I wanted to generate an notification when a certain number of Work Instances had been created within a week, and I used this suggestion: https://quickbase-community.intuit.com/questions/1126070-how-do-i-create-an-email-notification-based...
Please let me know if any clarification would help.