Forum Discussion

JordanBeatty1's avatar
JordanBeatty1
Qrew Captain
6 years ago

Best Way To Summarize Numbers To Calculate Overages

The table structure is one Parent Company has many Companies and one Company has many activities. The parent company record contains a limit to calculate overages. The activity records contain a Time...
Relationships
JordanBeatty1's avatar
JordanBeatty1
Qrew Captain
6 years ago

My mistake, didn't realized responding through email sent a direct message.

So it's been a reallll long time since I have had to do anything Quickbase related. I have it linked so that a table called Date Range has many activities. So I changed the reference field from numeric to numeric formula, but it keeps telling me it is expecting text?



------------------------------
Jordan Beatty
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
The formula for the reference field in Activities should just be

1

ie, just a 1


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------