Customer Master Synchronisation App, Google Sheet Integration 20230417<\/div>
This workflow automatically imports the latest customer master. The master data held on Google Sheets is automatically synchronised to the choice master in Questetra. Regardless of whether you have the authority to edit the choice master, if you have the authority to execute this flow, you can execute the synchronisation app.<\/div><\/div>\n\n\n
<\/span>Worker (#of Swimlane: 1)<\/div>
\n\n\n\n
- \n
- Operator\n
- \n
- Person in charge of master synchronisation.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<\/span>Business Flow (Complexity of Workflow: 7)<\/div>\n\n\n\n
- \n
- (0. Do nothing and move on)<\/strong>\n
- \n
- The person in charge completes the task immediately and proceeds with the case (empty tasks must be placed due to specification constraints)<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- 1. Data verification<\/strong>\n
- \n
- The person in charge checks the data options that are due to be synchronised.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- x1. Master data acquisition from G sheet<\/strong>\n
- \n
- The workflow platform retrieves the master data from the specified Google Sheet.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- x2. Reflecting the choice master<\/strong>\n
- \n
- The workflow platform reflects the data scheduled for synchronisation in the choice master.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<\/span>Business App Variables (#of Data Item: 3)<\/div>\n\n\n\n
- \n
- <\/i><\/span>ID List of Master Options<\/strong> q_ID_list<\/span>
0<\/code>\n- \n
- The list of IDs of the master, whose choices are to be synchronised, is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>List of Labels for Master Options<\/strong> q_label_list<\/span>
1<\/code>\n- \n
- The list of label options is stored in the master that is to be synchronised.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Master Options<\/strong> q_selects<\/span>
2<\/code>\n- \n
- The master, which is to be synchronised, is stored with the options.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n\n
<\/i> Field Name<\/span>,
num<\/code>, Initial Value<\/span><\/p>\n\n\n\n<\/i> Download<\/h3>\n\n\n\n
- The master, which is to be synchronised, is stored with the options.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n\n
- <\/i><\/span>ID List of Master Options<\/strong> q_ID_list<\/span>
- The workflow platform reflects the data scheduled for synchronisation in the choice master.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n
- (0. Do nothing and move on)<\/strong>\n
- Person in charge of master synchronisation.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/master-synchronization-20230417-capture-en-1024x259.jpg?resize=1024%2C259&ssl=1\")
<\/figure>\n\n\n\n