I have a Profile page for each user that contains an image element, when a user first logs-in I’d like to copy a default picture URL to the corresponding Picture cell, so that when the user uploads a photo the default picture URL will be overwritten.
Why not use the If Then Else column that displays a default image if the user hasn’t set one yet?
Create a column that contains the default picture in every row. Create a second column that will hold the uploaded picture. Create a third column that will use an IF statement to select the uploaded picture, ELSE use the default picture.
Alternately, create just an Upload Picture column in your sheet. Then in the data tab, create an IF-THEN-ELSE column. If the upload Picture column is filled, THEN use that picture, ELSE use a default image URL. The IF column will be used for displaying the image in the app.
1 Like
thank you both @david and @Jeff_Hager - Followed your second suggestion, if I want to change the default image in the future I simply replace the default image URL 
2 Likes
The 2022 answer to that is: because user profile screen won’t let us choose non-image columns for the profile image.
No, the 2022 answer is basically the same as it was 3 years ago.
Create a second column with a default/random image - there are any number of ways to do this - and then use an if-then-else column to either select the image from the User Profile column (if not empty), or the default/random image. And then use that if-then-else column to display the user image in your App.
None of that requires using a non-image column for the user profile image.
2 Likes