Using Photo Uploader widget

After playing around with the photo uploader widget for a while, I decided to document the procedure I used for posterity...

1. I create two tables in my database:

  One is the photo place holder table (this is the table that determines how many photos you can upload) = tbl_1

One is the actual table where I store the photo path, desc and uploaded flag = tbl2

Both tables have the following columns - 

photo_id(int) (auto incriment)

photo_descr(varchar)

photo_location (varchar)

photo_uploadedFlag (int)

I then  add 10 rows to tbl_1 (normal blank records will do) 

you can add more, or less records, I use 10 because android devices need at least 10 records

2. In MSTR, create 1 Attribute and 1 Metric

Attribute "PhotoLoad" 

forms: 

ID = photo_id

DESC = photo_descr

Location = photo_location

Metric "PhotoUploaded"

Sum(photo_uploadedFlag)

3. Create a new report in MSTR that has "PhotoLoad" attribute in rows (hide the ID form) and "PhotoUploaded" metric in columns

You will use this report in your dashboard

4. Create a new Transaction Report that insert data into tbl_2

e.g.

Begin Transaction
insert intotbl_2(photo_descr,photo_location,photo_uploadedFlag)VALUES(<inp_photo_descr>,<inp_photo_location>,<inp_photo_uploadedFlag>)End Transaction

5. In Web, create a new document

add the first report you created

set the report widget properties to Mobile > Photo Uploader

Right click on table and Configure Transactions

Choose the Transaction Report you created and map the table columns to the corresponding input values (mark all of them as editable)

Add a submit button

Test on an iPad