# Visibility of text component linked with form completion

**URL:** https://community.glideapps.com/t/visibility-of-text-component-linked-with-form-completion/8706
**Category:** Ask for Help
**Created:** [May 8, 2020, 2:56am UTC](https://community.glideapps.com/t/visibility-of-text-component-linked-with-form-completion/8706 "2020-05-08T02:56:40Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### 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: [May 8, 2020, 2:56am UTC](https://community.glideapps.com/t/visibility-of-text-component-linked-with-form-completion/8706/1 "2020-05-08T02:56:40Z")

</div>

Hi Gliders,

I am currently working on a feature that lets user input their address in a form component. The data is then pushed back to Google Sheets for calculating distance between it and a “fixed restaurant”.

The idea is to generate a message, that if the distance is more than 5km, service can’t be provided and vice versa.

I have done the setup of automatic calculations and message generation. However, I’m struggling to figure out how the message can only be shown after the user has completed the form.

I attach a gif of what I am trying to do, highly appreciate any help for a solution or a potential workaround for the idea.

![ezgif-1-83efa204738b](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/63258282149c29fdde183bad6935784c4125b51a.gif)

Have a nice day!

---

<div class="post-metadata">

### 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: [May 9, 2020, 3:11pm UTC](https://community.glideapps.com/t/visibility-of-text-component-linked-with-form-completion/8706/2 "2020-05-09T15:11:48Z")

</div>

I’m a little confused on which sheet your form button is on, but I’m going to assume that it would be on a business listing. The only thought that comes to mind is to create a template in your address (form response) sheet that joins the email and address of the business. Then create a similar template in your business listing sheet where the form button would be located. You could first set up visibility on the message if there is a matching relation in the form response sheet. If there is no match in the form sheet, then then don’t show the message. Otherwise show the correct message based on distance.

---

<div class="post-metadata">

### 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: [May 9, 2020, 3:17pm UTC](https://community.glideapps.com/t/visibility-of-text-component-linked-with-form-completion/8706/3 "2020-05-09T15:17:27Z")

</div>

Hi Jeff,

Thanks for your suggestion. I have succeeded with a workaround but I’m still trying to optimize it before posting to this community as I think many people are in need of integrating this to their app.

Have a nice weekend!
