Skip to main content
Solved

Can't connect a tableRecord in to another table



I'm trying to create a new table record using a field which is a connected record from another database. Using the GUI I can create and connect table record with no issues. But, when I run using the Graphiql Explorer I got the following message: Value You don't have permission to connect these cards/table records. Both databases has the Public Permission checked.
 I tried using the API (new version) and presents the same problem.

Best answer by Mayara Rasini

Hello! :grinning:
You need to use the record ID when handling connections. For example, to update a connection field in another table:

mutation{
  setTableRecordFieldValue(input:{
    table_record_id:369553512 #ID_from_parent_table
    field_id:"connection_field"
    value: 370702260 #ID_from_connected_record
  }) {
    clientMutationId
  }
}

You can take the record ID on the url or the ID field :)

 

View original
Did this topic help you find an answer to your question?

2 replies

Mayara Rasini
Pipefy Staff
  • Pipefy Staff
  • 2 replies
  • Answer
  • August 18, 2020

Hello! :grinning:
You need to use the record ID when handling connections. For example, to update a connection field in another table:

mutation{
  setTableRecordFieldValue(input:{
    table_record_id:369553512 #ID_from_parent_table
    field_id:"connection_field"
    value: 370702260 #ID_from_connected_record
  }) {
    clientMutationId
  }
}

You can take the record ID on the url or the ID field :)

 


genietim
Forum|alt.badge.img+12
  • Pipefy Legend
  • 412 replies
  • December 21, 2020

I know this topic is old, but how does it work if I want more than one connected record? If I use the solution above by @Mayara Rasini , all records that are already connected get removed.

If I use something like

mutation{
  setTableRecordFieldValue(input:{
    table_record_id:369553512 #ID_from_parent_table
    field_id:"connection_field"
    value: [370702260, 370702261] #IDs_from_connected_record
  }) {
    clientMutationId
  }
}

I get an “Invalid input” error.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings