# Sign in Action Button

**URL:** <https://community.glideapps.com/t/sign-in-action-button/20164>\
**Category:** Report a Bug\
**Created:** [December 22, 2020, 3:27am UTC](https://community.glideapps.com/t/sign-in-action-button/20164 "2020-12-22T03:27:00Z")\
**Posts on this page:** 12\
**Page:** 2

<div class="post-metadata">

**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:** [December 22, 2020, 5:11am UTC](https://community.glideapps.com/t/sign-in-action-button/20164/21 "2020-12-22T05:11:22Z")

</div>

Yeah, actually I just did a quick test and it looks you can’t use a computed column for the avatar. So my previous suggestion won’t work.

But your idea should be fine 👍

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [December 22, 2020, 5:11am UTC](https://community.glideapps.com/t/sign-in-action-button/20164/22 "2020-12-22T05:11:55Z")

</div>

Will try it thank you!

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [December 23, 2020, 4:14pm UTC](https://community.glideapps.com/t/sign-in-action-button/20164/23 "2020-12-23T16:14:15Z")

</div>

Hi Darren, So I did the above, seems to work, but the user can change the image to something else. Do you know if there is anyway to stop that? How do you deal with the wrong type of images being uploaded?

---

<div class="post-metadata">

**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:** [December 23, 2020, 4:28pm UTC](https://community.glideapps.com/t/sign-in-action-button/20164/24 "2020-12-23T16:28:29Z")

</div>

hmm, that’s a good question. If there is a way to do that I am not aware of it. The only thing I can think of would involve a scripting solution with a trigger. ie. if a user changes the image, then immediately overwrite it with the correct image.

Perhaps @Jeff_Hager or @ThinhDinh might know of a way to disable this.

---

<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:** [December 23, 2020, 4:42pm UTC](https://community.glideapps.com/t/sign-in-action-button/20164/25 "2020-12-23T16:42:05Z")

</div>

No, there isn’t a way. Let 'em change it. They’re the only ones that have to look at it.

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [December 23, 2020, 4:44pm UTC](https://community.glideapps.com/t/sign-in-action-button/20164/26 "2020-12-23T16:44:56Z")

</div>

Ah ok! so if someone uploads a nude or something, doesn’t it get saved on my glide sheet?

---

<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:** [December 23, 2020, 4:47pm UTC](https://community.glideapps.com/t/sign-in-action-button/20164/27 "2020-12-23T16:47:19Z")

</div>

Well, yeah, but if you assign it to a column that’s not used anywhere else in your app, then nobody else will see it.

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [December 23, 2020, 4:48pm UTC](https://community.glideapps.com/t/sign-in-action-button/20164/28 "2020-12-23T16:48:49Z")

</div>

OK I’ll see how it goes once I figure this favorites thing. I’ll add the logo as a default then they can change it if they want. Thanks!

---

<div class="post-metadata">

**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:** [December 23, 2020, 5:13pm UTC](https://community.glideapps.com/t/sign-in-action-button/20164/29 "2020-12-23T17:13:18Z")

</div>

@Jen_NYCP - just for a bit of fun, I coded up something that would automatically change the image back. I’ve tested it, and it works fine, albeit with a short delay.

```
function enforce_profile_image(event) {
  var profile_sheet_name = 'Users'; // Replace with the name of your user profiles sheet
  var image_col = 4; // Replace this with the column number that contains the image (A=1, B=2, C=3, etc)
  var image_url = 'https://randomuser.me/api/portraits/women/74.jpg'; // Replace this with the URL of your logo
  
  var sheetname = event.source.getActiveSheet().getName();
  if (sheetname != profile_sheet_name) {
    return;
  }
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(sheetname);
  var data = sheet.getRange(2,image_col, sheet.getLastRow()-1, 1).getValues();
  data.forEach(function (row) {
    row[0] = image_url;
  });
  sheet.getRange(2,image_col, sheet.getLastRow()-1, 1).setValues(data);
} 

```

You would use that with an `On Change` trigger. If you’re not sure how to configure triggers, I covered this in a recent [tutorial](https://community.glideapps.com/t/using-app-script-with-a-json-api/20051) (Part 4). If you wanted to use it, note that you’d need to replace the variable values on the first 3 lines.

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [December 23, 2020, 5:44pm UTC](https://community.glideapps.com/t/sign-in-action-button/20164/30 "2020-12-23T17:44:09Z")

</div>

Oh, thank you for this!! I think it would be weird to change the image back once a user uploads one. Only if it was possible for them not to have the option at all, Or I’m thinking to have select graphics they can choose from. Not sure if that is possible.

---

<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:** [December 23, 2020, 11:26pm UTC](https://community.glideapps.com/t/sign-in-action-button/20164/31 "2020-12-23T23:26:07Z")

</div>

You can check out this concept.

> [@Visually select a previously uploaded image from within a form!](https://community.glideapps.com/t/visually-select-a-previously-uploaded-image-from-within-a-form/19590):
>
> A fun way to use relations and set columns to create a visual image picker from previously uploaded files from within a form!

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [December 24, 2020, 3:44am UTC](https://community.glideapps.com/t/sign-in-action-button/20164/32 "2020-12-24T03:44:23Z")

</div>

Will check it out. Thanks!

[Previous page](https://community.glideapps.com/t/sign-in-action-button/20164.md?page=1)