Is there currently a way to bring in an if/then column into the User Profile.
Case:
I have enabled user profiles.
In the Data Editor I have two columns.
ONE: Default Selfie (a default avatar given to every user)
TWO: Selfie Upload (a place to upload a selfie, if you want to)
Then an if/then column that shows the Default Selfie if the Selfie Upload is empty.
Is there currently a way to make this if/then column THE selfie in the profile?
Right now it only seems to be pulling from the sheet and not the created columns in the Data Editor.
(this seems like something @Robert_Petitto would have some sort of work around.)
What an awesome use case. I guess the only way to do this (Currently) would be to have an if/then formula in the sheet IN ADDITION TO the if then data column.
I say “addition to” only because the if then data column is instant and provides a better UX, and the formula in the sheet, although redundant, will allow for this functionality.
I think you are going to run into issues because the user profile image needs to be an editable column. An if/then column probably wouldn’t be recognized because of this, but you also run the risk of breaking an arrayformula if you attempt to do the formula in the sheet. I think a script would be the only way. The script would add the default image url to any row that does not have one set. When a user changes their image, then it updates and the script will not touch it because it’s filled in already.
I think the if else solution would work fine. The default pic column simply has an array formula that fills each new row with a default pic url then the user provided pic fills the next column. Then using an if else column that simply checks if the user pic column is empty. If empty use default column link, else use the user provided link.
Should be. in the glide editor navigate to profile and select the tab display then the 3 columns appear image, name and email should be able to be set to any column
You can do that, but if someone chooses to change their image through the user profile, it will break the arrayformula. If I understand correctly, @spencersRus wants the image to show in the user profile with either the default image or a user uploaded image.
Exactly @Jeff_Hager My original thinking (not knowing too much about the glide code or the spreadsheet magic) was that I thought that it would be good if we could create a data column that would fill in a default image (through Template and/or If/Then).
But I found out that it was not an option. Thus the original question.