Export setting

Link to google spreadsheet

Google Sheets link where the data will be exported.

Sheet name

Sheet name in the Google Sheet

Export type

• Append (adds new data to the existing data)
• Update (refreshes the entire table)

  Update

  Before updating, all data in the current sheet will be deleted!

Model class

• modUser
• modResource
• FormIt
• msCategory
• msProduct
• msVendor
• msOrder
• msOptionsPrice2

Where

Criteria for selection. For example, for a resource, you can set:

[{"published":1,"deleted":0,"parent":12}]

All published and not deleted resources with a parent of 12 will be selected.

Fields

Fields to export are specified, separated by commas.

For example, for a resource:

id,context_key,pagetitle,tv.title,tv.desc

If you need to add headers to the fields, then it should look like this:

id==ID,context_key==Context,pagetitle==Title,tv.title==TV_title,tv.desc==TV_desc