Summary Field of a Formula
I'm a longtime QB user and seem to run up against this limitation often. I was wondering if anyone has found a good workaround. My data consists of three fields, "Date", "Division", and "Amount". I...
Forum Discussion
OK, I did not read your original post carefully enough before plunging in. Yes, now I understand the issue. So, what you will need to do is to create a Webhook or an Action to copy the value of he formula field to the data entry text field. At EMPOWER, Kirk Trachy said that you can trick the Action to being able to edit the record which was modified since the children are defined by a Report link and you can thus match up a Parent with itself based on the record ID#. I have not tried this myself, but Actions are gong to be easier to maintain.
Then you will be able to make that Relationships based on a pure text field and not have that limitation.
Then you will be able to make that Relationships based on a pure text field and not have that limitation.