Pass Uncommitted Field Values from One Form to Another

Ask for Help
1

I’m trying to pass an Invoice # value from one form to another in Glide.

I have a Daily Delivery Sheet screen (based on the Daily Delivery Sheet table) with a Form Container that includes an Invoice # field. At the bottom there’s a button that uses Show Form Screen to open a separate form attached to the Invoice-Images table.

I need the Invoice # field on the second form to automatically default to the Invoice # the user entered on the first screen. The challenge is that the main form hasn’t been submitted yet, so the value isn’t saved in the row.

I can’t simply add an Image Picker to the main screen because I need a one-to-many relationship — one delivery row can have multiple images (taken with the camera). That’s why I’m using a separate Invoice-Images table and form.

The app is public (no login). I’ve tried workflows, Set Column Values, helper tables with user-specific columns, and Show Edit Screen, but haven’t been able to make the value pass correctly.

Any suggestions for the cleanest way to carry this unsaved Invoice # value to the second form?

2

On entry to the Daily Delivery Sheet screen, you can add a step to set a unique ID for your instance of the form.

Use that unique ID as a special value for the Invoice-Images table, then those will be able to be linked when you submit your Daily Delivery Sheet form with the assigned unique ID.