# Radar Address Complete in Form **URL:** \ **Category:** Ask for Help\ **Created:** [July 8, 2023, 2:28am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658 "2023-07-08T02:28:31Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [July 8, 2023, 2:28am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/1 "2023-07-08T02:28:31Z")
Does anyone know how to use the Radar Address Complete capability in a form? I have a long form that users fill out, including the location of their asset. I would like the autocomplete to validate their address entry because later I will show on a map and calculate lat-lon coordinates. Thanks! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 8, 2023, 2:48am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/2 "2023-07-08T02:48:08Z")
Bob covers that in the below video: > [@sparkles Glide Integrations (Radar, Pexels, Google Calendar, Gmail/Outlook, Twilio)](https://community.glideapps.com/t/glide-integrations-radar-pexels-google-calendar-gmail-outlook-twilio/59315): > > wave Hey fellow Gliders! I’m launching a new series on all the wonderful new integrations that Gliders can add to their Glide apps. Without a single line of code, integrate with dozens of platforms: point_right Integrate OpenAI point_right Send Slack or Discord messages point_right Create PDFs with PDFMonkey or Urlbox First up—compass Forward and Reverse Geocoding with [Radar](https://radar.com)[[Glide: Reusable Actions and Integrations (First up—Radar)] ](https://www.youtube.com/watch?v=99Ohi09i6GU)Listing:play_button Radar: Forward/Revers… ---
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [July 8, 2023, 3:14am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/3 "2023-07-08T03:14:22Z")
I’ve been following that video, but it’s not working for me. The hint just keeps pulling in the first address in my table. Any ideas what I might be doing wrong? ![Screenshot 2023-07-07 at 11.20.11 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/4/f40422a396996c17b8cc7f76815c9c1e41960561.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 8, 2023, 3:25am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/4 "2023-07-08T03:25:43Z")
Actually, if you’re wanting to use it in a form, then it would need to be a [Custom Form](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014). With a native form, the values aren’t written to the target table until _after_ the form is submitted, so there is no data to use prior to that for the auto complete lookup. A custom form addresses that, because the user input is written to a user specific column as they type, and is available for immediate use. ---
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [July 8, 2023, 3:34am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/5 "2023-07-08T03:34:33Z")
Ooof, it just got super complicated. I will try again in the morning. Thanks for sharing this, @Darren_Murphy ---
**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:** [July 8, 2023, 5:14pm UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/6 "2023-07-08T17:14:28Z")
What I’ve been doing lately is to use what I’m calling “hybrid” forms: 1. show new screen action instead of form screen 2. add an input component for any input you want to validate against another table (using relations, etc) 3. add a form container beneath the input for the remainder of the form, but only display the form container if the input outside of the form container is “valid”. This way you still have a form experience with less updates but can still leverage the custom form experience for the one or two inputs that require it. I have an example somewhere in an app I worked on recently. I’ll see if I can dig it up when I get home this evening. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 8, 2023, 5:29pm UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/7 "2023-07-08T17:29:44Z")
> [@Robert\_Petitto](#): > > What I’ve been doing lately is to use what I’m calling “hybrid” forms: Nice! I’ll have to give that a try ---
**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:** [July 8, 2023, 10:18pm UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/8 "2023-07-08T22:18:04Z")
Here’s one example of a “Hybrid Form” in Glide: Kind of a combination of a [form screen](https://www.glideapps.com/docs/guides/other/forms) and a [custom form](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014). The setup: 1. Helper Table for the form 2. Show New Screen → Helper Table (Or Show Detail Screen → Single Value → Helper Table → Whole Row ) 3. Entry components → User Specific columns for any entry that needs live relations/lookups/calculations 4. Form Container to finish off the form experience 5. After Submit Action → Close Overlay/Show Notification/Etc. ---
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [July 8, 2023, 11:44pm UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/9 "2023-07-08T23:44:30Z")
Thanks @Robert_Petitto ! I watched the video, but I can’t get my head around how to use this on my form. I use _a lot_ of filters on the form, which don’t seem to work with custom forms. The container makes it easy to use data already entered to filter other fields. How do you see hybrid forms working in my address case? Would I still need to use a custom form? ---
**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:** [July 9, 2023, 1:15am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/10 "2023-07-09T01:15:40Z")
> [@meg](#): > > I would like the autocomplete to validate their address The way I see this working is: 1. User enters an address 2. Radar → autocomplete 3. User confirms address These three steps could occur before a user completes the rest of the form in a form container. The form container can pass the autocomplete address along with other form fields. ---
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [July 9, 2023, 1:24am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/11 "2023-07-09T01:24:00Z")
Ah, I see. I’ll give that a go. 🤞 ---
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [July 9, 2023, 1:49am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/12 "2023-07-09T01:49:50Z")
Should the three autocomplete steps be in the form container, or outside it? I put before the form container, and still it only edits the first row of my data. … Or should I have the address lookup in it’s own table? … Haha, nope. … @Robert_Petitto , the only way I see this working is if a new row is created first, and then the records are updated as a form. But then I don’t get the validation on the other fields, or it will be super complicated to add the validation. ---
**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:** [July 9, 2023, 5:39pm UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/13 "2023-07-09T17:39:51Z")
The three steps should happen before the form container, and then the form container should only appear if the address is valid. I recommend using a working table (a one row table with user specific columns) as the source for the screen. This way all of the validation steps are are in the same table as the form itself so that you can pass those values when you submit the form. I’m pretty sure I understand what you’re trying to achieve, but maybe I’m solving the wrong problem? ---
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [July 9, 2023, 8:19pm UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/14 "2023-07-09T20:19:14Z")
@Robert_Petitto , you are my hero! I got it working!! 🤩 One follow up question - how do I get the working table to clear so the address doesn’t appear when the user opens the form again? ---
**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\ **Post date:** [July 9, 2023, 8:52pm UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/15 "2023-07-09T20:52:44Z")
Youll need to use a Set Column action with a “Clear” for each column. However, if its a User Specific Column and Users are NOT signed in, then it should clear by itself. ---
**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\ **Post date:** [July 9, 2023, 9:27pm UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/16 "2023-07-09T21:27:00Z")
Great idea! ---
**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:** [July 9, 2023, 10:35pm UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/17 "2023-07-09T22:35:05Z")
> [@meg](#): > > how do I get the working table to clear What Joe said. Use an “after submit” action to clear the fields. ---
**Author:** ![meg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/meg/32/61386_2.png) [@meg](https://community.glideapps.com/u/meg)\ **Post date:** [July 10, 2023, 12:37am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/18 "2023-07-10T00:37:11Z")
I’m trying this, and I can’t get it to work. The form only gives me options to clear fields in the table associated with the form, not the fields in the working table. Any ideas? ---
**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:** [July 10, 2023, 1:16am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/19 "2023-07-10T01:16:44Z")
Can you show us some screenshots on how you’re setting it up? If you’re using a working table with a custom form, and then an add row action to “submit”, then you should be able to clear the columns as guys have stated above. ---
**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:** [July 10, 2023, 1:31am UTC](https://community.glideapps.com/t/radar-address-complete-in-form/63658/20 "2023-07-10T01:31:44Z")
Oh true. Workaround would be to create a single value column in the destination table that points to the working table for the form. Choose whole row. Then do the set column \> clear with this single value column as the data source in the set column action. [Next page](https://community.glideapps.com/t/radar-address-complete-in-form/63658.md?page=2)