Hi All Please assist me with 4 desperately ...

(Valentina Watkins) #1

Hi All

Please assist me with 4 desperately needed solutions on the google sheet front.

  1. How to make images display in sheet? (PLEASE do not post me a link to an article for displaying images, can somebody please teach me how to do this as CONCATENATE article is not really helping me at this moment)

+AppSheet I am aware of the sessions hosted where you can ask questions, but please load a simple video or videos on youtube on “how to” simple functions for using Appsheets, like displaying images.

  1. How to make signature display in the sheet?

  2. How to make the coordinates display as a name. e.g lat.00000 displays as South Island in sheet

  3. How to make location stamp detect location based on city in on column and country in other column so in the app it will show eg. South Island in Ocean.

Thank you kind community. Your assistance is priceless and so Valueable!

(Aleksi Alkio) #2

#1 - If the image name is in cell C2, the correct expression is like… =IMAGE(SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“AppName-AccountID”,"&tableName=",“TableName”,"&fileName=”,+C2), " ", “%20”),1)

The last number (1) indicates how the image is filled to your cell. You can try values 1, 2 and 3. If you choose 4, you need to add image size like …,4,200,200)

#2 - Use the same method than #1

#3 & #4 - Showing the name itself it’s probably not difficult. The problem is how you can detect what LatLong value belongs to which city or country. You should probably use the script/API on your spreadsheet.

(Valentina Watkins) #3

Hi Aleksi Thanx for your reply, but nothing is displaying. Please help

(Aleksi Alkio) #4

The folder I mean folder in Google Drive.

(Valentina Watkins) #5

@Aleksi_Alkio Ohkay, than i am very correct. Sheet is not in any folder, created as open file

(Aleksi Alkio) #6

Move the gSheet under your Appsheet folder like MyDrive > Appsheet > AppName

(Valentina Watkins) #7

@Aleksi_Alkio Hi Aleksi, ive moved everything as per instruction. Still not display.

(Aleksi Alkio) #8

Share the sheet with me so I can check the sheet formula aleksi@1track.com

(Aleksi Alkio) #9

What is your sheet expression?

(Valentina Watkins) #10

@Aleksi_Alkio =(IMAGE(SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“PetitionApp-376288”,"&tableName=",“PetitionApp”,"&fileName=”,INDIRECT(ADDRESS(ROW(), 4)),"&resizeImage=true&imageWidth=300"), " ", “%20”),3))

When i try adding the column and row it says error and automatically does indirect…

(Aleksi Alkio) #11

What happens if you try my expression I wrote above?

(Valentina Watkins) #12

@Aleksi_Alkio The sheet tells me to check spreadsheet settings. There is no error but it is also not giving the end result

(Aleksi Alkio) #13

Is your image forlder as a subfolder in that folder where you have this sheet?

(Valentina Watkins) #14

@Aleksi_Alkio Can i share the sheet with you? Please mail vlntn.watkins@gmail.com

(Aleksi Alkio) #15

That doesn’t help if your image folder and gSheet are not in correct place. I can’t do anything from the sheet itself. You need to check first that they are correctly placed.

(Valentina Watkins) #16

@Aleksi_Alkio Please advise what is meant by correctly placed. I have one sheet with 5 columns. Name, email, country, image, signature. Perhaps i am not understanding the folder which you are talking about?

(Aleksi Alkio) #17

#1 - If the image name is in cell C2, the correct expression is like… =IMAGE(SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“AppName-AccountID”,"&tableName=",“TableName”,"&fileName=”,+C2), " ", “%20”),1)

The last number (1) indicates how the image is filled to your cell. You can try values 1, 2 and 3. If you choose 4, you need to add image size like …,4,200,200)

#2 - Use the same method than #1

#3 & #4 - Showing the name itself it’s probably not difficult. The problem is how you can detect what LatLong value belongs to which city or country. You should probably use the script/API on your spreadsheet.

(Valentina Watkins) #18

Hi Aleksi Thanx for your reply, but nothing is displaying. Please help

(Aleksi Alkio) #19

What is your sheet expression?

(Valentina Watkins) #20

@Aleksi_Alkio =(IMAGE(SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“PetitionApp-376288”,"&tableName=",“PetitionApp”,"&fileName=”,INDIRECT(ADDRESS(ROW(), 4)),"&resizeImage=true&imageWidth=300"), " ", “%20”),3))

When i try adding the column and row it says error and automatically does indirect…