EthanKaste
2 years agoQrew Member
Using Previous Data for New Entry
I am in the process of developing a form for my team and I am running into an issue. The form has several fields per entry dependent on the previous entry to keep an aggregate count as the entries come in (needs to pull in the previous value to calculate the difference over a set time). It is a process that is very simple in Excel, but I am new to QB and could use some guidance.
The value pulled in needs to be from the same location as the new entry and should pull the most recent value from that location's records. How can I pull in the previous record's value, but only from the most recent entry at the same location?
Let me know if any clarification is needed or how this can be achieved.
------------------------------
Ethan Kaste
------------------------------
The value pulled in needs to be from the same location as the new entry and should pull the most recent value from that location's records. How can I pull in the previous record's value, but only from the most recent entry at the same location?
Let me know if any clarification is needed or how this can be achieved.
------------------------------
Ethan Kaste
------------------------------