I would like to add validation of image fields in my data. We have a number of optional images, and we need to validate that certain images are uploaded depending on the values of other data fields.
I figured I could treat the image field as a text field, but that does not work. Has anyone here found a good way to do these types of validation in AppSheets?
It would be very nice to be able to validate the size of images as well.
Unfortunately, AppSheet doesn't currently offer direct validation for image fields. Treating them as text fields won't work because image data is stored differently.
Thanks for taking the time to respond!
Do you know if there are plans make it possible to validate image fields?
This is not possible, but if you want to save the photos with a smaller size:โจ
You can control the captured image size by setting the Image upload size when configuring general view settings. This sets the maximum image width to one of the following options:
link: Image upload size
Sorry I did not express myself clearly in my last response.
What I am asking is if this is a feature that will eventually be implemented?
Best regards,
Johan Mannby
@j-r-m wrote:
I figured I could treat the image field as a text field, but that does not work.
You may want to share more details. Do each of the images have unique names so that those can be distinguished from each other?
How the image fields are uploaded and saved, used in the app? Also are there handful of images that you wish the app user to choose from?
Could you share how these image storage currently looks in the app backend? Typically AppSheet store those images as
TableName_Images/Row_Key.Image_ColumnName.timestamp.png
So for example following is image path of images stored in the [Image] column in the "Products" Table.
Folder as denoted in Yellow is created by the app itself, the text in green is the row key, , the column name is in blue and timestamp is in red.
So, if you have some such fixed pattern and handful of images , we could possibly create suitable valid_if expressions or dropdown options expressions.
What I need the most is the ability to tell whether the user added a specific image or not.
A nice to have feature in the future would be the ability to validate that the image is a certain size.
E.g. 3600x150 pixels or somesuch.
User | Count |
---|---|
19 | |
9 | |
8 | |
6 | |
5 |