# How to remember an open transaction? **URL:** https://community.glideapps.com/t/how-to-remember-an-open-transaction/67551 **Category:** Ask for Help **Created:** [November 5, 2023, 5:53pm UTC](https://community.glideapps.com/t/how-to-remember-an-open-transaction/67551 "2023-11-05T17:53:28Z") **Posts on this page:** 1 **Showing post:** 4
### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh) #### Post date: [November 5, 2023, 11:27pm UTC](https://community.glideapps.com/t/how-to-remember-an-open-transaction/67551/4 "2023-11-05T23:27:25Z")
I’m not entirely sure if this fits your flow and structure, but I think you can use a custom form, store the number plates, and use a query to the transactions table to see if there’s an open transaction for that number plate. > [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014): > > I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula… --- _[View the full topic](https://community.glideapps.com/t/how-to-remember-an-open-transaction/67551)._