EasyDB
Your Cart: Your CartItem(s):
0
$0.00

Main Suite-Current: v2.0

Now w/ Smarter Functionality, Faster Setup & Connection Helper Tools

FreeForm Pro-Current: v2.0

View Multiple Sets of Content Simultaneously, User Roles for Record & Field Permissions, Inline Editing, Auto Image/File Uploader & Link Creation, Prefiltered Content & Moving Content Into Other Stacks ... and Lots More

Download ~ Free EasyDB Lite Main Suite
Note: 'EasyDB Lite' will appear below the published content. It contains all the functionality of the paid EasyDB Suite. Create any number of databases and tables which can have up to 15 records each.

FREE 1-on-1 SUPPORT
We can Screenshare to get you up & running fast.

Download ~ Free EasyDB FreeForm Pro
Note: 'EasyDB FreeForm Pro Lite' will appear below the published content. It contains all the functionality of the paid EasyDB FreeForm Pro. Create any number of databases and tables which can have up to 15 records each.

FREE 1-on-1 SUPPORT
We can Screenshare to get you up & running fast.

RapidWeaver + EasyDB Suite = Dynamic Duo

EasyDB Logo

Yes - I Said DYNAMIC - It's pushing RapidWeaver to a whole new level.
DYNAMIC CONTENT on your pages - no matter what kind of site you may have.

The EasyDB Suite brings full CRUD (Create Read Update Delete) editing capability to all your dynamic content.
Plus a ton of additional functionality.

So what can EasyDB do for you?


Do you display more than a handful of content, products, services or people ?


Do you need to give visitors a way to easily find what they are looking for ?


Do you want to layout dynamic content in a concise table or create a custom layout on the page ?


Do you need an easy way to manage large amounts of content, all done within your website ?

What's Coming Next?


 Data Backup - Coming This Summer

In a Nutshell: The EasyDB Suite Provides Easy Setup of Dynamic Content.

• Credentials easily sets up access to your database along with EasyDB user credentials.


• Database allows you to create a database table and fields without ever having to use complicated 3rd party tools or touch code.


• Login provides secure access to easily edit your content.


• TextGrid provides an easy way to layout an unlimited number of tables with all your content.


• FreeForm allows you to layout a single set of content anywhere on the page.


• FreeForm Pro (NEW) addon that allows you to layout unlimited sets of content anywhere on the page, create user roles for record & field permissions, inline editing of all content, auto image/file uploader & link creation, prefiltered content settings and field macros to move content into other stacks.

Go DYNAMIC - Use The EasyDB Suite


EasyDB supports all modern desktop browsers, IE9+, iOS & Android.

MySQL Database

Automatic Setup & Configure Your Data

FreeForm/Pro

Filter & Edit Content Everywhere (Pro)

TextGrid

Create Filterable & Editable Tables

Main Suite | $35 | Add to Cart
FreeForm Pro | $35 | Add to Cart

(FreeForm Pro Requires the Main Suite)

Previews

FreeForm Pro (NEW)

EasyDB FreeForm Pro Preview

This is an example of an eyewear company and a display of all their current collections for the year. The related store page (detail page) is also dynamic and can be seen when clicking the link icon in the thumbnails. Due to trends, new styles are released throughout the year and static pages would be too difficult to maintain.

EasyDB's FreeForm Pro is the perfect solution:  Easy to setup & maintain and the data is integrated into a nice gallery/lightbox layout


Want to see how they maintain the information?  No problem:  The Preview resets every 10 minutes, so don't worry about messing anything up.
Experiment w/ anything you wish. Login Info:  User: glasses   Password: fashion

EyeWear Collections
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
  • xxxgdatasetyyy1yyytitlezzz
    xxxgdatasetyyy1yyytitlezzz
    xxxgdatasetyyy1yyyimg_captionzzz
  • xxxgdatasetyyy2yyytitlezzz
    xxxgdatasetyyy2yyytitlezzz
    xxxgdatasetyyy2yyyimg_captionzzz
  • xxxgdatasetyyy3yyytitlezzz
    xxxgdatasetyyy3yyytitlezzz
    xxxgdatasetyyy3yyyimg_captionzzz
  • xxxgdatasetyyy4yyytitlezzz
    xxxgdatasetyyy4yyytitlezzz
    xxxgdatasetyyy4yyyimg_captionzzz
  • xxxgdatasetyyy5yyytitlezzz
    xxxgdatasetyyy5yyytitlezzz
    xxxgdatasetyyy5yyyimg_captionzzz
  • xxxgdatasetyyy6yyytitlezzz
    xxxgdatasetyyy6yyytitlezzz
    xxxgdatasetyyy6yyyimg_captionzzz
  • xxxgdatasetyyy7yyytitlezzz
    xxxgdatasetyyy7yyytitlezzz
    xxxgdatasetyyy7yyyimg_captionzzz
  • xxxgdatasetyyy8yyytitlezzz
    xxxgdatasetyyy8yyytitlezzz
    xxxgdatasetyyy8yyyimg_captionzzz
  • xxxgdatasetyyy9yyytitlezzz
    xxxgdatasetyyy9yyytitlezzz
    xxxgdatasetyyy9yyyimg_captionzzz

TextGrid

EasyDB TextGrid Preview

Kurt is the president of a VW club & this is an example on how to show all the members of the club and also let them filter & sort through all the available information.  Every week new members are joining and he definitely didn't want to keep building static pages, as that would be too time-consuming.

EasyDB's TextGrid is the perfect solution: Easy to setup & maintain his members in a table layout


Want to see how Kurt maintains the information?  No problem:  The Preview resets every 10 minutes, so don't worry about messing anything up.
Experiment w/ anything you wish. Login Info:  User: kurt   Password: coolcars

 
     

FreeForm

EasyDB FreeForm Preview

Below is an example of Kurt's VW club content being placed on the page, wherever he wanted it.
The simple pagination controls allow you to see one record at a time.
EasyDB's FreeForm is the perfect solution:  Gives you control over the layout of all your content

Image of classic VW

Owner

Location

,

Model


For Sale


Main Suite | $35 | Add to Cart
FreeForm Pro | $35 | Add to Cart

(FreeForm Pro Requires the Main Suite)

Feature Comparison

FreeForm
TextGrid
FreeForm Pro
EasyDB Suite
Main Suite
Main Suite
Addon
RW: 6/7/8, Stacks: 3.5/4, PHP: 5.4+
Table Layout
Unrestricted Content Layout
Page Navigation: Next & Previous Buttons
Page Navigation: Page Buttons/Start/End
Wrapping Tags/Characters
Field Types: Text/Integer/ Floating/Date/Time/ Money/Email/Image/Link
Integer Replacement
Custom Field Formats: Checkbox/Color/Rating/ Progress Bar
Content Styling
Content Filtering/Sorting
Content Editing w/ Login: Add/Edit/Delete Records
Modal Field Editing
Input Validation
Data File Import/Export
Responsive/ Mobile Support
Language Support
Setup Help Alerts & Built-In Docs
Supports Modern Browsers, IE10+, iOS & Android
Multiple Filters
Preset Filter Controls: Field/Filter/Value/Sort
Field Exclusion in Filter Dropdowns
Detail Page Support
Move Content (Macros) into 3rd Party Stacks
Field Hide Controls: When Read Only/Non Editable
Auto Image & File Uploading
Image & File Size Limits
On-line User Admin Panel
User Roles: Admin/User
User Record Access: All Records/Only User's Records
Auto-Assign User Record Access
Manual-Assign User Record Access
User Field Permissions
On-line FreeForm Edit Panel
In-Line Editing of All Displayed Content
Custom Gallery Skins
New Fld. Default Text/Empty Fld. Text/Hidden Fld. Text
Text Cleanup: Sentence Spacing/Text Cleanup/ Word Count Limit
Automatic Hidden Content if Permissions Not Allowed
Key Toggle Visibility of Login Buttons & Admin Panels
Move: Filters/Page Navigation/Login/Logout

EasyDB Showcase

Alt text
Alt text
Alt text
Stacks Image 3905

Note:  The EasyDB license is for one domain (subdomain use is ok), please buy separate copies of the main suite & any addons for each domain or each physical location it's used at.

Over 2 years of continuous work has gone into the EasyDB Suite & it's a GREAT value for all the provided dynamic capabilities.

- Thanks,  Bill

Main Suite | $35 | Add to Cart
FreeForm Pro | $35 | Add to Cart

(FreeForm Pro Requires the Main Suite)

Go to Videos

About

EasyDB logo

FreeForm Pro

FreeForm Pro allows you to layout content anywhere on the page. As most users of RapidWeaver expect this when using stacks, the EasyDB FreeForm Pro stacks now allow you to create any type of custom layout. In a nutshell: an EasyDB FreeForm Pro stack allows the layout of multiple sets of data wherever you wish. Custom multi-filter capability is now available to find content with ease. User permissions can now be assigned to individual users to control what content can be seen and edited. Advanced in-line editing features are now a part of the new admin interface. In addition, content can now be assigned inside of 3rd party stacks by placing simple field macros within text input controls.

Note: The FreeForm Pro stacks are a paid addon to the EasyDB main suite which is required and should be purchased for every domain and physical location they are used at.

Installation

Upon downloading the zip file from your download email, unzip it by double-clicking on the zip file, which should create an EasyDB folder next to the zip file.

If double-clicking the zip file causes Archive Utility error: Unable to expand: (Error 1 - Operation not permitted.) First delete the zip as it may be corrupted and try downloading the zip file again from your download email.
If you still have problems: do a Get Info on the zip file by selecting it and pressing Command + I. The 'Open with' should be set to the Archive Utility.app. If not, change it, shut down and restart and try double-clicking the zip file again.

If it still doesn't work, then open Terminal from Applications/Utilities or you can use the Mac search (magnifier icon) at the top right of the menu bar and start typing Terminal. It will appear, click on it to open Terminal. In Terminal type unzip followed by a space; drag & drop the zip file onto the Terminal window and the name & path should be completed for you. Press enter/return and the file will be unzipped. If there are no errors, the unzipped EasyDB folder should be in your Home folder (Users/Your name).

To install the EasyDB suite of stacks, start up RapidWeaver and drag each stack from the EasyDB folder onto the RapidWeaver icon in the dock. You should see an informational screen indicating that stack will be installed. After you have installed all the stacks, quit RapidWeaver and then restart RapidWeaver. Since the EasyDB suite are all stacks, open up the main Stacks pane and in the search input type 'EasyDB'. A list of all the EasyDB stacks will be shown.

If you have used the Lite version of the suite, you will need to replace it with the paid versions. After you have installed the paid versions and have copied the settings over, you can go the addons folder and delete the demo stacks: In the main menu, go to RapidWeaver > Manage Addons. Then select the Stacks tab and search for 'EasyDB' and then delete any stacks with "Demo" in the name. Any data that you have already created in a table will be available once the new stacks have been set up.

Layout

FreeForm Pro in Edit Mode
Note: Prior to laying out EasyDB FreeForm Pro stacks, you will need to set up the EasyDB Credentials Setup stack (Only ONE per project), the EasyDB Database Setup stack, as well as, the EasyDB Login Setup stack on a separate page. Explanation of how to do this can be found in the videos from the initial release.

Drag an EasyDB FreeForm Pro stack onto the page. In the EasyDB FreeForm Pro pane to the right, you will see all the controls for this stack. Uses Dataset, Field Name, Field Type & optional Tag Wrap will be displayed in the stack in edit mode, once those controls are set.

If a 3rd party stack has a dropzone, then you should be able to place an EasyDB FreeForm Pro there. If not, there are several other options for placing dynamic content. This will be discussed later in the move field content section.

Basic Content Info

Basic Content Info

This section explains the 'Uses Dataset Nm', 'Dataset Number', 'Uses Field Name' and 'Field Display Type' controls.
Uses Dataset Nm: This is a unique name given to all FreeForm Pro content that is related to each other. Even though you probably haven't set up EasyDB FreeForm Setup Pro yet, this will be used in it's 'Dataset Nm'. An example of a dataset name could be a unique name that represent all the images in a gallery and all their related fields that are being brought in. The dataset name can't contain any spaces, single or double quotes, xxx, yyy or zzz. Use lowercase, alpha numeric only.
Dataset Num: Enter a relative row number (record) from the dataset to pull content from. This is a relative number for a related set of content displayed on the screen. Typically, a dataset num would represent a set of relted fields such as an image, a title and alt text, etc. You can have as many dataset nums (records) as you wish on the page at a time.
Uses Field Name: This is the field name from EasyDB Database Setup to use. The field name can't contain any spaces, single or double quotes, xxx, yyy or zzz. Field Name selected will be displayed in edit-mode w/in the stack for your convenience.

Note: If 'Fld. Display Type' is set to 'Image', then Uses Field Name control will be hidden and 'Std. Img. FldName' should be used instead.

Fld. Display Type: A content type of 'Text', 'Integer Number', 'Floating Number', 'Date', 'Time', 'Money', 'Email', 'Image' or 'Link' can be selected. This must generally match the field type set up in EasyDB Database Setup. The exceptions are:
General text: 'Small Text' or 'Large Text' in DB would match to 'Text' in FFP
Currency: 'Floating Number' in DB would match to 'Money' in FFP
'Small Text' in DB could match to either 'Email', 'Image' or 'Link' in FFP.
Fld. Display Type selected will be displayed in edit-mode within the stack for your convenience.

Field Type Details

This section explains the various control details for each field type.

Text

No detail controls at this time.

Integer Number Controls

Integer Number


Thou. Separator: Sets a character symbol to use for the thousands separator character, if the number is big enough.
Enable Integer Replacement: Enable to allow integer replacement with custom text. This is often used to display a word or symbol in place of an integer stored in the database. An integer of one or greater will use the '1- Replacement' and zero will use the '0-Replacement'.
Enable Font Awesome: Enable to allow icon replacement with a font awesome icon. Use fa name only, Ex: fa-magic
1-Replacement: Enter the text to replace integer of one or greater. The replacement can't have any single or double quotes.
FA1 Color: The color for font awesome-1 replacement icon.
0-Replacement: Enter the text to replace integer of zero. The replacement can't have any single or double quotes.
FA0 Color: The color for font awesome-0 replacement icon.

Floating Number Controls

Floating Number


Thou. Separator: Sets a character symbol to use for the thousands separator character, if the number is big enough.
Decimal Point: Sets a character symbol to use for the decimal point.

Note: Floating number fields are set to field type of Double and can support up to 16 total digits of precision. This total includes any digits after the decimal point.
Date Controls

Date


Date Format: Select the date to display in either mm/dd/yyyy or dd/mm/yyyy format.

Time Controls

Time


Time Format: Select the time to display in either 12-hour (am/pm) or 24-hr format.

Money Controls

Money


Currency Symbol: Set the character to use for the currency symbol.
Curr. Position: Select the currency symbol position to display either before or or after the number.
Thou. Separator: Sets a character symbol to use for the thousands separator character, if the number is big enough.
Decimal Point: Sets a character symbol to use for the decimal point.

Email Controls
Email Prompt

Email


Email(color): Set the email text default color.
Email Hover(color): Set the email text hover color.
Email Text Fld: Enter email display text field from EasyDB Database Setup. This text is displayed instead of a real email to prevent spam bots from harvesting emails. Don't use email address here, just enter a field that will contain those. An example of proper email text fld values within a table might be 'Bill's Email' or 'Contact Me' or 'Design Dept'. The email text field name can't contain any spaces, single or double quotes.
When viewing an email link in read-only mode, modern browsers may show an alert prompting to allow an email. Simply click the allow button and a new email will open in the default email app.

Image Controls

Image


Std. Img. FldName: Enter an image field name from EasyDB Database Setup. There are three image field names. This field is required as a minimum, but the other two are optional. The standard image field name can't contain any spaces, single or double quotes, xxx, yyy or zzz.
2x Sm. FldName: Enter an image field name from EasyDB Database Setup. This is for a small 2x sized image (max width 1536px), but is optional. The 2x small image field name can't contain any spaces, single or double quotes, xxx, yyy or zzz.
2x Lg. FldName: Enter an image field name from EasyDB Database Setup. This is for a large 2x sized image (min width 2048px), but is optional. The 2x large image field name can't contain any spaces, single or double quotes, xxx, yyy or zzz.
Alt. Text Fld: Enter image alternate text field from EasyDB Database Setup. The alternate text field name can't contain any spaces, single or double quotes, xxx, yyy or zzz.
Image Upload: Select the image upload location during editing as either 'Resources' or 'Custom URL'. Select 'None' to not allow uploading.
Image Folder: Enter the Resources subfolder to save images to. Type the folder name only, no slashes. Leave blank if saving images in root of Resources folder.
Custom URL: Enter the custom url to save images to. Use absolute url and should be on the same site.
Max Image Size: Enter the max file size limit when uploading images, units MB.
Link Image: Enable to apply a link to the image. Note: (Optional)
Image Link Fld: Enter an image link field name from EasyDB Database Setup to use. Can't contain spaces, single or double quotes, xxx, yyy or zzz.

Link Controls

Link


Link(color): Set the link text default color.
Link Hover(color): Set the link text hover color.
Link Text Fld: Enter link display text field from EasyDB Database Setup. This field will contain the text that is displayed for a link. The link text field name can't contain any spaces, single or double quotes, xxx, yyy or zzz.
Link to Non-Image File: Enable if linking to a non-image file that is to be viewed/downloaded, Ex: .pdf, .zip
File Upload: Select the file upload location during editing as either 'None', 'Resources' or 'Custom URL'.
File Folder: Enter the Resources subfolder to save files to. Type the folder name only, no slashes. Leave blank if saving files in root of Resources folder.
Custom URL: Enter the custom url to save files to. Use an absolute url and should be on the same site.
Max File Size: Enter the max file size limit when uploading non-image files, units MB.

Move Field Content

Move Field Content

Move Field Content: Enable to move content to a new location. This is useful when trying to move plain text characters into the sidebar or extra content areas or when injecting content into third-party stacks.
Hide Field: Enable to hide the field in Read-Only mode
Hide Field if Not Editable: Enable to hide the field in Edit Mode if not editable

Std Field Macro

When 'Move Field Content' is enabled, a field macro button will be displayed in the EasyDB FreeForm Pro stack. Right-click on the field macro button and you should see macro text appear and the text highlighted. At the same time, a contextual menu will appear, then select 'Copy' and then paste this text where you want the content to be moved (typically into a 3rd-party sidebar control).

Image Field

Image Field Macros

For image fields, there can be up to four different macros displayed, depending on which fields are used.

Image Field Macros Revealed

For image fields macros, try right-clicking on the lowest macro to reveal all of the macros for that field.
 

When placing a macro on the page, I have provided the free DropWrapper stack to quickly facilitate the creation of a wrapper. If you won't be styling the contents with css, just set 'Tag' to 'Span' and 'Attribute Type' to 'None', which creates a clean span for the macro & the moved content to be placed into. If you wish to style content, then you may want to set 'Attribute Type' to 'ID' or 'Class' to allow styling. The field macro can also be pasted into a text or html stack, but those create a lot of additional styling and code. Please note, the moved content will bring in wrapping spans and optional styling tags, but they are styled to be inline, so you could wrap the macro in other static text, if you so desire.
Macros can be pasted into 3rd-party stack sidebar controls, if they expect plain text.

Images

When trying to move images into 3rd-party stacks there are several options:

1) If they offer a drop zone for images you can try to drop an EasyDB FreeForm Pro stack in there. This is assuming that they allow other stacks in the dropzone.
2) Macros can be pasted into 3rd-party stack sidebar controls, if they expect plain text. Ex: If a 3rd-party stack has a sidebar control for the image path, then you could paste a field macro into that control. Other attributes like alt tag, title, date, etc can also be added using a field macro.

Advanced options - only attempt if you are comfortable changing code:
It is possible to modify the 3rd-party stack to allow EasyDB inside of it. If you would like to try, make a copy of the 3rd-party stack, then right-click on it in the Finder and select 'Show Package Contents' and look for the template.html file, open it in a text editor, such as BBEdit. Search for 'slice' and inside of that you will find -addTypes="...". Inside of the double-quotes, at the end, add a comma and a space then type: com.stackits.easydbfreeformpro Save and then shut down and restart RW and see if it allows an EasyDB FreeForm Pro stack to be dropped in. You will still need to publish to see if it really works. If not, then be sure to replace the 3rd-party stack w/ the copy you made.

Depending on how the stacks are loaded and in what order, the 3rd-party functions may be running before the images are loaded, which can cause functionality to be broken. This can sometimes be fixed by changing the 3rd-party script.js file. Be sure to first make a copy of the stack before attempting this:
Change the line that says:
$(document).ready(function() {
     to
$(window).on('load', function() {

Show FreeForm Pro Help

Show FreeForm Pro Help

Enable to show in-editor help on various settings.

Styling Details

Styling Details

This section explains the: 'Opt. Tags', 'Heading Tag', 'Enable Beginning Characters', 'Begining Char', 'Enable Ending Characters', 'Ending Char', 'Content Styling', 'Enable Text Cleanup', 'Use Custom Google Font', 'Cust. Google Fnt' & 'Google Wt' controls.
Opt. Tags: If you would like to add a wrapping tag around the content, then select one of the buttons. Only one of the buttons can be used at a time. The 'H' Button enables a heading tag. The Horizontal Lines button enables a paragraph tag. The 'B' Button enables a bold tag. The 'I' Button enables an italic tag. The Tag Wrap selected will be displayed within the stack in edit-mode for your convenience.
Heading Tag: Select the heading tag to use as either 'Heading 1', 'Heading 2', 'Heading 3', 'Heading 4', 'Heading 5' or 'Heading 6'.
Enable Beginning Characters: Enable to apply characters before the FreeForm Pro content. This is useful to insert small amounts of text or small html snippets before.
Beginning Char: Enter the beginning characters of text or html.
Enable Ending Characters: Enable to apply characters after the FreeForm Pro content. This is useful to insert small amounts of text or small html snippets after.
Ending Char: Enter the ending characters of text or html.
Content Styling: Enable to apply additional styling to FreeForm Pro content.
Text Font: Select the font to apply to FreeForm Pro content as either 'EasyDB Default' (Source Sans Pro), 'Theme Default' (Inherited), 'Arial Black', 'Cooper Black', 'Courier New', 'Cursive', 'Futura', 'Georgia', 'Geneva', 'Gill Sans', 'Helvetica', 'Helvetica Neue', 'Hoefler', 'Impact', 'Lucida Console', 'Lucida Grande', 'Myriad Pro', 'Palatino', 'Rockwell', 'Times New Roman', 'Trebuchet MS' or 'Verdana'.
Text Size: Set the text font size.
Text LineHt: Set the text line height.
Text Color: Set the text color. This does not affect email & link text colors & their hover colors, instead use the dedicated field controls.
Enable Text Cleanup: Enable to apply text cleanup to text fields during editing. Provides capitalization of first word of a sentence, lowercase all other words unless word is escaped w/ back slash '/' at beginning of word and period at sentence end. Note: this must be enabled to allow word count limit functionality set in FreeForm Setup Pro.
Use Custom Google Font: Enable to use a custom Google font for the FreeForm Pro content. This will overide the Text Font setting.
Cust. Google Fnt: Enter the name of a Google font to use. No single or double quotes allowed.
Google Wt: Enter the Google font weight, but only if it's other than normal weight (400).

Requirements

EasyDB's minimum requirements are MacOS10.10+, PHP: 5.4+, 'vanilla' MySQL & MariaDB databases, RW6/7/8 & Stacks3.5/4. Later versions are supported as well.
Pro addons such as FreeForm Pro, do require the main EasyDB suite.

Additional general use info for other stacks can be seen by clicking the videos tab, clicking the goto videos image and watching: 'Tips & How-tos in EasyDB'

Installation

Upon downloading the zip file from your download email, unzip it by double-clicking on the zip file, which should create an EasyDB folder next to the zip file.

If double-clicking the zip file causes Archive Utility error: Unable to expand: (Error 1 - Operation not permitted.) First delete the zip as it may be corrupted and try downloading the zip file again from your download email.
If you still have problems: do a Get Info on the zip file by selecting it and pressing Command + I. The 'Open with' should be set to the Archive Utility.app. If not, change it, shut down and restart and try double-clicking the zip file again.

If it still doesn't work, then open Terminal from Applications/Utilities or you can use the Mac search (magnifier icon) at the top right of the menu bar and start typing Terminal. It will appear, click on it to open Terminal. In Terminal type unzip followed by a space; drag & drop the zip file onto the Terminal window and the name & path should be completed for you. Press enter/return and the file will be unzipped. If there are no errors, the unzipped EasyDB folder should be in your Home folder (Users/Your name).

To install the EasyDB suite of stacks, start up RapidWeaver and drag each stack from the EasyDB folder onto the RapidWeaver icon in the dock. You should see an informational screen indicating that stack will be installed. After you have installed all the stacks, quit RapidWeaver and then restart RapidWeaver. Since the EasyDB suite are all stacks, open up the main Stacks pane and in the search input type 'EasyDB'. A list of all the EasyDB stacks will be shown.

If you have used the Lite version of the suite, you will need to replace it with the paid versions. After you have installed the paid versions and have copied the settings over, you can go the addons folder and delete the demo stacks: In the main menu, go to RapidWeaver > Manage Addons. Then select the Stacks tab and search for 'EasyDB' and then delete any stacks with "Demo" in the name. Any data that you have already created in a table will be available once the new stacks have been set up.

Preview

When trying to preview within RapidWeaver, if you get a Fatal error warning, RW is trying to render PHP which is not available in Preview. To allow preview of other content, in the main menu go to: RapidWeaver > Preferences > General tab > Uncheck 'Render PHP on Local Preview'
You wiill then see: '(EasyDB *** Will Render Here - Please Publish)' for each instance of EasyDB dynamic content. Note: to see content you must publish to your server.

Setup

Stack Setup Order

The EasyDB stacks must be setup in this order: Credentials Setup (Only ONE per project), then Database Setup, then Login Setup, then the layout stacks (TextGrid or FreeForm or FreeForm Pro), then if using freeform place either (FreeForm Setup or FreeForm Setup Pro) above the layout stacks.

Login Setup

Make sure to place the Login Setup stack on a separate page. Be sure to do the 2-Step Publish on this page before continuing.

TextGrid

Make sure the Field Type' set up in TextGrid matches those in Database Setup. Make sure for 'Small Text' that the character lengths match and the 'Field Formatter' is set to match the type of formatting the data is to have.

2-Step Publish

  • On an EasyDB page, enable the setup & publish the page
  • Visit the page & you should see a green alert, click the Great button
  • Back in RW, disable the setup & publish the page
  • Visit the page & you shouldn't see any alerts (try clearing cache if you do)

Credentials

Main DB User

Within the Credentials Setup stack in the Set/Upd DB Credentials section, make sure that the DB Username that you enter has been given full privileges for the database. This can be set in the hosting control panel under something sim. to 'MySQL Databases'.

EasyDB Users

Be sure to set up at least one EasyDB user in the Credentials Setup stack in the Set/Upd UserCred section. This user should have admin privaleges.

Database

When initially setting up EasyDB: in Database Setup, don't enable 'Require Login' until after you have setup the display stacks and can login.

Publishing

Be sure to turn off all other FTP & bandwidth intensive programs while setting up, as those will usually cause publishing errors.

When changing settings be sure to hit Return after every entry to set the new value, otherwise it may not remember the new setting. When setting up or updating any settings be sure to do the 2-step publish process on one stack at a time.

In RW6: go to main menu File > Re-Publish All Files. With RW6, you must visit every EasyDB page before going to step-2
In RW7/8: Make sure the page has a white dot next to it which indicates changes have been made and then right-click on each EasyDB page and select 'Publish Page' to publish just that page.

Be sure to visit every EasyDB page after each step. Be sure to turn off any add blockers and make sure your browser's privacy setting is not blocking data, so you can see the setup alerts.
Make sure after you are done, every stack update control is disabled and the final step-2 page publish is done.

Safari - Develop Menu

To enable the Develop menu in Safari, in Safari's main menu go to Safari > Preferences > Advanced tab and enable 'Show Develop menu in menu bar'. This will allow you to easily clear the browser cache using Develop > Clear Cache.

Field Visibility

If you visit an EasyDB Pro page and some fields are not visible, or showing 'N/A' or images are showing a default hidden EasyDB image, it's possible that the user that you are currently using (probably Visitor) has not been granted permissions to see those fields. It's also possible that the user permissions have not been set for that page by an admin. Simply login as an admin user and then in the users pane, verify the record & field permissions for each of the users and Visitor and then click the Update button in the lower right corner. Logout and clear the browser cache and see if field visibility has changed.

CSV File Import

The first row of the file can be either field title or field name. If this file was not initially exported from EasyDB: The first column must be a column named 'id' w/ sequential numbers in every row. The second column must be a column named 'easydbusers' and should contain a comma-separated list of any users that are setup as 'View Only User Records'. When saving the csv file, be sure all extra rows & extra columns are removed before saving. Some columns like integer, date & time may throw errors as the spreadsheet is trying to change the format from what is seen. Simply try setting the format on the affected columns to automatic to clear the import errors.

Errors

200 Error

The 200 error usually mentions Ajax Load Error - SyntaxError: JSON Parse error: Unexpected identifier 'Table'. This is caused by the Table Name not being set properly between database & other layout stacks. Also, check to make sure that your browser's privacy settings are set to allow data from the website.

403 Error

The 403 error on resources folder is normally caused because directory indexing for a website is disabled for privacy and security. This is normally caused by incorrect file paths. You'll need to specify a complete path to a file. Check in fields that contain image or file paths and make sure they contain correct paths, including the image/file name. Make sure the image/file is in the resources folder as expected.

404 Error

The 404 error on image resources is normally caused because image paths are initially generated w/ variables and then dynamically updated to the actual paths. In general, these errors can be ignored.

About

EasyDB logo

FreeForm Setup Pro

FreeForm Setup Pro allows you to add functionality to control the content laid out using the FreeForm Pro stacks. In a nutshell: an EasyDB FreeForm Setup Pro stack sets any prefiltering, the number of filters provided, moving main controls and detail page setup. A new on-line admin interface is also provided to control individual user permissions on what content they can see and edit. Advanced in-line editing features are now also available which allows creating and editing field content and deleting entire records.

Note: The FreeForm Setup Pro stack is a paid addon to the EasyDB main suite which is also required.

Installation

Upon downloading the zip file from your download email, unzip it by double-clicking on the zip file, which should create an EasyDB folder next to the zip file.

If double-clicking the zip file causes Archive Utility error: Unable to expand: (Error 1 - Operation not permitted.)
First delete the zip as it may be corrupted and try downloading the zip file again from your download email.
If you still have problems: do a Get Info on the zip file by selecting it and pressing Command + I. The 'Open with' should be set to the Archive Utility.app. If not, change it, shut down and restart and try double-clicking the zip file again.

If it still doesn't work, then open Terminal from Applications/Utilities or you can use the Mac search (magnifier icon) at the top right of the menu bar and start typing Terminal. It will appear, click on it to open Terminal. In Terminal type unzip followed by a space; drag & drop the zip file onto the Terminal window and the name & path should be completed for you. Press enter/return and the file will be unzipped. If there are no errors, the unzipped EasyDB folder should be in your Home folder (Users/Your name).

To install the EasyDB suite of stacks, start up RapidWeaver and drag each stack onto the RapidWeaver icon in the dock. You should see a informational screen indicating that stack will be installed. After you have installed all the stacks, quit RapidWeaver and then restart RapidWeaver. Since the EasyDB suite are all stacks, open up the main Stacks pane and in the search input type 'EasyDB'. A list of all the EasyDB stacks will be shown.

If you have used a Lite version, you will need to replace it with the paid version stacks. After you have placed the paid versions and copied all the settings to the paid versions, you can go the addons folder and delete the demo stacks: In the main menu, go to RapidWeaver > Manage Addons. Then select the Stacks tab and search for 'EasyDB' and then delete any stacks with "Demo" in the name. Any data that you have already created in a table will be available once the new stacks have been set up.

Layout

EasyDB FreeForm Setup Pro in edit mode
Note: Prior to setting up the EasyDB FreeForm Setup Pro stack, you will need to set up in this order: the EasyDB Credentials Setup stack, the EasyDB Database Setup stack and the EasyDB Login Setup stack on a separate page. Explanation of how to set up these stacks can be found in the videos from the initial release. After setting up the above mentioned stacks, you will need to layout as many of the EasyDB FreeForm Pro stacks as needed. If you need to reference theFreeForm Pro settings, click the FreeForm Pro tab to see it's related docs.

Drag an EasyDB FreeForm Setup Pro stack onto the page and place it above all the FreeForm Pro stacks and preferably above any 3rd-party stacks. In the EasyDB FreeForm Setup Pro pane to the right, you will see all the controls for this stack. Uses Table Name, Dataset Name & the Filter Controls will be displayed in the stack in edit mode, once those controls are set.

Basic Content Info & Setup

Basic Content Info & Setup

This section explains the 'Setup/Update FreeForm Pro', 'Uses Table Name', 'Dataset Nm' & 'Start Row'.
Setup/Upd FFP: This control should be enabled when setting up FreeForm Pro fields for the first time or when changing any settings to do with them or changing settings within FreeForm Setup Pro. Publish the page and then visit the page. Once you see a green alert stating everything is ok, then return to RW, uncheck 'Setup/Update FreeForm Pro' and republish again.
Uses Table Name: This is the table name from EasyDB Database Setup. The table name can't have any spaces, single or double quotes. Uses Table Name will be displayed in edit-mode w/in the stack for your convenience.
Dataset Nm: This is a unique name given to all FreeForm Pro content that is related to each other. An example of a dataset name could be a common name that represent all elements in a group of images and their related content that are being brought in. The dataset name can't contain any spaces, single or double quotes, xxx, yyy or zzz. Use lowercase, alpha numeric only. Dataset Name will be displayed in edit-mode within the stack for your convenience.
Start Row: Enter a starting row (record) from the dataset to start pagination from. This is basically the row number in the table to start pulling content from. Typically, it would be set to 1, but you could enter another number to start with different content.

Filter Controls

Filter Controls

One Filter Control is added by default in edit mode, but you can click the blue plus button in edit mode to add as many as you desire. Within each Filter Control, a Preset Field, Preset Filter Type & Preset Value are shown & set to None as a default. If you wish to set a preset filter, then click on a Filter Control. In the EasyDB FreeFormPro Filter pane to the right, you will see all the controls for this stack. You can set each Field, Filter Type & Value seperately, but if you want the preset filter to run automatically, then all three need to be set.
Dataset Name: Enter dataset name from the main settings. Can't contain spaces, single or double quotes, xxx, yyy or zzz. Use lowercase, alpha-numeric only.
Preset Field(checkbox): Enable to set a preset field that will be applied when the page loads.
Preset Field: Enter a preset filter field name. Use the field name from EasyDB Database Setup. The field name can't have any spaces, single or double quotes. The preset field name will be displayed in edit-mode w/in the Filter Control stack for your convenience.
Field Always Used: Enabling this will set the field name to always be used in filtering and effectively locks that control. When enabled, a lock icon will show in edit-mode w/in the Filter Control stack for your convenience. When disabled, an unlock icon will be shown and any additional filtering run after initial page load will not include the preset field name.
Preset Filter Type(checkbox): Enable to set a preset filter type that will be applied when the page loads.
Preset Filter Type: Select a preset filter type as either 'None', 'Contains', 'Doesn't Contain', 'Between', '=', '!=', '<', '<=', '>' or '>='. The preset filter type will be displayed in edit-mode w/in the Filter Control stack for your convenience.

Note: When preset filter type is not being used, be sure to select 'None' before unchecking 'Preset Filter Type'.

Filter Type Always Used: Enabling this will set the filter type to always be used in filtering and effectively locks that control. When disabled, any additional filtering run after initial page load will not include the preset filter type.
Preset Value(checkbox): Enable to set a preset value that will be applied when the page loads.
Preset Value: Enter a preset filter value. The preset filter value will be displayed in edit-mode w/in the Filter Control stack for your convenience.
Value Always Used: Enabling this will set the filter value to always be used in filtering and effectively locks that control. When disabled, any additional filtering run after initial page load will not include the preset filter value.
Preset Sort Direction(checkbox): Enable to set a preset sort direction that will be applied when the page loads.
Sort Direction: Select either 'Ascending' or 'Descending' value. The preset sort direction will be displayed in edit-mode w/in the Filter Control stack for your convenience.
Direction Always Used: Enabling this will set the sort direction value to always be used in filtering and effectively locks that control. When disabled, any additional filtering run after initial page load will not include the preset sort direction value.
Fields Excluded: Enter any fields in a quoted & comma separated list that are not to be shown in the filter's field dropdown, Ex: "field1","field2"

Show FreeForm Setup Pro Help

Show FreeForm Setup Pro Help

Enable to show in-editor help on various settings.

Display Controls

Display Controls

This section explains the 'Display Mode', 'Show Filter Controls', 'Allow Add Filter', 'Allow Editing', 'Allow Adding' & 'Allow Deleting'.
Display Mode: Select the mode as either 'Read Only & Edit' or 'Read Only'. Read Only & Edit will allow both intially seeing content in read-only mode, but will also display the login button to allow a user to login and work in edit mode as well. Note: It is possible to initially hide the login button, but it can be toggled in Read-Only mode by typing Shift + L. Read Only mode will remove the login button and won't allow editing.
Show Filter Controls: Enabling this will show the filter inputs and related buttons for all users.
Allow Add Filter: Enabling this will show the Add Filter button next to the last filter input and is shown for all users.
Allow Editing: Enabling this will show the Update button in the FreeForm Pro Setup pane when logged in.
Allow Adding: Enabling this will show the Add Record button in the FreeForm Pro Setup pane when logged in.
Allow Deleting: Enabling this will show the Delete Record button in the FreeForm Pro Setup pane when logged in.

Move Controls

Move Controls

This section explains the 'Move Filters', Uses Filter ID', 'Move Login/Out' & 'Login/Out Btn. ID'.
Move Filters: Enable this to move the FreeForm Pro filters to a new location. Drag the EasyDB FreeForm Setup Pro Position stack to where you wish the filters to appear.
Uses Filter ID: Enter the Filter ID number from the EasyDB FreeForm Setup Pro Position stack used to position the filters.
Move Page Nav: Enable this to move the FreeForm Pro page navigation to a new location. Drag the EasyDB FreeForm Setup Pro Position stack to where you wish the page navigation to appear.
Uses Pg Nav ID: Enter the Pg Nav ID number from EasyDB FreeForm Setup Pro Position stack used to position the page navigation.
Move Login/Out: Enable this to move the FreeForm Pro login/out buttons to a new location.
Login/Out Btn. ID: Enter a unique number to represent the login/out buttons. A Login/Out Macro will display in EasyDB FreeForm Setup Pro. Right-click on the macro text and select 'Copy' from the contextual menu. Then paste this field macro into a text or html stack where you want the login/out buttons to be moved to.

Filter Settings

Filter Settings

This section explains the 'Filt Inp. Text', Filt Btn. Text', Filt Inp LineHt', 'Arrow LineHt', 'Filt Btn LineHt', 'Filt Input Text', 'Filt Button Text', 'Filt Btn. Hv Txt', 'Filt Button Border' & 'Filt Button BG'.
Filt Inp. Text: Set the filter input and filter select dropdowns text size, units in em.
Filt Btn. Text: Set the filter buttons text size, units in em.
Filt Inp LineHt: Set the filter input and filter select dropdowns line height, units in em.
Arrow LineHt: Set the filter select dropdowns arrow line height, units in em.
Filt Btn LineHt: Set the filter buttons line height, units in em.
Filt Input Text: Set the filter input and filter select dropdowns text color.
Filt Button Text: Set the filter buttons text color.
Filt Btn. Hv Txt: Set the filter button hover text color.
Filt Button Border: Set the filter buttons border color.
Filt Button BG: Set the filter buttons background color.

Pagination Settings

Pagination Settings

This section explains the 'Show Pg. Navigation Names', 'Pg Nav. Names', 'Bold Names', Pg Button Font', 'Use Custom Google Font', 'Cust. Google Fnt', Google Wt', 'Pg Btn. Text', 'Pg Btn LineHt', 'Pg Btn. Align', 'Pg Button Text', 'Pg Btn. Hover Txt', 'Pg Button Border', 'Pg Button BG' & 'Pg Btn. Hover BG'.

The Pagination buttons will display wherever you place the EasyDB FreeForm Setup Pro stack. It displays up to five central buttons which each respresent a set of records that have been layed out on the page. The surrounding icon buttons represent 'Go to First Set', 'Go Back One Set', ...numbered buttons..., 'Go Forward One Set' & 'Go to Last Set'. As you move through the sets, the numbered buttons will automatically update.

Show Pg. Navigation Names: Enable to show names in the pagination navigation buttons.
Pg Nav. Names: Set the navigation button names.
Bold Names: Enable to bold font for the navigation buttons.
Pg Button Font: Select the font for the pagination button text from 'EasyDB Default (Source Sans Pro)', 'Theme Default (Inherited)', 'Arial Black', 'Cooper Black', 'Courier New', 'Cursive', 'Futura', 'Georgia', 'Geneva', 'Gill Sans', 'Helvetica', 'Helvetica Neue', 'Hoefler', 'Impact', 'Lucida Console', 'Lucida Grande', 'Myriad Pro', 'Palatino', 'Rockwell', 'Times New Roman', 'Trebuchet MS' or 'Verdana'.
Use Custom Google Font: Enable to use a custom Google font for the pagination button text. This will overide the Pg Button Font.
Cust. Google Fnt: Enter the name of a Google font to use. No single or double quotes allowed.
Google Wt: Enter the Google font weight, but only if it's other than normal weight (400).
Pg Btn. Text: Set the pagination buttons text size, units in em.
Pg Btn LineHt: Set the pagination buttons line height, units in em.
Pg Btn. Align: Select the alignment for the pagination buttons as either 'Left', 'Center' or 'Right'.
Pg Button Text: Set the pagination buttons text color.
Pg Btn. Hover Txt: Set the pagination buttons hover text color.
Pg Button Border: Set the pagination buttons border color.
Pg Button BG: Set the pagination buttons background color.
Pg Btn. Hover BG: Set the pagination buttons hover background color.

Login/Out Settings

Login/Out Settings

This section explains the 'Show Login/Out Name', 'Login/Out Names', 'Bold Name', 'Vert. Pos' & 'Hide Login/Out Buttons'.
Show Login/Out Name: Enable to show a name in the login/logout buttons.
Login/Out Names: Enter the login and logout button names.
Bold Name: Enable to bold text for the login/logout names.
Vert. Pos: Enter the vertical position of Login/Out buttons, units % from the top.
Hide Login/Out Buttons: Enable to initially hide the login/logout buttons.

Login/out button visibility can be toggled w/ Shift + L

Field Defaults

Field Defaults

This section explains the 'Default Text', 'Hidden Text' & 'Text Cleanup'.
Default Text: Enter the default characters for text, link & email display text and image alt fields when creating a new record.
Empty Text: Enter the text shown when a field is empty.
Hidden Text: Enter the hidden text to display when fields are hidden, due to a user not having view permissions for that field. Note: be sure to update user permissions in the Admin panel to allow fields to be shown or hidden.
Text Cleanup: Select the spaces used after the end of a sentence in text submital. Ending characters are assumed to be period(.), exclamation(!) or question mark(?). Must enable 'Text Cleanup' in FreeForm Pro for a text field. Modern fonts should be set to one space, while mono-spaced text should be set to two spaces.

Note: Text Cleanup also capitalizes the first word of each sentence, sets most other words to lowercase, adds a period at the end of the text and allows for escaping of special capitalized words. Just place a backspace (\) at the beginning of a word to keep it's capitalization, Ex: \John or \EasyDBPro

Word Count Limit: Enter a word limit number when editing fields with large amounts of text, Note: leave blank for no limit.

General Settings

General Settings

This section explains the 'Turn Off Button Sounds' & 'Uses Framework'.
Turn Off Button Sounds: Enable to turn off sound when filter or pagination buttons are clicked.
Uses Framework: Enable if page/theme uses a Framework: Foundation/Foundry/Bootstrap. This helps to correct styling used in EasyDB stacks.

Alert Text

This section explains the alert text, button text and other miscellaneous text used in FreeForm Setup Pro. In the control panel to the right, you will see the subheading 'EasyDB FreeForm Pro Alerts'. Toggle the arrow to reveal all the alert text controls. If you and your site visitors read English, then these text controls don't have to be changed, but are available if you wish to change the text.

Note: If you are changing the text and wish to use single quote(') or double-quote(") characters in the text, then you must escape the quotes by placing a backspace character before them. Ex: l\’accès.

Gallery Skins

Gallery Skins

This section explains the gallery skins used in EasyDB FreeForm Setup Pro. These settings have been customized to support several 3rd-Party gallery/lightbox stacks. In the control panel to the right, you will see the subheading 'EasyDB FreeForm Pro Skins'. Toggle the arrow to reveal the gallery controls.

This section explains the 'Gallery Skin', 'Show Title' & 'Show Alt Text', 'Show Link', 'Title', 'Alt Text', 'Icons', 'Background', 'BG Opacity', 'Hover Border(px)', 'Border Radius', 'Hover Border', 'Box Shadow(px)', 'Box Shadow', 'Title Size', 'Caption Size', Icons Size' & 'Icons Lineheight'.
Gallery Skin: Enable this button to turn on the gallery thumbnail skin features, Note: optional.
Gallery Skin: Select the gallery thumbnail skin animation, Currently one skin type.
Show Title: Enable to show the title on the thumbnail.
Show Alt Text: Enable to show the alt text on the thumbnail.
Show Link: Enable to show the link to EasyDB detail page on the thumbnail.
Title: Set the thumbnail title color.
Alt Text: Set the thumbnail alt text color.
Icons: Set the thumbnail icons color.
Background: Set the thumbnail background color.
BG Opacity: Set the thumbnail background opacity.
Hover Border: Set the thumbnail hover border width.
Border Radius: Set the thumbnail border radius, 0-100.
Hover Border: Set the thumbnail hover border color.
Box Shadow: Set the thumbnail box shadow, Note: units px.
Box Shadow: Set the thumbnail box shadow color.
Title Size: Set the thumbnail title size, Note: units rem.
Caption Size: Set the thumbnail caption size, Note: units rem.
Icons Size: Set the thumbnail icons size, Note: units rem.
Icons Lineheight: Set the thumbnail icons lineheight, Note: units rem, used to align + w/ circle.

Filtering

Filters

The filtering control(s) may appear with prefilter information already entered and content filtered or empty filter inputs. The Sort button (up arrow) will expand on hover and allows a visitor to change the sort order of the corresponding field. The Filter button will filter the content based on the filter inputs. The Add Filter button (+) will expand on hover and allows a visitor to add another filter control. The Remove Filter button (-) will expand on hover and allows the removal of that filter control.

Note: Filter control(s) or the Add Filter button may not be visible if they have been disabled in the Display Controls section.

If a Preset filter has been set then that filter will run automatically on page load. If the 'Always Used' settings in the Filter Controls section are enabled, then the filter will also run on additional filtering and the control will be effectively locked. If the 'Always Used' settings are disabled and the clear filters button is clicked, then the filter inputs will be cleared and can be set by the visitor on additional filtering.

Admin Panel

Login Panel

To access the admin panel a user must login. This is done by clicking on the login button on the page. The page will automatically redirect to the EasyDB Login page and the login panel will be displayed.

Admin Panel

After entering a correct username and password, you will be redirected back to the EasyDB page. The Admin panel will automatically slide down at the top of the page and currently contains three icon controls. The first is the Users icon (a group of users) and opens the Users pane. The second is the FreeForm Pro icon (cube) and opens the FreeForm Pro Editing pane. The third is the Close Admin icon (up arrow) and closes the Admin panel.

Admin panel visibility can be toggled w/ Control + A. (You may need to use it twice to see a change)
Admin Users PaneBasic User Pane

Users Pane

Click the Users icon to enable the Users pane which will slide down. To see all users and to set privaleges a user must have been designated as an admin either in the Credentials Setup stack or later by enabling the checkbox next to Admin for a user.

If a user is NOT an admin, and thus a Basic User, when viewing the Users panel, they will only be able to see their username and edit their password.
To save ANY edits in the User Pane, click the Update button at the bottom right of the Users pane. After the confirmation alert, the page will refresh.
If a FreeForm Pro page is being visited for the first time by an admin, users must be enabled for that page by simply clicking the Update button at the bottom right of the Users pane. Be sure to verify all the record and field permissions before clicking Update. After the confirmation alert, the page will refresh and content should be visible, as lack of permissions was blocking viewing before.

If viewing the Users panel w/ admin permissions, each user's settings will be displayed as 'User', 'Password', 'Admin', 'View Only User Records', 'User Access', 'Delete User' & 'Permissions'. The original admin user, ie., the first in the list can not be deleted, for enhanced security. Therefore, the 'Delete User' button for that admin is not available. The Visitor user is automatically added and only has settings for 'User', 'Admin' & 'Permissions'.

Usernames are not editable for existing users, as that setting needs to be constant to allow proper functionality. If you wish to change the spelling of a username, then create another user by clicking the Add User button at the bottom left of the User pane. Edit the new user settings and then click the Delete User button for the original user.

Passwords are not displayed for security reasons and 'Previously Set' is shown in the input. If you wish to change a password, then type it in the input.

Admin when enabled, allows a user to see & edit all user settings. It also allows that user to see all records and all fields, thus the 'Permissions' will be cleared and 'All Fields Editable' will be shown in the input.

View Only User Records when enabled, will limit that user's access to only the records that they have created or edited, or to those records that have been assigned to the user through 'User Access' or the 'Basic User' control.

User Access, automatically assigns record access to basic users assigned w/ 'View Only User Records' permissions. Enter usernames as comma-separated list in the input.

Delete User button will remove that user's login access. After the confirmation alert, the page will refresh.

Field Permissions

Permissions sets the fields that a user can view. If they are assigned as an Admin, then 'All Fields Editable' will be displayed in the input and they will be able to view all fields. If a user should only be allowed to view some of the fields, then disable 'Admin' and tags for each field will be automatically displayed. Then remove the fields the user should not view, by clicking the 'x' in the tag. You can see any fields removed by clicking the arrow to the right of the tags and then clicking in the field input to see a dropdown of all the removed fields. Be sure to also edit the fields for the Visitor user, if there are fields that visitors shouldn't be able to view.

When updates are made to field permissions, don't forget to visit any other EasyDB pages and set the permissions on those pages. Permissions are unique for each page and need to be set separately.

Basic User input allows an admin to manually add a user w/ 'View Only User Records' permissions to an existing record. Simply select a field from the record in question and then enter the user's username in the input field and click the 'Assign Access' button.

Add User button in the lower left of the Users pane will add a new blank user into the user pane. At a minimum, be sure to set the 'Username' & 'Password' and adjust any other settings for that user.

FreeForm Pro Pane

Click the FreeForm Pro icon to enable the FreeForm Pro pane which will appear to the right of the icons. These controls are used to edit FreeForm Pro content and are discussed in detail in the next Add/Edit/Delete section.

Close Admin

Click the Close Admin icon to close all admin panes and slide up the admin panel.

Add/Edit/Delete

Edit pane

In order to make any changes to FreeForm Pro content, a user must be logged in.

Adding a Record

A record can be added by simply clicking the FreeForm Pro icon in the Admin panel to enable the FreeForm Pro Edit pane (if not currently shown) which will appear to the right. Then click the Add Record button. Default values will be automatically entered into the fields for the new record. After the confirmation alert, the page will refresh and the new record can be found at the end of the records by clicking the double-arrows in the pagination controls.

Deleting a Record

A record can be deleted by clicking a field related to that record and then simply clicking the FreeForm Pro icon in the Admin panel to enable the FreeForm Pro Edit pane (if not currently shown) which will appear to the right. Note: This will delete the record and all fields in that record. To delete the record, click the Delete Record button. After the confirmation alert, the page will refresh.

Edit Text Field
Edit Image Field

Editing a Record

Any field value can be edited by simply clicking on the content. An inline editing pane will open that reveals a field label and the current value if it's a simple text field. If it's an image field, then it will also reveal a thumbnail of the current image and controls for an image drop zone or browse link, as well as, the alt image text field and other related fields. When dropped or selected, images or files related to a field will be automatically uploaded to the upload location set in the related field and the path to the image/file will automatically update in the field value and will show a green outline. If you change your mind before updating, you can click the small 'x' button in the thumbnail's upper-right and the existing thumbnail and path will reset. Email and link fields will also reveal an additional control for display text.

When you have finished editing the content that is currently visible on the screen, click the Update button in the FreeForm Pro Edit pane.

To save ANY edits made to visible content, the Update button must be clicked. After updating the visible content, refresh the page and then use the navigation buttons to show different pages of content which can then be edited as well.

Third-Party Integration

Pro Gallery SettingsSet URL MacroRow Num Change

Since gallery/lightboxes are very complex stacks with lots of elements, custom integrations have been built-in to allow ease of use for users.
If you are trying to integrate into other Third-Party stacks, typically you would either drop a FreeForm Pro stack into a drop zone in edit mode or paste field macros into the Third-Party stack's settings.

Stacks4Stacks: ProGallery

In the ProGallery stack from Stacks4Stacks, in the main edit window, click the blue plus button and select 'Single Image'. You can add as many 'Single Image' child stacks as you want to display at a time. Keep in mind that site visitors will be able to cycle through as many pages of images as desired. Note: To speed up setup: it's recommended to fully set up one image and then copy and modify those child stacks afterwards. Instead of placing static images/text/links in the settings, field macros from FreeForm Pro field stacks will be used.

Image Source: select 'Warehoused'.
Thumbnail Image: click the Set Link button, select 'URL' from the dropdown, paste an field macro into the input box and click the 'Set Link' button. Note: can use an image macro from an EasyDB FreeForm Pro field stack of either 'Std.Img.FldName', '2xSm.Fld. Name' or '2xLg.Fld. Name', depending on the pixel size of the images.
Lightbox Image: click the Set Link button, select 'URL' from the dropdown, paste a field macro into the input box and click the 'Set Link' button. Note: can use an image macro from an EasyDB FreeForm Pro field stack of either 'Std.Img.FldName', '2xSm.Fld. Name' or '2xLg.Fld. Name', depending on the pixel size of the images.
Hi-Res Image: click the Set Link button, select 'URL' from the dropdown, paste a field macro into the input box and click the 'Set Link' button. Note: can use an image macro from an EasyDB FreeForm Pro field stack of either '2xSm.Fld. Name' or '2xLg.Fld. Name', depending on the pixel size of the images.
Image Title: paste a text field macro into the input box.
Image Caption: paste a text field macro into the input box.
Alternative Link: paste a link field macro into the input box. (Optional) Note: this is typically a link to a detail page.


Note: In this instance, an image has a related set of macros. The only difference between each set should be the 'Dataset Num' set in each FreeForm Pro field stack. To set up addition images, copy each 'Single Image' child stack and then in each macro, edit the number between the two sets of 'yyy' in the macro. An example of each input type is shown to the left with the number to change indicated.
Note: The 'Gallery Skins' in EasyDB FreeForm Setup pro can be used with these third-party stacks.
Gallery Grid SelectionsGallery Integration StackGallery Integration Settings

inStacks: Gallery Stack 3

In the Gallery stack from inStacks, in the main edit window, under 'Select Grid/Slider', click the blue plus button and select a Grid child stack, shown to the left in the green box (Single Image not supported). Slideshows are not supported, as it's typical to only use a few images and thus dynamic content isn't really necessary.
In the Gallery stack, under 'Select Lightbox', click the blue plus button and select a Lightbox child stack (Lightbox:Disabled not supported).
In the Gallery stack, under 'Add Images or Integration Stacks', click the blue plus button and select 'EasyDB Integration'. You will only need to add ONE 'EasyDB Integration' child stack. Keep in mind that site visitors will be able to cycle through as many pages of images as desired.

Uses Dataset Nm: Enter the 'Dataset Name' from EasyDB FreeForm Setup Pro to use, Note: Can't contain spaces, single/dbl quotes, xxx, yyy or zzz.
Std Res. Img Fld: Field for Standard Resolution Image, Note: Must match 'Std.Img.FldName' in an EasyDB FreeForm Pro image field.
Alt Text Fld: Field for alternative text, Note: Must match 'Alt. Text Fld' in an EasyDB FreeForm Pro image field.
Hi-Res Img Fld: Field for Hi-Resolution Image, Note: Must match either '2xSm.Fld. Name' or '2xLg.Fld Name' in EasyDB FreeForm Pro image field.
Hi-Res Fld. Loc: Select the 2x field type used within an EasyDB FreeForm Pro image field, either 2xSm.Fld. Name or 2xLg.Fld. Name.
Use FFPro Thumbnail Skin: Enable to use FreeForm Pro Thumbnail Skin settings.
Link: Enable link from the thumbnail to a detail page. Link will show in the Thumbnail Skin, Note: if disabled, then disable Show Link in FreeForm Setup Pro > EasyDB FreeForm Pro Skins settings.
Link Fld: Enter field containing link to detail page, Note: Must match 'Uses Field Name' in FreeForm Pro link field.
Max Image Size: Enter the max size limit when uploading an image, Units MB.
Custom Class: Custom CSS Class for styling the image, Note: remove dot (.) at beginning of class name.
Using Grid: Justified: Enable if using the Grid: Justified child stack in the Gallery stack.
Img Height: Enter the image height set in Grid: Justified > Img Height.
Img Margin: Enter the image margin set in Grid: Justified > Img Margin.
Show Caption Below: Enable if showing the caption below the thumbnail image.


Note: When using Grid: Justified, set 'Justify Last Row' to 'no justify', enable 'Using Grid: Justified' in the EasyDB Integration stack and make sure the Image Height & Image Margin match those set in the Grid: Justified stack.
Note: When logged-in and editing images, edit panes may move around when images are clicked, this is expected as some lightboxes have different styling than the editor.