Automations

ensure automation AutomateOpportunitySheet kind: spreadsheet
  spreadsheet: OpportunitySheet

ensure event BeforeInsert fire: beforeInsert

ensure pipelineVar P1 form: PrivateRowIdResult

ensure var VarConditionDoesOpportunityIdMatchExisting1 kind: condition 
  deploy: fixedOnDeploy
  value: "<root>
      <stmt>${f:Details.Id} == ${in:Details.Id}</stmt>
    </root>" 
  sourceForm: EntityOpportunity 
  inputForm: EntityOpportunity

ensure var VarMappingOpportunityToPrivateRowIdResult2 kind: mapping 
  deploy: fixedOnDeploy
  fromForm: EntityOpportunity 
  toForm: PrivateRowIdResult 
  fieldMappingMap: {
      'map': {
        '${ctx:row.id}': 'Details.RowId'
      }
    }

// step, getSpreadsheetRows, GetSpreadsheetRows
ensure automation AutomateOpportunitySheet
ensure event BeforeInsert
ensure step GetSpreadsheetRows kind: getSpreadsheetRows 
  targetSpreadsheet: OpportunitySheet 
  targetSpreadsheetFilterVar: VarConditionDoesOpportunityIdMatchExisting1 
  outputFormPipelineVar: P1 
  targetToSourceMappingVar: VarMappingOpportunityToPrivateRowIdResult2

// step, removeField, RemoveField
ensure step RemoveField kind: removeField 
  removeField: Other.FormMode

ensure var VarMappingPrivateRowIdResultToOpportunity kind: mapping 
  deploy: fixedOnDeploy
  fromForm: PrivateRowIdResult 
  toForm: EntityOpportunity 
  fieldMappingMap: {
      'map': {
        '${f:Details.RowId}': 'Other.RowId'
      }
    }

// step, copyField, CopyRowIdToCurrentForm
ensure automation AutomateOpportunitySheet
ensure event BeforeInsert
ensure step CopyRowIdToCurrentForm kind: copyField 
  sourcePipelineVar: P1 
  mappingVar: VarMappingPrivateRowIdResultToOpportunity

ensure var VarConditionDoesOpportunityRowIdMatch kind: condition 
  deploy: fixedOnDeploy
  value: "<root>
      <stmt>${in:Details.RowId} has value</stmt>
    </root>" 
  sourceForm: EntityOpportunity 
  inputForm: PrivateRowIdResult

ensure var VarMappingOpportunityToOpportunity2 kind: mapping 
  deploy: fixedOnDeploy
  fromForm: EntityOpportunity 
  toForm: EntityOpportunity 
  fieldMappingMap: {
      'map': {
        '${f:Details.Id}': 'Details.Id',
        '${f:Details.Name}': 'Details.Name',
        '${f:Details.AccountName}': 'Details.AccountName',
        '${f:Details.LeadSource}': 'Details.LeadSource',
        '${f:Details.Amount}': 'Details.Amount',
        '${f:Details.Type}': 'Details.Type',
        '${f:Details.Stage}': 'Details.Stage',
        '${f:Details.Probability}': 'Details.Probability',
        '${f:Details.OrderNumber}': 'Details.OrderNumber',
        '${f:Details.CurrentGenerator}': 'Details.CurrentGenerator',
        '${f:Details.TrackingNumber}': 'Details.TrackingNumber',
        '${f:Details.MainCompetitors}': 'Details.MainCompetitors',
        '${f:Details.DeliveryInstallationStatus}': 'Details.DeliveryInstallationStatus',
        '${f:Details.Description}': 'Details.Description',
        '${f:Other.FormMode}': 'Other.FormMode',
        '${f:Details.CloseDate}': 'Details.CloseDate'
      }
    }

// step, updateSpreadsheet, UpdateSpreadsheet
ensure automation AutomateOpportunitySheet
ensure event BeforeInsert
ensure step UpdateSpreadsheet kind: updateSpreadsheet 
  executionConditionVar: VarConditionDoesOpportunityRowIdMatch 
  executionConditionInputPipelineVar: P1 
  targetSpreadsheet: OpportunitySheet 
  rowIdField: Other.RowId 
  sourceToTargetMappingVar: VarMappingOpportunityToOpportunity2

// step, terminate, Terminate
ensure step Terminate kind: terminate 
  executionConditionVar: VarConditionDoesOpportunityRowIdMatch 
  executionConditionInputPipelineVar: P1

ensure var VarConditionDoesOpportunityRowIdNotMatchAndIdHasValue kind: condition
  deploy: fixedOnDeploy
  value: "<root>
      <and>
        <stmt>${in:Details.RowId} has no value</stmt>
        <stmt>${f:Details.Id} has no value</stmt>
      </and>
    </root>" 
  sourceForm: EntityOpportunity 
  inputForm: PrivateRowIdResult

ensure var VarMappingOpportunityToCreateOpportunity1 kind: mapping 
  deploy: fixedOnDeploy
  fromForm: EntityOpportunity 
  toPlugin: SalesforcePlugin 
  toForm: CreateOpportunity 
  fieldMappingMap: {
      'map': {
        '${f:Details.Name}': 'OpportunityName',
        '${f:Details.AccountName}': 'AccountName',
        '${f:Details.Type}': 'Type',
        '${f:Details.LeadSource}': 'LeadSource',
        '${f:Details.Stage}': 'Stage',
        '${f:Details.OrderNumber}': 'OrderNumber',
        '${f:Details.CurrentGenerator}': 'CurrentGenerator',
        '${f:Details.TrackingNumber}': 'TrackingNumber',
        '${f:Details.MainCompetitors}': 'MainCompetitors',
        '${f:Details.DeliveryInstallationStatus}': 'DeliveryInstallationStatus',
        '${f:Details.Description}': 'Description',
        '${f:Details.Probability}': 'Probability',
        '${f:Details.Amount}': 'Amount',
        '${f:Details.CloseDate}': 'CloseDate'
      }
    }

ensure var VarMappingCreatedRecordIdToOpportunity kind: mapping 
  deploy: fixedOnDeploy
  fromPlugin: SalesforcePlugin 
  fromForm: CreatedRecordId 
  toForm: EntityOpportunity 
  fieldMappingMap: {
      'map': {
        '${f:Details.Id}': 'Details.Id'
      }
    }

// step, callPlugin, CreateSalesforceRecord
ensure automation AutomateOpportunitySheet
ensure event BeforeInsert
ensure step CreateSalesforceRecord kind: callPlugin 
  executionConditionVar: VarConditionDoesOpportunityRowIdNotMatchAndIdHasValue 
  executionConditionInputPipelineVar: P1 
  targetPlugin: SalesforcePlugin 
  targetPluginApi: CreateOpportunity 
  pluginInputMappingVar: VarMappingOpportunityToCreateOpportunity1 
  pluginOutputMappingVar: VarMappingCreatedRecordIdToOpportunity

// event, AfterInsert
ensure event AfterInsert fire: afterInsert

// step, forwardToGroups, ForwardToGroups
ensure step ForwardToGroups kind: forwardToGroups 
  senderRole: $Self
  groups: [Salesforce]

// event, AfterUpdate
ensure event AfterUpdate fire: afterUpdate

ensure var VarMappingOpportunityToCreateOpportunity2 kind: mapping 
  deploy: fixedOnDeploy 
  fromForm: EntityOpportunity 
  toPlugin: SalesforcePlugin 
  toForm: CreateOpportunity 
  fieldMappingMap: {
      'map': {
        '${f:Details.Id}': 'Id',
        '${f:Details.Name}': 'OpportunityName',
        '${f:Details.AccountName}': 'AccountName',
        '${f:Details.Type}': 'Type',
        '${f:Details.LeadSource}': 'LeadSource',
        '${f:Details.Stage}': 'Stage',
        '${f:Details.OrderNumber}': 'OrderNumber',
        '${f:Details.CurrentGenerator}': 'CurrentGenerator',
        '${f:Details.TrackingNumber}': 'TrackingNumber',
        '${f:Details.MainCompetitors}': 'MainCompetitors',
        '${f:Details.DeliveryInstallationStatus}': 'DeliveryInstallationStatus',
        '${f:Details.Description}': 'Description',
        '${f:Details.Probability}': 'Probability',
        '${f:Details.Amount}': 'Amount',
        '${f:Details.CloseDate}': 'CloseDate'
      }
    }

// step, callPlugin, UpdateEventInSalesforce
ensure automation AutomateOpportunitySheet
ensure event AfterUpdate
ensure step UpdateEventInSalesforce kind: callPlugin 
  targetPlugin: SalesforcePlugin 
  targetPluginApi: UpdateOpportunity 
  pluginInputMappingVar: VarMappingOpportunityToCreateOpportunity2

// event, BeforeRemove
ensure event BeforeRemove fire: beforeRemove

ensure var VarMappingOpportunityToRecordIdInputForm2 kind: mapping 
  deploy: fixedOnDeploy 
  fromForm: EntityOpportunity 
  toPlugin: SalesforcePlugin 
  toForm: RecordIdInputForm 
  fieldMappingMap: {
      'map': {
        '${f:Details.Id}': 'Id'
      }
    }

// step, callPlugin, RemoveRecordFromSalesforce
ensure automation AutomateOpportunitySheet
ensure event BeforeRemove
ensure step RemoveRecordFromSalesforce kind: callPlugin 
  targetPlugin: SalesforcePlugin 
  targetPluginApi: RemoveRecord 
  pluginInputMappingVar: VarMappingOpportunityToRecordIdInputForm2