Tutorial 6

[Nick Antonaccio]

https://www.youtube.com/watch?v=nWsnispYiDE

Some more simple custom UI/database interaction examples (coin flip simulator, date difference calculator, cash register, custom UI form to database example, etc.)

[Dean D. Babic]

Once again you nailed it!
The coin toss is interesting, I think it might be possible to code this for multiple pics 

without hardcoding the path.

Pics and Docs are the main issue for ie MS Access  users, since Access just takes whatever

its thrown on it.

There are two choices for multiple documents with one record - details and KEYS column.

KEYS is quite overlooked however they might not suit for every scenario.

I modified Demo in here for Tracks which is using KEYS for files:

https://jampy.pythonanywhere.com/

Details are obviously self explanatory. 

Cheers

[Nick Antonaccio]

Thank you Dean :)

Perhaps looking up the name column value, and then using the filename value from that row would work nicely to avoid hard-coding any paths - and perhaps that's a nice thing to add to a future video :)  For this video, I didn't want to add any confusion to one of the main points in the tutorial, which was to demonstrate that files uploaded via the no-code Jam.py grid are stored in the file system, and that the .value property stores the file name.