Skip to main content

Worksheet Designer

Worksheets are the forms, lists and documents your agency builds for itself: a rig check, an incident report, a pre-plan, a sign-up sheet. The Worksheet Designer is where you make them.

Where: ModulesWorksheet Designer

Worksheet Designs list123
Designs assigned to a module are at the top. Templates follow.

Find a design 1​

Type in Find, or narrow by Type, Module and Sort. Designs are grouped under Assigned to module and Module templates. An arrow beside a design means it has nested designs under it, for example an index with the form it opens.

The columns 2​

ColumnMeaning
ModuleThe app tile that opens this design.
TypeIndex (a list of entries), Form (something to fill in), Document or Pdf.
StatusPublished is live in the apps. Pending has changes that are not published yet.

Make or change a design​

Click + 3 for a new design, or click an existing one. Its settings open on the right.

Bulk PDF, beside the +, takes a stack of PDF files and turns each one into a worksheet design.

Edit Worksheet Design panel123456
A design's settings.
  • The design you clicked 1 is highlighted.
  • Design Name, Design Type and Navigation Title 2: the name in this list, whether it is an Index, Form, Document or Pdf, and the title shown at the top of the screen in the apps.
  • Used for 3: An app module, then pick the Module, or Incidents.
  • Permissions 4:
SettingMeaning
Allow editingEntries can be changed after they are saved.
Editable by defaultA new entry opens ready to type in.
Allow sharingMembers can share an entry with other people.
Share publiclyPeople outside the agency can open and fill in the form through a link.
  • Display 5:
SettingMeaning
Open as modalOpens on top of the current screen, not as a new screen.
Available offlinePhones keep it for use with no signal.
Allow screenshotMembers may take screenshots of it.
Allow lockingAn entry can be locked so it cannot be changed any more.
  • Save Changes 6 saves these settings.
Lower part of the design panel123
Scroll down in the panel.
  • Open Form Builder 1 opens the builder, where you lay out the form itself.
  • Auto Generate PDF 2 makes a PDF template from this design. See PDF Builder.
  • Delete Design 3 removes the design.

The Form Builder​

The builder opens in its own window.

Form Builder12345
The Form Builder.
  • The rail on the left 1 switches between Elements, AI Designer, Config, Push, Submissions and QR code.
  • Elements 2: click an element to add it to the form.
  • The form 3: sections with the elements inside them. The arrows on the right move a row up or down, and the red bin deletes it. REQ marks a field that must be filled in.
  • View as the apps see it and View JSON 4: a preview, and the raw design for support.
  • Save Design keeps your work without changing what members see. Save & Publish 5 sends it to the apps.

The elements:

GroupElements
Section HeaderStarts a new section. Most elements go inside a section.
Section elementsAuto Complete, Button, Checkbox, Date Picker, Divider, Dropdown, File Upload, Location, Paragraph, Scan list, Text Input.
StandaloneApproval, Chart, Coordinates, Free Form Section, Signature, Stopwatch Timer, Upload Section, User Info, Vehicle Info. These sit on their own, outside a section.

One element's settings​

An element selected in the Form Builder123
Click an element in the form to see its settings.

Click an element in the form 1.

  • Element Properties 2 change with the kind of element. For a Dropdown: the Label, Required, Disabled, Multiple Selection with a limit, and the list of Options, each with a pencil to change it and a bin to remove it.
  • Element Configuration 3:
    • Dynamic Options fills the choices from a live list.
    • Logic Tag gives the field a name that other parts of REDENES can refer to.
    • Property Data Fill fills the field from parcel data once the form has a location.

AI Designer​

AI Designer12
AI Designer.

Describe the form you want, or the change you want, in the box and click Send 1. Import from PDF 2 reads a PDF form and builds the elements from it. Check the result in the form before you save.

Config​

Config panel1234
Config.
  • Module 1: the module this form belongs to. It follows that module's permissions.
  • Form Settings 2: Used in incidents, whether entries can be created from an email or a text (Input / create from), and the Allowed sources an element may be filled from: parcel data, a map reference, a CHP, SARTopo, Tablet Command or Active Alert link, or another worksheet.
  • Integration Wiring 3 shows whether the form is connected to an email or text input.
  • External Sources 4 ties the form to live data from another system.

Push​

Push Notifications panel1234
Push.

The notification text for this worksheet. There is one block 1 each for Created, Updated and Shared. Tick Enabled 2, type a Title and Body, and use Insert field 3 to put a value from the form into the text. Preview shows the result. Click Save Push Config 4.

Submissions​

For forms that are shared publicly.

Submissions panel123456
Submissions.
  • Send a submission email 1 emails the person after they submit the form.
  • When it is sent 2: on the first submission, again when they update it, or when a button on the form is clicked.
  • Subject and Body 3. Auto-Generate Subject & Body 4 writes a thank-you for you to review.
  • Link In The Email 5 lets the person view or update what they sent, and you can attach a PDF copy of their answers.
  • Received Submissions 6 lists what has come in.

These settings save with the design.

QR code​

QR code screen1234
QR code.

How the form fills itself in on the phone.

  • Fill from where I am 1: rules that fill fields from the map area or agency location the phone is in. Try it tests a rule.
  • Scan into this form 2: buttons on the form that scan a QR tag, such as a rig or a saw, and fill fields or add a row for each thing scanned.
  • QR codes that open this form 3: make a code to print and stick wherever the form is filled in. A code can also fill in values of its own.
  • Save QR settings 4. They reach the phones when the form is published.

Check it before you publish​

View as the apps see it12
View as the apps see it.

View as the apps see it shows the design as a Phone or Tablet 1 gets it. You can try the fields 2. Nothing is saved.

When it is right, click Save & Publish. Until then members keep seeing the last published version.

Do not start from a blank page

The Worksheet Warehouse has ready-made designs, including the ICS forms, that you can copy and adjust.