Wow. That's a great big wall o' text there.
-
There is a function of userName() - you could set a form load rule that sets VenueManager to userName() on open if the field is blank (since you won't want that to get reset with another name every time the form is opened)
-
No, there is no time picker
-
Put your table inside a section and add conditional formatting to the section. Looks like your option button for No has a value of 2 - so hide the section if LightingRigYesNo is equal to 2.
-
You can't really submit just a part of the form - but we generally use sections and conditional formatting to mimic that - here's a
post that might help.
-
When you set up an email connection, you can use a formula (the fx) button to indicate a field with the email address. So, have a field for email to, and populate with the correct email address via rules. Then add a rule to close the form.
-
See 5 above for your CC question - if you use a single field and have your users enter email addresses separated by semi-colons, you'd have it pretty easy. Or, you can give them a repeating field - see
this post for ideas on working with a double eval.
Hope this helps!