Saving images to a custom folder

[Jack_Bates]

We save images from Load Data[Image] and “Expense”[Image]

I need to save these images in files for each “app user” in separate files for each image set

Is there a way for AppSheet to auto create these pathways for new users

[Marc_Dillon · Accepted solution]

That's not an expression, that's just a text string, because it's all in quotes. You need to use CONCATENATE(), or it's shortcut '&'. And remember that it's a relative path from the location of the gsheet, not from the root of your gdrive. So more like:

"DATA_IMAGE_images/" & App User[EMAIL]

But also, are you filtering the "App User" down to a single record with security filters or a slice? If not, that will return a list of all emails from the "App User" table. See here for more:

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column...

If you're just wanting the current user's email address, use USEREMAIL() instead.

[Marc_Dillon]

Each Image type column has a folder path setting, which you can use expressions in. So use an expression that sets the folder path differently for the different users. Note that all folders must still be at or below the location of that table's gsheet (relative paths).

[Jack_Bates]

"/appsheet/data/AnnualLoadBookApp-638534/DATA_IMAGE_images/App User[EMAIL]"

I am having trouble getting the expression to work. Can you give me an example expression that I can look at

[Marc_Dillon · Accepted solution]

That's not an expression, that's just a text string, because it's all in quotes. You need to use CONCATENATE(), or it's shortcut '&'. And remember that it's a relative path from the location of the gsheet, not from the root of your gdrive. So more like:

"DATA_IMAGE_images/" & App User[EMAIL]

But also, are you filtering the "App User" down to a single record with security filters or a slice? If not, that will return a list of all emails from the "App User" table. See here for more:

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column...

If you're just wanting the current user's email address, use USEREMAIL() instead.

[Jack_Bates]

I am filtering the “App User” down to a single record with security filters not a slice. For the “DATA” record

I also do the same for “Expenses” Record

[Jack_Bates]

That works Thank you

[Jack_Bates]

That created a folder in Expense_Image and Data_Image for each “App User”

My next question would be is there a way to make sub folders for each “Expense” category inside the created”App User” File

[Marc_Dillon · Accepted solution]

"root-folder/" & {user-expression} & "/" & {expense-category-expression}