Update database with connected cards

@jason147 

To update a specific record, you can use this code (GraphiQL):

mutation{
  setTableRecordFieldValue(input:{
    table_record_id:XXXXXX #record's ID
    field_id:"field_id_here" #the field you want to update's field.
    value:"Field Value" # the field's new value you want to add to this record
  }) {
    clientMutationId
  }
}

To know the ID of the fields, use this:

{
  table(id:"XXXXXX"){
    table_fields{
      label
      id
    }
  }
}

To facilitate this process, you can create a custom field on your cards with the number of the connected record or parent card.

You can use the Pipefy interface to test the code, but beware of update/mutation tests:

https://app.pipefy.com/graphiql