How can I have one column pull data from another, from the row above?

Question

I am trying to develop a form that will allow us to monitor how full something is. On Day 1 it is 0, Day 2 would be an initial of 0, with volume added throughout the previous 24 hours. In order to calculate the daily totals, I would need to source from separate rows and columns... Is there a way to do this? Please see the attached image. Any help this community can provide would be greatly appreciated!

------------------------------
Josh Reavis
------------------------------

markshnier__you · Answer

Are you saying that you want to sort of daisy chain the lookup so that the values form one record flow to another? That can be done, but the key field of the table would need to be the date and you would need to load every date (typically via an excel upload). In the screen shot attached you have missing sequential dates.

I can explain more if that is your scenario.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

joshuareavis · Answer

More or less, yes?&nbsp; There are equations and calculations done based on how much volume accumulates during any given interval; anywhere from 3 days to 2 weeks in between data collection.------------------------------Joshua Reavis------------------------------

markshnier__you · Answer

You can relate a table to itself.&nbsp; If there is a way to calculate the previous date, then the relationship can be based on a formula, or else, you would need to manually edit each date record to select the previous date record to lookup from.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

johncrosland · Answer

Good morning,I assume you are relating this data collection to a Site or piece of Equipment. You can use a series of summary and lookup fields to track the last record two records. The reason that I say the last two records is because of the order of operations that QuickBase performs, then you can set that value as a Snapshot value on the second to last data collection value that the Equipment or Site had, and that should be the value that you are expecting. Another option, if you can guarantee that people will use a Form, then you just need to use two Summary and Lookup Fields (one for the last Record ID, and one for the Current CC Level). That Current CC Level will be the previous CC Level. However, you will need to use a Dynamic Form Rule to set the previous value, and Dynamic Form Rules only work on Forms. They do not apply to Grid Edit or Imports. If you're importing the data, then you will need to utilize a solution similar to Mark's where you create a calculatable key field that can be done prior to importing, and then you can use a Formula reference field to bring the data into the subsequent record.Thank you,John------------------------------John Crosland------------------------------

Forum Discussion

How can I have one column pull data from another, from the row above?

4 Replies

Related Content

Old form: label on the left side instead above an input field.

Report Column labels not saving

Copy Single Table from One App to Another

Justifications for Table Report Columns

Derive the Year from another field

Recent Discussions

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns

Quickbase JMP connection