How do I create a Table SQL Field?
1. Navigate to File Tool on the table that you wish to create the SQL field on.
2. Select the field to open the Field Info or create a new field.
3. Set Custom SQL to Yes.
4. Click on the <> symbol.
5. 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.