Table Automations

take your work tables a step further with our automations! every automation starts with a trigger and includes one or more actions whenever a trigger occurs, an action is initiated within a table, automation can be activated in response to a range of triggers, including record creation, record update, and record deletion these triggers enable you to automate specific tasks, ensuring that your data and processes remain consistent note prior to automating the fields in the table, it is necessary to create a workbook and table to learn how to create a workbook, click here https //help engini ai/create folderstables#create a table to learn how to build tables, check out the following links columns https //help engini ai/build a table#create columns , records https //help engini ai/tables records add new automation inside a table click on ‘automations’ in the right side of the workbook page click on " new automation " to create your own automation for your table note if its your first automation you have two button to click on for a fresh new automation build your automation step 1 choose a trigger the first step in building your automation is to add a trigger a trigger is the event that initiates the process, and it occurs only once each time an automation begins from the workflow that opened press the '+' to choose your trigger choose the trigger you want to start with more explanations down below triggers on record creation automation is initiated when a new record is generated, resulting in the execution of one or more actions you can also include a condition in the trigger, ensuring that the process only activates if this condition is satisfied add conditions click add conditions to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add conditions on record deleted automation is initiated when a record is deleted from a table, leading to the execution of one or more actions you can also integrate a condition into the trigger, in order to ensure that the process only activates if this condition is met add conditions click add conditions to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add conditions on record updated an automation is activated when an existing record is modified or updated, leading to the execution of one or more actions columns to listen to you have the option to choose a specific column from the table, which, when changes occur in it, will trigger the automation add conditions click add conditions to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add conditions step 2 choose an action the action is simply an action or event that occurs one or more times as a result of the activation of the trigger and the fulfillment of the conditions for its activation you can choose an action of the tables, or an action related to any other software you can learn more about each software and its operations in the apps category actions the following actions displayed are related to tables click on 'core' select 'tables' from the list inside core create record by using this action, you can generate a new record in the table table id select the table where the new record will be created add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields note some tables include connected table fields, which are used to create relationships between records in different tables when using the create record action, you can map a connected table field by providing the record id of the related record for example a new employee record is created the task field is a connected table field that links the employee to an existing task record to create this connection, the workflow maps the record id of the relevant task into the task field create records batch with this action, you can create multiple new records in your table simultaneously the number of records created will match the number of objects in the data list each record will include the properties of the objects from the data list in sequential order data list click on the empty field choose the data list from the tooltip table id choose the appropriate table in the ‘table id’ field add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields note you can use this activity for 50,000 records however, if you still want to perform a create operation for more than 50,000 records, you will need to use a for each/ do while activity delete record by using this action, you can delete a single record in the table table id select the table from which the record will be deleted record id specify the unique id of the record you want to delete from the selected table delete records by using this operation, you can delete one or more records in the table table id choose the table from which you want to delete records in top n define how many records to delete (if not specified, all matching records will be considered) add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add sort click add sort to organize the data list by a selected field in ascending or descending order to learn more about sorting data, click here https //help engini ai/workflow editor#add sorts delete record batch by using this action, you can delete multiple records from your table at once the number of records that will be deleted is the number of objects in the data list this allows for efficient bulk deletion instead of removing records individually data list the list of objects that represent the records to be deleted the data list should contain a list of objects where each object includes a recordid property table id specifies the table where the records are stored select the table from the dropdown or input its identifier in the ‘table id’ field recordid identifies the records to be deleted each object in the data list must include a valid recordid to specify which record to delete delete records batch by using this action, you can delete multiple records from your table at once based on a specified data list or filtered conditions this action is particularly useful when you need to perform bulk deletion operations efficiently without deleting records individually data list the list of objects that represent the records to be deleted the data list should contain a list of objects where each object includes a recordid property table id specifies the table where the records are stored select the table from the dropdown or input its identifier in the ‘table id’ field add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters get record by using this action, you can get one or more records from a table table id click on the empty field and choose table from which you want to retrieve the record in record id click on the empty field and choose the record you want to get get records by using this action, you can get one or more records from a table table id choose the table from which you want to get records in top n define how many records to get (if not specified, all matching records will be considered) add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add sort click add sort to organize the data list by a selected field in ascending or descending order to learn more about sorting data, click here https //help engini ai/workflow editor#add sorts update record using this action you can update a record table id click on the empty field and select the table from which you want to retrieve the record in record id click on the empty field and choose the record id you want to update add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields update records by using this action, you can update multiple records in a selected table table id click on the empty field and select the table from which you want to retrieve the record in top n click on the empty field to define the maximum number of records that can be updated in a single run add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields update record batch by using this action, you can update a single record in your table with multiple changes at once the updates are defined by the properties specified in the data list, and you can choose which fields to update and their corresponding values data list click on the empty field select the appropriate data list from the tooltip table id choose the appropriate table from the dropdown or enter the table’s identifier in the ‘table id’ field recordid enter the record’s recordid in the field or map it dynamically using available variables add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields update records batch by using this action, you can update multiple records in your table at once the number of records that will be updated is the number of objects in the data list every time you update record, it will contain the properties of the object in the data list in order data list click on the empty field choose the data list from the tooltip table id choose the appropriate table in the ‘table id’ field add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields note you can use this activity for 50,000 records however, if you still want to perform an update operation for more than 50,000 records, you will need to use a for each/ do while activity add comment to record using this action, you can add a comment to a record table id click on the empty field and choose the table where you want to add the comment to record id click on the empty field and select the record id of the record want to add the comment to comment at first click on the empty field, a window will open where you can write your comment write your comment and use the toolbar to bold, italicize, underline, align etc you can also add to your comment dynamic content and functions to learn more about functions click here https //app archbee com/public/preview ixqqblwfxopjg0nave78y/preview o3kkbgi5xnqf yvnuqkcv#ca 5p when you’re done, click save add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields get record comments by using this action, you can get one or more comments from a table table id click on the empty field and select the table from which you want to retrieve the comment in record id click on the empty field and select the record id of the comment you want to retrieve top n you can specify how many comments you want to get click on ‘top n’ and enter the maximum number of comments you want to retrieve if you set top n = 1 , a single comment will be returned instead of an array if no comment is found, the action will fail, allowing you to implement an if condition within the workflow this can be useful for processes where the existence of a comment determines the next steps in the workflow add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add sort click add sort to organize the data list by a selected field in ascending or descending order to learn more about sorting data, click here https //help engini ai/workflow editor#add sorts save the automation save the automation by clicking on the button in the right side of the window you can exit the automation by clicking on ‘save’ activate your automation activate your automation perform an action that should activate the automation you’ve created click on the “automations” button on the upper right side of the workbook click on ‘automation activity’ on the right side check the status of the automation—whether it’s ‘failure,’ ‘fell by condition,’ ‘modified,’ or ‘success’—by clicking on ‘automations’ on the right side to access information about the process click details to learn how to analyze workflow or automation history, you can navigate to the “workflow history” category there you’ll find the details you need to review and understand the history of your workflows or automations after clicking on ‘details’ if you want to run the same automation again, click on ‘re run’ button, located on the right side update the file column via workflow initialize files array creates a files array name click on the empty field and the tooltip will pop up select from the tooltip the name of the new item you create you can use static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) value the value is optional you can set it in a variable that you initialize as an initial value, but you can choose not to fill the field of the variable and populate it later in the workflow append file to array appending to an array allows you to dynamically add new files to the end of the array without changing the size or structure of the array variable choose from the drop down the name of the array you want to append to name set the file name base64content enter the base64 of the file content type enter the content type add file to column add file to files column table choose from the drop down the name of the table you want to add to field choose from the drop down the name of the column field you want to add to record id enter the record id of the record you want to add to file enter the file content content type enter the content type format base64 name set the file name add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields delete files delete file from column table choose from the drop down the name of the table you want to delete from field choose from the drop down the name of the column field you want to delete from record id enter the record id of the record you want to delete from add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields get files choose the “get files” activity table choose from the drop down the name of the table you want to delete from record id enter the record id of the record you want to delete from add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields