# Check if I have all data **URL:** \ **Category:** Ask for Help\ **Created:** [January 26, 2024, 2:00pm UTC](https://community.glideapps.com/t/check-if-i-have-all-data/70069 "2024-01-26T14:00:51Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![yedidyavd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yedidyavd/32/51594_2.png) [@yedidyavd](https://community.glideapps.com/u/yedidyavd)\ **Post date:** [January 26, 2024, 2:00pm UTC](https://community.glideapps.com/t/check-if-i-have-all-data/70069/1 "2024-01-26T14:00:51Z")
Hello everyone, I have a application for meeting documentation of my customer. Every customer has customer number. I have to save some personal details as birthday, phone number, address etc. When I meet customer I insert his number and I want to record that I meet him in date \*\*\*, this is already working well. I also want to know, when I insert his number, if I already have all the details I need or I need to ask him about some details, and it will show me which details I have to get from him. How can I do it? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 26, 2024, 2:19pm UTC](https://community.glideapps.com/t/check-if-i-have-all-data/70069/2 "2024-01-26T14:19:19Z")
A relation and lookup columns would be able to retrieve the information you need based on a customer number. ---
**Author:** ![yedidyavd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yedidyavd/32/51594_2.png) [@yedidyavd](https://community.glideapps.com/u/yedidyavd)\ **Post date:** [January 27, 2024, 7:27pm UTC](https://community.glideapps.com/t/check-if-i-have-all-data/70069/3 "2024-01-27T19:27:51Z")
Hi Jeff, Thanks you. I would appreciate it if you could elaborate on that, how exactly it is done ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 27, 2024, 8:59pm UTC](https://community.glideapps.com/t/check-if-i-have-all-data/70069/4 "2024-01-27T20:59:48Z")
Relation of customer number back to the customer. Lookup to grab the values you need. > [@link Glide Relation Basics](https://community.glideapps.com/t/glide-relation-basics/50959): > > Hey all! I’m releasing a mini series all about the Relation Column in Glide. Before I create tutorials on more intermediate topics such as conditional relations, crafting matching values, or navigation and data generation via relations, we need to start from the beginning. To kickstart the miniseries, here’s a tutorial on the basics of creating relations in Glide. play_button Wait...what's a Relation in Glide? Enjoy! [[Glide 101: Relation Column] ](https://www.youtube.com/watch?v=ecJy1hvfb-U) Also, if you’re brand new to Glide, make sure… You can fast forward to 7:20 to skip explanation. ---
**Author:** ![yedidyavd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yedidyavd/32/51594_2.png) [@yedidyavd](https://community.glideapps.com/u/yedidyavd)\ **Post date:** [January 28, 2024, 10:37am UTC](https://community.glideapps.com/t/check-if-i-have-all-data/70069/5 "2024-01-28T10:37:18Z")
Thank you very much for the link, it was really interesting and helpful. But, that’s not what I’m looking for. Although I will use it for other purposes. In my app, I enter the customer number. When I confirm the number, a record is created with the current date, so I know that the customer visited me on a certain date. I want that as soon as I confirm the number, if I am missing some of the customer’s personal details, a screen will open for me to complete the details, and only after completing the details, a new record will be created with the date of the visit. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [January 28, 2024, 12:37pm UTC](https://community.glideapps.com/t/check-if-i-have-all-data/70069/6 "2024-01-28T12:37:55Z")
Yes its possible. Just create on submit action which will check where the number is confirmed & all fields are filled then set column with the current date, if the number is not confirmed & not all fields are filled then open edit screen this item