16.5 Uploading a File to a BLOB Column

Use a File Upload page item to let users provide a file to your app. When you use it as part of a Form region, the combination automates creating, editing, and deleting the row with the file BLOB column.

Configure the Form region source with the table or view name, then set the File Upload page item's source to the BLOB column. Other declarative settings control what end users see when uploading the file.

• Selecting an Open Job to Add Referral
  Upload a candidate's CV from a modal form linked to the selected open job.
• Passing Client-Side Data to Dialogs
  Construct appropriate dialog links to pass dynamic client-side values to a dialog, with or without server-generated checksums.
• Configuring File Upload to a BLOB Column
  Configure a File Upload item to store an uploaded file in a BLOB column with related metadata.
• Ensuring the Automatic DML Process
  Set up the automatic DML process and submit button with database action to insert the uploaded file row.
• Controlling File Upload Item Behavior
  Use the properties in the Display section to control your end users' experience when uploading a file.
• Submitting a Job Referral CV
  Walk through the referral CV upload flow, from selecting a PDF to refreshing the calling page.