gINT Collector for Apple iPhone or iPad

Thanks szang, I like that idea and I agree fully with the pros you listed in that post.

On the con side, that could become a very complex spreadsheet to develop, which might make it error-prone.  And while flexible, it might be cumbersome to modify.

If gINT Collector will be available for Apple products soon, I'll probably wait.  If Bentley isn't planning to push gINT Collector out to the App Store, I might go down this path.

You are absolutely correct, development of the spreadsheet and correspondence file requires substantial effort by someone who is familiar with excel. You get out of it what you put into it. I would not say this makes it anymore error prone than any other software. One advantage is that when errors are discovered they can be fixed instantly without waiting months for the next software update. I will point out that gINT collector will also require a significant amount of effort in order to set up input templates that reflect your data structure and input conventions.

Once set up, some modifications are easy, others are more involved.

With these thoughts in mind, I have prepared a 30 minute video to demonstrate what can be done. Even if this does not work for you, the video might help you figure out what features might be desirable,  or undesirable, in other solutions.  The video shows how it works and discusses advantages and disadvantages.

The video is not professionally done; I do not have the voice of James Earl Jones; so take it for what its worth. It may be downloaded or viewed from dropbox using the following link.  You do not need a dropbox account to download it. Please do not spread it around the internet where it can be taken out of the context of this thread.

www.dropbox.com/.../FIT_demo.mp4

If you have difficulty accessing this file, please respond to this thread.

I am sure the video has many errors, some that  I am aware of are listed in the following Errata:

3:33 I said I entered -112.6732 but I actually entered -212.6732 (not a valid longitude)

14:18 I forgot the designation for the ASTM visual classification of soils. It is ASTM D-2488.

23:28 I stated I set the key field to zero and then check for that in the correspondence file.  I meant to say I set the key field to NULL.. ..

Edit 3-11-2020 - I have placed a second 4 minute video that demonstrates all 4 input methods available via excel (on some devices.  These include the drop down lists and soft keyboard demonstrated in the video above along with handwriting recognition and voice recognition not previously demonstrated.  This is one of the advantages discussed, Microsoft excel handles all the input devices available on various devices including any yet to be developed methods.  The video is in the same dropbox account as above and is accessed/ downloaded similarly.  The link to this video is below.  Again if there are any difficulties accessing this video please respond to this thread.

https://www.dropbox.com/s/jt4f9151k9uh759/Input%20methods%20for%20FIT_small.mp4?dl=0

You are absolutely correct, development of the spreadsheet and correspondence file requires substantial effort by someone who is familiar with excel. You get out of it what you put into it. I would not say this makes it anymore error prone than any other software. One advantage is that when errors are discovered they can be fixed instantly without waiting months for the next software update. I will point out that gINT collector will also require a significant amount of effort in order to set up input templates that reflect your data structure and input conventions.

Once set up, some modifications are easy, others are more involved.

With these thoughts in mind, I have prepared a 30 minute video to demonstrate what can be done. Even if this does not work for you, the video might help you figure out what features might be desirable,  or undesirable, in other solutions.  The video shows how it works and discusses advantages and disadvantages.

The video is not professionally done; I do not have the voice of James Earl Jones; so take it for what its worth. It may be downloaded or viewed from dropbox using the following link.  You do not need a dropbox account to download it. Please do not spread it around the internet where it can be taken out of the context of this thread.

www.dropbox.com/.../FIT_demo.mp4

If you have difficulty accessing this file, please respond to this thread.

I am sure the video has many errors, some that  I am aware of are listed in the following Errata:

3:33 I said I entered -112.6732 but I actually entered -212.6732 (not a valid longitude)

14:18 I forgot the designation for the ASTM visual classification of soils. It is ASTM D-2488.

23:28 I stated I set the key field to zero and then check for that in the correspondence file.  I meant to say I set the key field to NULL.. ..

Edit 3-11-2020 - I have placed a second 4 minute video that demonstrates all 4 input methods available via excel (on some devices.  These include the drop down lists and soft keyboard demonstrated in the video above along with handwriting recognition and voice recognition not previously demonstrated.  This is one of the advantages discussed, Microsoft excel handles all the input devices available on various devices including any yet to be developed methods.  The video is in the same dropbox account as above and is accessed/ downloaded similarly.  The link to this video is below.  Again if there are any difficulties accessing this video please respond to this thread.

https://www.dropbox.com/s/jt4f9151k9uh759/Input%20methods%20for%20FIT_small.mp4?dl=0