Hi @Marwin Martina,
What you want to do is possible but it requires some advanced Zapier setup.
To change a specific value in Monday.com you need to know the “board_id”, “item_id”, and “column_id” which can only be found using a Zapier code step.
The basics are:
- Trigger off of Acuity Reschedule
- Use a code step to search for the item_id and column_id
- You will need a term you can use for the search that is unique. Something like email works well
- “Update Item Date Column Value” which takes the item_id and column_id form step 2 to insert the new date and time
Here is the basic code. You will need to put in your own API_Key and boardId values and make sure you use an “email” column to store the persons email.
const API_KEY = "xxxxxxxx",
boardId = 0000000;
const sendRequest = async (payload) => {
const response = await fetch("https://api.monday.com/v2/", {
method: "POST",
body: JSON.stringify(payload),
headers: {
"content-type": "application/json",
authorization: API_KEY,
},
});
const results = await response.json();
return results;
};
const getItem = async () => {
const query = `
query {
items_by_column_values (board_id: ${boardId}, column_id: "email", column_value: "${inputData.email}") {
id
name
}
}`;
const response = await sendRequest({
query,
});
const results = response.datat'items_by_column_values']'0].id;
return results;
};
const response = await getItem();
output = {
id: response
};