Rainbow Sheet

Record colour-coded behaviour observations per participant with antecedent, consequence, duration and intensity.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Marketing

Tables

Participants, Observations

Fields

23

Views

grid, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Participants

12 fields · 4 sample rows

  • Participants (Grid)
ParticipantTextParticipant IDAutonumberDate of BirthDateAgeFormulaGroupSingle selectGuardianTextGuardian PhonePhoneGoalsLong textObservationsLink to another tableObservation CountCountAvg IntensityRollupLast ObservedRollup
Aarav M.P-0019 Apr 20179Morning groupNeha Mehra+91 98111 22334Increase on-task time to 15 minutes; requesting breaks verbally.17 Nov 2026 00:00, 18 Nov 2026 00:0022/518 Nov 2026
Lily T.P-00222 Sep 20188One-to-oneMark Thompson+1 312 555 0187Reduce elopement during transitions.17 Nov 2026 00:00, 19 Nov 2026 00:0022/519 Nov 2026
Zoya K.P-00315 Jan 201610Afternoon groupFarhan Khan+91 99876 54321Peer play and turn-taking.18 Nov 2026 00:0012/518 Nov 2026
Ethan R.P-00430 Jun 20197Home programmeSophie Russo+61 4 1234 567819 Nov 2026 00:0014/519 Nov 2026
Field details
Participant · Text
Participant ID · Autonumber
Date of Birth · Date
Age · Formula
IF({Date of Birth}, DATETIME_DIFF(TODAY(), {Date of Birth}, 'years'), BLANK())
Group · Single select
Morning group, Afternoon group, One-to-one, Home programme
Guardian · Text
Guardian Phone · Phone
Goals · Long text
Observations · Link to another table
Links to Observations
Observation Count · Count
Avg Intensity · Rollup
avg of Intensity via Observations
Last Observed · Rollup
latest of Observed At via Observations

Observations

11 fields · 6 sample rows

  • All observations (Grid)
  • Calendar (Calendar)
  • Record an observation (Form)
  • Patterns (Dashboard)
Observed AtDateParticipantLink to another tableBehaviourSingle selectSettingSingle selectAntecedentLong textConsequenceLong textDurationDurationFrequencyNumberIntensityRatingObserverTextNotesLong text
17 Nov 2026Aarav M.Green — on taskClassroomGiven a puzzle with a visual timer.Praise and token.0:1211/5Ms. Kavita
17 Nov 2026Lily T.Yellow — elopementTransitionBell rang for lunch.Redirected with picture schedule.0:0123/5Mr. Daniel
18 Nov 2026Zoya K.Blue — social interactionPlaygroundPeer invited her to play.Joined game for 5 minutes.0:0512/5Ms. Kavita
18 Nov 2026Aarav M.Purple — verbal outburstLunchPreferred snack unavailable.Offered choice of two snacks.0:0033/5Mr. Daniel
19 Nov 2026Ethan R.Red — aggressionHomeTablet time ended.Calm-down corner, then first/then board.0:0214/5Sophie Russo
19 Nov 2026Lily T.Green — on taskTherapy roomShort task with choice of reward.Earned bubbles break.0:1011/5Mr. Daniel
Field details
Observed At · Date
Participant · Link to another table
Links to Participants
Behaviour · Single select
Red — aggression, Orange — self-injury, Yellow — elopement, Green — on task, Blue — social interaction, Purple — verbal outburst
Setting · Single select
Classroom, Playground, Lunch, Transition, Therapy room, Home
Antecedent · Long text
Consequence · Long text
Duration · Duration
Frequency · Number
Intensity · Rating
Observer · Text
Notes · Long text

Form view “Behaviour observation” asks for: Observed At, Participant, Behaviour, Setting, Antecedent, Consequence, Duration, Frequency, Intensity, Observer, Notes.

Rainbow Sheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates