Forms.

Forms are made using an easy drag and drop interface. You simply map a form field to a column and each time the form is filled out it will either add a new record to the table, or update an existing. You can set a form to be open to anyone, specific people or anyone in your organisation. Forms can be easily embedded on your website or shared with URL.

Form Designer

  1. Save the Form. This will make it live
  2. Bring up the settings dialog
  3. Close the designer
  4. Field List (drag from here to 6)
  5. Header. Click on this to change the title
  6. View only - Not functional in designer

Creating a form

  • Open the table that relates to
  • Click the Forms tab
  • Click Add Form
  1. The title of the form. Just a descriptive name for your own reference. ie. New Annual Leave Request
  2. The identifier makes part of the url. Ideally this should be easy and descriptive. ie. leave
  3. What to do with the data. Create a new record in the table or update an existing
  4. Permissions for who can use this form. Everyone (public), Internal, Specific

Form Permissions

New or Update Record

Label

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The Map To is what column this field saves to

Textbox

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The Map To is what column this field saves to

Number

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The Map To is what column this field saves to
  4. The minimum number that can be put in this form
  5. The maximum number that can be put in this form.

Yes/No

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The style to display.
  4. Start this as

Radio

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The Map To is what column this field saves to
  4. The minimum number that can be put in this form
  5. The maximum number that can be put in this form.

Range Selector

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The Map To is what column this field saves to
  4. The minimum number that can be put in this form
  5. The maximum number that can be put in this form.

Date/Time

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The style to display.
  4. Start this as

Upload

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The style to display.
  4. Start this as

People

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The Map To is what column this field saves to
  4. The minimum number that can be put in this form
  5. The maximum number that can be put in this form.

Pen

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The Map To is what column this field saves to
  4. The minimum number that can be put in this form
  5. The maximum number that can be put in this form.

Accept & Agree

  1. The title to place above the field
  2. A description field. This is used when the client hovers over the control
  3. The Map To is what column this field saves to
  4. The minimum number that can be put in this form
  5. The maximum number that can be put in this form.