Skip to main content
Question

Formula? But from excel? SOS!

  • March 8, 2022
  • 0 replies
  • 44 views
SaviNewman1
Forum|alt.badge.img+6
Good morning,
I feel like I always have an impossible task. Right now, we're using an excel spreadsheet, but would much rather utilize QuickBase.
I have 2 tables created (tasks) and (meter reads). I need the following formulas that communicate with each task date, and source information. I have made a relationship between tasks and meter reads as well, but am struggling to figure out the formula to insert. There is 3 different formulas I need per meter reading that automatically calculates in it's own field.



------------------------------
Newman, Savi
------------------------------
Newman, Savi [Designation] [JobTitle] [CompanyName] [City] [State] [Phone]
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
This is is complicated as you need to refer to previous records to get the previous meter reading.  It may be able to be done with Formula Queries.  The feasibility of this may also depend on the size of your dataset.

Another though is to make a relationship of the meter readings table to itself.  Then use a Pipeline to populate the related previous reading.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement