Images and how to auto rename upon adding in AppSheet?

AppSheet AppSheet Q&A
1

Hello,

First, I am a total newb! So I am sorry if this is in the category of “stupid questions”. However, I do hope that the community will help as I am stuck.

So, I have an app that’s connected to a Google Sheet as the backend. What I am trying to do is to have the images that I upload do 3 things. I will try my best to explain here below in bullets:

  1. Each image has a naming convention using the data in a field in specific columns in the spreadsheet (i.e. FirstName.FamilyName.[uniquenumber] - Eric.Smith.001)

  2. The image is saved in a folder that is automatically created in Google drive using the “FamilyName” field.

  3. The app finds the “FamilyName” field/identifier and sorts them into the same folder, essentially identifying each person with the last name, as of the same family. Note: I am aware that the last name is not a good identifier and have a “system” for that to avoid redundancy!!!

I have tried using the CONCETANATE value, but since I have no idea what I am doing I have failed. Miserably at that…

Please help!

2

It’s not very clear exactly which part you are stuck on or are asking a question about. But here’s a recent tip on how to give custom names to files. Note that you will never have complete control over the names of files uploaded through the app.

[More User Friendly Image names for images uploaded through app](https://community.appsheet.com/t/more-user-friendly-image-names-for-images-uploaded-through-app/58418) Tips & Tricks ?

When images are uploaded through an Appsheet app form, the Appsheet names images files in the format [Table’s Key column].[Image Column Name].[TimeStamp] that are cryptic at times for users. Instead of saving images in the “Parent” table, if the app creator can have a three-column child table to the “Parent” table to save images, the images could have meaningful name strings. Columns in this child table will be [ID ] - Key column, [Parent Table ID] - Reference to “Parent” table and Image Col…

3 Likes