Documentation and SupportV6 User Manual The File ToolHow do I create a Table SQL Field?

How do I create a Table SQL Field?

Navigate to the system tools.

2. Select the field to open the Field Info or create a new field.

Select the field to edit.

3. Set Custom SQL to Yes.

Edit the field and click Save.

4. Click on the <> symbol.

Open the Table Info sandwich and select save.

5. Create New Mashup Value

Create New Mashup Value

6. Enter what you would like to be in the Mashup field.

This can be as simple as text or a number, or it can be custom SQL.

Note: You can use any of the available options along the top, and you can use any of the fields in the drop down.  If you are going to use plain text or a number, please be sure to use single quotes around your entry as shown below. Then hit Save.

Enter what you would like to be in the Mashup field.

7. Save the Table.

8. Congratulations, the field has been created with your SQL!