Wiki

What Are Fields?

What are Fields

Fields are the way all of your data is organized inside RLD.

Think of fields as the columns inside a spreadsheet, and the records inside your database as the rows.

Each row has a value for each column in the spreadsheet just like records have a value for each field inside RLD.

RLD One	Spreadsheets	Sql/Databases
Field	Column	Column
Record	Row	Row/Record

Field Types

Number

• EXs:
  • 1
  • 23.9
  • 3.1415926535897
  • 5,000,037,829.0

Text

• EXs:
  • "Hello World"
  • "Fast"
  • "The only thing we have to fear is fear itself."

Time

Times in RLD are in milliseconds and they are stored as the number of
milliseconds since January 1st, 1970 (the Linux Epoch). This makes them
agnostic of time zone.

Note: for forms/input apps this also makes them independent of the
time in which the form was opened so you can get a much larger amount of
info out of them.*

• EXs:
  • 1704835625890
  • 1894483620000
  • 965161620000
• If you approximatley converted these times to calendar dates (month/day/year):
  • 1/9/2024
  • 1/12/2030
  • 8/1/2000

Position

Position tracks a position on a position map as two numbers between 0 and 1.
The first number is the X position and the seconds number is the Y position.
This type is only generated by Input Forms and is only used by Position Map
graphs.

• EXs:
  • (0.00,0.00) <-- This is the top left corner
  • (1.00, 0.00) <-- This is the top right corner
  • (1.00, 0.00) <-- This is the bottom left corner
  • (0.50, 0.50) <-- This is the middle

Location

Location stores latitude and longitude.

• EXs:
  • (30.264980, -97.746597) <-- Austin, Texas
  • (48.135124, 11.581981) <-- Münich, Germany

Arrays

Arrays are lists of a specific field type. In the RLD wiki we denote these using [ ],
and in the RLD One Platform we denote these using bars above and below the data type:

• EX Number Array:

  • [4,8,15,16,23,42]

• EX Text Array:

  • ["Be", "yourself;", "everyone", "else is already", "taken"]

• EX Time Array

  • [1704835625890, 1704835635560, 17048366543210, 1894483620000]

---