# If A1 is present in column B, get C. How do I make it?

**URL:** <https://community.glideapps.com/t/if-a1-is-present-in-column-b-get-c-how-do-i-make-it/20463>\
**Category:** Ask for Help\
**Created:** [December 29, 2020, 8:01pm UTC](https://community.glideapps.com/t/if-a1-is-present-in-column-b-get-c-how-do-i-make-it/20463 "2020-12-29T20:01:15Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\
**Post date:** [January 22, 2021, 11:22am UTC](https://community.glideapps.com/t/if-a1-is-present-in-column-b-get-c-how-do-i-make-it/20463/21 "2021-01-22T11:22:58Z")

</div>

I’m trying to make it in glide, but I can’t figure out how to make unique values from a list, any help?

---

<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:** [January 22, 2021, 1:25pm UTC](https://community.glideapps.com/t/if-a1-is-present-in-column-b-get-c-how-do-i-make-it/20463/22 "2021-01-22T13:25:24Z")

</div>

As of now the only way is to do it right from the start of creating records, in my opinion.

Let’s say you have a custom “form” with an add row action, an “All Records” sheet and a “Unique” sheet. The column you want to write to the “Unique” sheet is called “Animals”, for example.

In the “Custom” form, you have a user-specific column to write the “Animal” you want to create.

Then have a relation from that user-specific column to the “Animals” column in the “All Records” sheet.

If relation is not empty =\> Only writes to the Animals sheet.

If relation is empty =\> Writes to both the “All Records” and “Unique” sheet.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/if-a1-is-present-in-column-b-get-c-how-do-i-make-it/20463/23 "2024-01-17T16:53:43Z")

</div>

Closed on January 17, 2024, 4:53pm UTC



[Previous page](https://community.glideapps.com/t/if-a1-is-present-in-column-b-get-c-how-do-i-make-it/20463.md?page=1)
