Formula
Create a Formula Field Type
mutation {
fields(
boardId: "615be38975138d0001c501a7"
dto: {
name: "Quantity Left"
description: "This is a formula field type"
type: "formula"
unique: false
dontUpdate: false
typeData: { formula: "{Total Quantity}-{Actual Quantity}" }
}
) {
id
fieldsSecret {
name
description
type
typeData {
formula
}
}
boardId
createdTime
lastModifiedTime
}
}
{
"data": {
"fields": {
"id": "6175ffbe40dc970001b8f84f",
"fieldsSecret": {
"name": "Quantity Left",
"description": "This is a formula field type",
"type": "formula",
"typeData": {
"formula": "{Total Quantity}-{Actual Quantity}"
}
},
"boardId": "615be38975138d0001c501a7",
"createdTime": "Mon Oct 25 00:52:14 GMT 2021",
"lastModifiedTime": null
}
}
}
Update a Formula Field Type
mutation {
updateFields(
boardId: "615be38975138d0001c501a7"
fieldId: "6175ffbe40dc970001b8f84f"
dto: {
name: "Quantity Left"
description: "This is an updated formula field type"
type: "formula"
unique: true
dontUpdate: false
typeData: { formula: "{Total Quantity}-{Actual Quantity}" }
}
) {
id
fieldsSecret {
name
description
type
typeData {
formula
}
}
boardId
createdTime
lastModifiedTime
}
}
{
"data": {
"updateFields": {
"id": "6175ffbe40dc970001b8f84f",
"fieldsSecret": {
"name": "Quantity Left",
"description": "This is an updated formula field type",
"type": "formula",
"typeData": {
"formula": "{Total Quantity}-{Actual Quantity}"
}
},
"boardId": "615be38975138d0001c501a7",
"createdTime": "Mon Oct 25 00:52:14 GMT 2021",
"lastModifiedTime": "Mon Oct 25 00:58:15 GMT 2021"
}
}
}
Delete a Formula Field
mutation {
deleteFields(
boardId: "615be38975138d0001c501a7"
fieldId: "6175ffbe40dc970001b8f84f"
)
}
{
"data": {
"deleteFields": "SUCCESS"
}
}
Updated almost 3 years ago