← ClaudeAtlas

apply-splits-on-copyright-change-for-song-entrieslisted

Build a Zap on Zapier that recalculates and writes split percentages on a song item in a monday.com board whenever its copyright or allocation column changes, based on how many co-writers the song has. Use when a music publisher, label or songwriting team tracks royalty splits in monday.com and wants them recalculated without manual edits.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
Install: claude install-skill zapier/awesome-zaps
# Apply splits on copyright change for song entries The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/apply-splits-on-copyright-change-for-song-entries. Read the files there if this skill was installed on its own. ## What it does 1. **Trigger:** a column value changes on a monday.com board (`monday`, `column_value_changed_in_board`). Any column can fire it; the code keeps only changes to the allocation column. 2. **Filter:** the run stops unless the changed column is the allocation column and the song has at least one co-writer. A song with more than five co-writers stops with a reason instead of getting partial splits. 3. **Calculate:** each co-writer gets an equal share rounded down to two decimals (1 gets 100, 2 get 50, 3 get 33.33, 4 get 25, 5 get 20). The main percentage column gets the sum of the written shares. 4. **monday.com** updates the item in one call: the split column for each co-writer slot and the main percentage column. The zap overwrites existing split values, so point it at the board whose splits you intend to change. ## Ask the user Each `REPLACE_…` value is set per person. Resolve names to IDs with the user's own connections; don't ask them to paste an ID you can look up. | Setting | Where | What goes there