🧊 Cube Make

Scenarios Resources
← Back to Scenarios

🔄 CS25 - Restock Bookings - P2 | form_id=7

⚠️ Needs ID 17 modules

Settings

Flow (click modules to expand)

google-sheets watch Rows #1
▶
google-sheets Sheet: Master List 2025
👁️ Master List 2025
error handler #2
from: drive
filter:
sheetId: Master List 2025
sortOrder: asc
spreadsheetId: 1RZsiZ33gaPQjig8ghX2yoxgTnlWZVdwsWLBdrHWhasA
tableFirstRow: A1:CZ1
includesHeaders: true
valueRenderOption: FORMATTED_VALUE
dateTimeRenderOption: FORMATTED_STRING
error Error Handler
▶
builtin Break #3
count: 2
retry: true
interval: 2
▶
clickup get ATask #10
task_id: {{2.`0`}}
map_or_select: map
▶
clickup 📅 {{2.`14`}} | {{2.`9`}} [{{upper(1.`5`)}}] error handler #4
name: 📅 {{2.`14`}} | {{2.`9`}} [{{upper(1.`5`)}}]
status: new booking
content: {{1.`7`}}
list_id: 900301922037
team_id: 9003069646
due_date: {{if(length(1.`6`) > 3; formatDate(1.`6`; "DD.MM.YYYY HH:mm"; "Australia/Melbourne"))}}
space_id: 90030159275
folder_id: 90031113641
notify_all: false
start_date: {{1.`1`}}
custom_fields:
021331c1-f2d2-46f3-8884-f4a5e4d1554e:{{lower(2.`11`)}}
1c622eab-213c-4db4-afc8-581dea59de35:TO DO
250322f5-4bc5-46f4-8892-d8e5dc4bf1dc:2a733a95-88a9-4486-ab01-1561157a80b3
32289ac6-a6a9-4ea3-ac61-5c3174e49ee1:{{ifempty(2.`15`; null; 2.`15`)}}
38342e07-00e4-46b4-9c95-4787e333497e:{{ifempty(1.`8`; null; 1.`8`)}}
41e4898d-c750-4b21-8d4a-94c1da9c3d16:PASTE IT HERE
458b0b11-25dd-4a1b-92a3-944bc59b52e4:{{1.`10`}}
4a66076a-dc1e-4759-a387-e9daa27b9e61:{{1.`14`}}
56ebc8e6-595e-4516-8886-1b36d68d366c:{{10.custom_fields.`🔢 MC Stocktake Date`}}
5e082707-b814-4195-b1fe-5a779d816655:{{if(1.`9` = "YES"; "5d3b2069-99eb-496e-b564-ae2c6dfa8bb0"; "f20fede7-6022-471c-8de1-5492fa2eefe8")}}
68705388-4235-4a74-bb76-8827669f7372:https://incube8r.com.au/wp-admin/options-general.php?page=adjust-stock-staff-{{1.`5`}}&user_id={{1.`3`}}
7f87c357-cf2e-47c0-aa60-13729e8c8f35:
805e6732-d1d5-46e1-acd4-886291737162:{{2.`46`}}
82985775-73e8-4c99-960b-4a0f3992c8ab:{{if(contains(1.`5`; "mc"); "b2be058b-c555-4409-bf2a-d01d2dfe47cb"; if(contains(1.`5`; "fz"); "126e0c8c-8876-4cbb-b2eb-74b1bae9572b"; ))}}
908cef4d-8607-45a8-9e01-901810662631:c40873de-a5e5-49ba-9661-53f3c039c953
b675a85b-7f70-40e3-9e4b-3de55623d2ec:60765223-a116-40d7-86ef-e3dacfb7d46a
b97b15fb-3961-42e4-b264-66292ae3fad7:{{if(contains(1.`5`; "mc"); "d8b4d3c8-3e7e-4da9-b03c-8efa0d42ac92"; if(contains(1.`5`; "fz"); "d1925f12-d4c1-482c-ad3a-4997bfd49cd0"; ))}}
bf487f31-f609-460a-abe7-7a45e897918b:https://incube8r.com.au/wp-admin/user-edit.php?user_id={{1.`3`}}
e11f77b0-38cc-4614-9d38-6a41c239723b:false
eaf2175d-3c46-40ca-88fd-b0c94ee73997:{{1.`7`}}
f1ccbb6e-42bb-4c04-add3-f4e04b6c6c09:false
f7a72424-777c-423d-bfbd-eb995bae4c0f:https://incube8r.com.au/cuber/{{2.`39`}}
fe1da3e7-ede1-462a-968b-6dfc55704233:{{10.custom_fields.`🔢 FZ Stocktake Date`}}
due_date_time: true
start_date_time: false
time_estimate_in: m
error Error Handler
▶
builtin Break #7
count: 2
retry: true
interval: 2
▶
clickup edit ATask With Custom Fields Advanced error handler #5
task_id: {{4.id}}
assignees:
custom_fields:
error Error Handler
▶
builtin Break #8
count: 2
retry: true
interval: 2
▶
google-sheets Sheet: Bookings (Fluent)
✏️ Bookings (Fluent)
error handler #6
from: drive
mode: select
values:
13:{{4.id}}
sheetId: Bookings (Fluent)
rowNumber: {{1.`__ROW_NUMBER__`}}
spreadsheetId: /1E_WeaMJsqPe5ZBDrzRxVFy-dtvhmZe36qVefVxv0KlY
includesHeaders: true
valueInputOption: USER_ENTERED
error Error Handler
▶
builtin Break #9
count: 2
retry: true
interval: 2
builtin Basic Router #15 3 routes
route Branch 1
▶
clickup Stocktake Due soon - Pls Bring Date Forward & Do Before Stock Adjustment #17
name: Stocktake Due soon - Pls Bring Date Forward & Do Before Stock Adjustment
status: booking task
content: https://app.clickup.com/9003069646/v/dc/8c9zw6e-22816/8c9zw6e-12036
list_id: 900301922037
team_id: 9003069646
due_date: {{5.custom_fields.`🔢 FZ Stocktake Date`}}
space_id: 90030159275
folder_id: 90031113641
notify_all: false
custom_fields:
7f87c357-cf2e-47c0-aa60-13729e8c8f35:
due_date_time: false
parent_task_id: {{4.id}}
start_date_time: false
▶
clickup edit ATask With Custom Fields Advanced #20
name: {{4.name}} 🚨
task_id: {{4.id}}
assignees:
route Branch 2
▶
clickup Stocktake Due soon - Pls Bring Date Forward & Do Before Stock Adjustment #18
name: Stocktake Due soon - Pls Bring Date Forward & Do Before Stock Adjustment
status: booking task
content: https://app.clickup.com/9003069646/v/dc/8c9zw6e-22816/8c9zw6e-12036
list_id: 900301922037
team_id: 9003069646
due_date: {{4.custom_fields.`🔢 MC Stocktake Date`}}
space_id: 90030159275
folder_id: 90031113641
notify_all: false
custom_fields:
7f87c357-cf2e-47c0-aa60-13729e8c8f35:
due_date_time: false
parent_task_id: {{4.id}}
start_date_time: false
▶
clickup edit ATask With Custom Fields Advanced #19
name: {{4.name}} 🚨
task_id: {{4.id}}
assignees:
route Branch 3
▶
clickup ⚖️This cuber often has stock issues #22
name: ⚖️This cuber often has stock issues
status: booking task
content: Check for problems and maybe scan in adjustment fresh
list_id: 900301922037
team_id: 9003069646
priority: high
space_id: 90030159275
folder_id: 90031113641
notify_all: false
custom_fields:
7f87c357-cf2e-47c0-aa60-13729e8c8f35:
due_date_time: false
parent_task_id: {{4.id}}
start_date_time: false
▶
clickup ⚖️{{4.name}} #21
name: ⚖️{{4.name}}
task_id: {{4.id}}
assignees: