Forum Discussion

MarkCorcoran's avatar
MarkCorcoran
Qrew Cadet
9 years ago

Table that records Monthly Values of column in another table.

I'm new to quickbase so please bear with me. I have a table (product details) for our company inventory.  One of the fields is a formula field called [inventory value].  This field calculates the v...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
well, my real suggestion is to set up a subscription report to come monthly which is has a total and then manually key in the number once a month.

The advantage of that method is that even if you were late in King the number of the inventory value will have been recorded at the exact month end and you can key it in at your leisure anytime.

But I will post back with a semi automated solution when I get a chance.
MarkCorcoran's avatar
MarkCorcoran
Qrew Cadet
9 years ago
Cool, I wasn't familiar with subscription reports.  That will work, but I would still be interested in seeing an automated solution, as i have other cases where I will need to sum and/or count table field data, then use that information in formula fields.