Multiple Photos

AppSheet AppSheet Q&A
1

I need to be able to take multiple photos on one form. Repair photos must be taken of all damage and often more than one photo needs to be taken to cover all of the damage. Is this possible?

2

@Judi_Phelps Yes, it’s possible, but you’ll need multiple columns in your data table available (each column will collect one photo).

Here’s an example: https://www.appsheet.com/samples/Autocreated-from-Google-Sheets?appGuidString=2aa0bb90-9f24-4962-9eae-24b6f17ac243

3

If you have lot of photos, one workaround is a related table structure where your photos would be child records. Then there is no “limit” how many photos you can take. The Damage itself would the parent record.

4

I have created a table called images and it is now a related images field on my table called “form”. how do I get the related images field to display on my form?

5

I strongly suggest doing it another way, as you do NOT know how many photos will be needed.

Create a child table “Photos”. Create a column to be the key (uniqueid()), another for the photo itself, another you can call FK (Foreign Key)

If you want, you can have other columns… let’s say you want to add the possibility of a small commentary for each photo.

Now, make the FK column as a REF type, and go into it’s options and make it BELONG TO… and select the main form table.

Now, let’s say you start a new form. It gets an uniqueID let’s say abcdefgh.

You can add photos to it clicking on NEW PHOTO. Each photo you take inside this form will have it’s own ID, but it’s FK column will have ABCDEFGH, and AppSheet will know that photo belongs to THAT form.

6

go into the UX menu, VIEWS

Scroll down to REF VIEWS.

Several views there are created automatically. Search for the table IMAGES

IMAGES table will probably have a ref view that is a form type (where you take the photo itself). And another view, probably a table view. Make the column of that table, where the photo was stored, as the FIRST column. You can also change from TABLE to DECK, GALLERY, DETAIL. It will change the size of the thumbnails that appear on your main form.

7

Thanks. I completely forgot about “partof”