LinkedIn
Twitter
1 ACCEPTED SOLUTION
You could try following to get "Image"in the “File” type column into “Image” type column.
- Where images and files are stored?
Quote from article on “Capturing Images”
*The captured image is saved in a subfolder in the same location as the spreadsheet.
- The subfolder is called {TableName} _Images by default.
-
Create a file type column called say [ImageFile]
-
Suppose your images column is called [Images] , then in this column’s setting please define the file path as shown below. Note that in the example below the Table name where images and files are store is “Menu” . So as described in point 1 above, the default file path is “Menu_Images/”
Please remember double quotes while defining the path
In the App formula of [Images] column please have an expression like below.This expression will extract the file name from file path and put it in image column.
Now you should be able to see the “image file” in [ImageFile] column in [Image] column,
Edit: The above approach requires that the record be openedand closed again once the file is uploaded. An easier approach is to have a simple spreadsheet formula in the spredsheet itself and then regenerating the table. This approach will start showing the image in the image field once it is uploaded in the file field in the app.
As shown below the spreadhseet formula for cell B2 is “=C2”
You could try following to get "Image"in the “File” type column into “Image” type column.
- Where images and files are stored?
Quote from article on “Capturing Images”
*The captured image is saved in a subfolder in the same location as the spreadsheet.
- The subfolder is called {TableName} _Images by default.
-
Create a file type column called say [ImageFile]
-
Suppose your images column is called [Images] , then in this column’s setting please define the file path as shown below. Note that in the example below the Table name where images and files are store is “Menu” . So as described in point 1 above, the default file path is “Menu_Images/”
Please remember double quotes while defining the path
In the App formula of [Images] column please have an expression like below.This expression will extract the file name from file path and put it in image column.
Now you should be able to see the “image file” in [ImageFile] column in [Image] column,
Edit: The above approach requires that the record be openedand closed again once the file is uploaded. An easier approach is to have a simple spreadsheet formula in the spredsheet itself and then regenerating the table. This approach will start showing the image in the image field once it is uploaded in the file field in the app.
As shown below the spreadhseet formula for cell B2 is “=C2”
