Tables

How to manually create or edit table records
Manually editing or deleting table records is easy. Navigate to Tables and click View from the drop down. Common reasons to update a record include: changin...
Mon, 15 Feb, 2016 at 10:51 AM
Adding a Custom Date Formula Field on a Table
To generate and refer to a specific date on a Table in relevance to the current date, you can set up a Formula Field. You can generate a date (e.g...
Mon, 13 Apr, 2015 at 1:51 PM
One Time Import
To quickly setup a one time import click the "Import Data" button on the Tables home page; however, ROI recommends that you use the flat file impo...
Wed, 27 Jan, 2016 at 4:02 PM
Unable to Add Default Value to Existing Field on a Table
The Problem: You updated a default value on an existing column in a ROI  table. When you’re trying to save it, you get an error about NULL values: ...
Fri, 7 Jul, 2017 at 3:00 PM
Commonly Used Formula Fields
Using ROI’s formula fields, a simple SQL query can easily shape field information. Various date formats are a common way of using formula fields to get a de...
Fri, 20 Apr, 2018 at 2:22 PM