QBuserQBuser
8 years agoQrew Cadet
Cannot use formula and have a summary field using this relationship.
I am getting the following error when trying to use summary fields in a relationship.
We are sorry -- at this time, you cannot use this formula and have a summary field using this relationship.
I know from previous posts that I can click through error and it will still work. Unfortunately it randomly stops working from time to time and all the values are blank. I have to then delete the formula and recopy and save it. It is very frustrating that Quickbase cannot make this work.
I have over 400,000 records in a linked table that updates each night. I need to concatenate the date, location, and customer information. I do not think a form rule will work because the data is updated through the link. Is there any work around to this? I just need that concatenated value automatically copied over to a text field, but I cannot figure out how to do it.
We are sorry -- at this time, you cannot use this formula and have a summary field using this relationship.
I know from previous posts that I can click through error and it will still work. Unfortunately it randomly stops working from time to time and all the values are blank. I have to then delete the formula and recopy and save it. It is very frustrating that Quickbase cannot make this work.
I have over 400,000 records in a linked table that updates each night. I need to concatenate the date, location, and customer information. I do not think a form rule will work because the data is updated through the link. Is there any work around to this? I just need that concatenated value automatically copied over to a text field, but I cannot figure out how to do it.