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
------------------------------
