Skip to content
Demo: Cross-Doc Actions via API (No Sync Tables Required!)
Quick Start
Copy doc
And please send feedback to jondallasjr@gmail.com! Thank you very much 🙏
GetCellValue()
Doc
Table
Row
Column
Get Cell Value
Value
Length
Copy Fetched Data
Real Talk Philosophy
Chapters
Hanoi, Vietnam
Local Chapter Leader
Get Cell Value
Amber Hoffmann
14
There are no rows in this table
PushButton()
Doc
Table
Rows
Column
Fetch Data from Coda Doc
Response
Connect to Cross-Doc Actions via API (No Sync Tables Required!)
grid-NzRsjzbDhI
{"Chapter":"Chiang Mai, Thailand","Date":"2021-07-07T15:00:00.000+02:00","Topic":"Comedy","Special Title":"","Weekday":"Wednesday","Venue":"Sheryle's","One-Time Paying Guests":28,"Actual Total Revenue USD":"$74.20","Revenue and Expenses Calculation Notes":"","Actual Royalty USD":"$11.13","Total Event Expenses":"$0.00","Event #":231,"Name":"#231: Comedy at Chiang Mai, Thailand, Wed, Jul 7, 2021","Event Resources":"What is Laughter? - Comedy,Implications of the false Alarm Theory of Laughter - Comedy,Laughing Villains VS. Serious Heroes - Comedy,Just a Joke - Comedy,Presenter Notes - Comedy,Webpage - Comedy,Event Recording - Comedy,Video Essay - Comedy,Video Essay - Comedy,Video Essay - Comedy,Song - Comedy,Banner Image - Comedy,Presentation - Comedy,What is a joke? - Comedy,Why do humans laugh? - Comedy,Are there some things we shouldn’t make jokes abou - Comedy,Is there a correlation between telling sexist joke - Comedy,Think of your favorite joke. Why is it funny? - Comedy,Have you ever heard a joke that you think went too - Comedy,Why does it feel bad when people laugh at us? - Comedy,Why is it funny to see someone fall and hurt thems - Comedy,Are men more likely than women to make jokes of se - Comedy,Is life a joke? What does this imply? - Comedy,Why would the Dalai Lama consider himself a profes - Comedy","Notes":"","Add Standard Event Tasks and Info to Team Canvas":"{\"formatType\":\"button\",\"disabled\":false}","Type":"Social Philosophy","Public Event Page":"","Single-Entry Price":"","Currency":"","Status":"Past","Banner":"IMG_0732.JPG","End Time":"","Start Time":"","Final Presentation Slides":"","Duplicate":"","Copy Upcoming Calendar to Clipboard":"","Date: Topic":"Wed, Jul 7, 2021: Comedy","Public Event Page QR Code":"","Intro Marquee Slides":"","Chapter-Specific Intro Slides":"","Haiku/Drawings":"","Haiku/Drawings Added to Bank":false,"Event Photos":"IMG_0968.JPG,IMG_0979.JPG,IMG_0916.JPG,IMG_0732.JPG,IMG_0977.JPG,IMG_0931.JPG,IMG_0856.JPG,IMG_0867.JPG,IMG_0766.JPG,IMG_0922.JPG,IMG_0998.JPG,IMG_0837.JPG,IMG_0812.JPG,IMG_0791.JPG,IMG_0880.JPG,IMG_0847.JPG,IMG_0992.JPG,IMG_1021.JPG,IMG_0771.JPG,IMG_0767.JPG,IMG_0948.JPG","Event Flyer":"","Combine Presentations":"","Presentations to Combine":"","Generate Public Thank You Message":"","Public Thank You Message":"","Copy Public Thank You Message":"{\"formatType\":\"button\",\"disabled\":true}","Special Notes to Include in Public Thank You":"","PUBLIC THANK YOU MESSAGE 2":"\n\n🙏 Public Thank You Message\nBased on everyone you selected in the team for the event (above), we can use AI to quickly generate a public thank you message. \nTeam: Be sure the team (above) is filled out correctly. \nSpecial Notes: If there is anyone to thank \nGenerate: Click the “Generate Public Thank You Message” button. In a few moments, a message will be generated by AI. \nEdit: After reading the message, edit it to ensure it sounds human-like 😆 \nPost: You can post this in your WhatsApp group, Facebook group, etc. ","LCL - EVENT INFO":"\n\n⏰ Event Information\nPlease fill out the information below about your event. \nOnce you decide on your event topic, date, and location, other content (like your event flyer) can be auto-generated. ","LCL - TEAM":"\n\n🥳 Team\nPlease fill in information about your team for this particular event. Keep this information updated as specifics about your team change throughout the week. ","LCL - EVENT RESOURCES":"\n\n📚 Event Resources\nIn the table below, you will find all of the event resources we currently have for the selected topic. \nWe may have some old Event Resources on Google Drive or Dropbox. \n","LCL - PRESENTATION SLIDES":"\n\n📽 Presentation Slides\nUse this tool to create the presentation slides for your event. \nDownload a backup version as a PDF or PPTX in case there are issues with the internet at the venue. ","LCL - EVENT PHOTOS":"\n\n📸 Photos\nSelect Photographer: Make sure you’ve selected a Photographer in the Team section above. \nUpload: Upload 10-20 of your best event photos to the /_subzFr8-\nTag your photos","LCL - HAIKU/DRAWINGS":"\n\n🎨 Haiku & Drawings","LCL - TURNOUT & FINANCES":"\n\n💸 Turnout and Finances\nOne-Time Paying Guests: \nNew Membership Card Sales: Enter the number of new membership card sales. \nIf someone purchased a new membership card after the event, include them here and remove them from the One-Time Paying Guests (because their one-time fee should have count towards their membership card; i.e., if someone paid $10 to get in, they should have paid $20 more dollars to buy a $30 membership card). \nReturning Members\nFree Guests: \nAdd to Notes: Include in the Free Guest Description field (below) who got in for free and why. ","Free Guests":"","New Membership Card Sales":"","Membership Card Uses":"","Calculated Total Revenue USD":"$0.00","Calculated Royalty USD":"$0.00","Event Expenses":"","Free Guest Description":"","Membership Card Price":"$0","Send Royalty":"","Royalty Sent Date":"","Royalty Status":"","Confirm Royalty Received":"","Royalty Received Date":"","Total Attendees":29,"Copy Event Flyer Template":"","Stage of Chapter Development":"","LCL - AFTER THE EVENT":"","LCL - PRINTING":"\n\n🖨️ Print","LCL - THE EVENT":"","Event Team Members":"Jon Dallas","Add Essential Team Members":"{\"formatType\":\"button\",\"disabled\":true}","Add Last Event's Team Members":"{\"formatType\":\"button\",\"disabled\":true}","Event Info":"Event Info\nDate: Wed, Jul 7, 2021\nTime: 30 mins (Doors )\nTopic: Comedy\nLocaton: Sheryle's\nChapter: Chiang Mai, Thailand\nEntry: (5 for $0)\nEvent #: 231\nTeam\nJon Dallas - Local Chapter Leader","Original Artwork":"Ethics of Comedy by Lara Hardie Stewart.png","Public Invitation Text":"","Past Event Photos":"IMG_1590.jpg,IMG_1589.jpg,1ad0da66-a425-4ce1-b1d9-7c2affd7a115.jpg,08da6a95-e982-4af1-aa2e-a7aba5ed73a1.jpg,2021.02.17 Ethics of Comedy Da Nang Photos by Mat and Valentina OG (3).jpeg,2021.02.17 Ethics of Comedy Da Nang Photos by Mat and Valentina OG (6).jpeg,2021.02.17 Ethics of Comedy Da Nang Photos by Mat and Valentina OG (7).jpeg,2021.02.17 Ethics of Comedy Da Nang Photos by Mat and Valentina OG (8).jpeg,2020.08.12 Comedy CMPF by Joanna Berg OG (5).jpg,2020.08.12 Comedy CMPF by Joanna Berg OG (25).jpg,2020.08.12 Comedy CMPF by Joanna Berg OG (26).jpg,2020.08.12 Comedy CMPF by Joanna Berg OG (44).jpg,109483060_417536815874236_6073246861815513658_n - Very Best.jpg,109483060_766339194111176_1774199624868022884_n.jpg,109835706_2347355738902673_3579655516779419088_n.jpg,115823637_289138315860450_818140279074324877_n.jpg,2019.11.13-14 Laughter by Carly Sanderson 2.jpeg,2019.11.13-14 Laughter by Carly Sanderson 23.jpeg,2019.11.13-14 Laughter by Carly Sanderson 13.jpeg,2019.11.13-14 Laughter by Carly Sanderson 24.jpeg","Past Haiku & Drawings":"#r108,#r109,#r110,#r111,#r112,#r113,#r114,#r115,#r116,#r117","Original Music":"Song - Comedy","Prompt to Generate Public Invitation Text":"<EVENT INFO>\nEvent Info\nDate: Wed, Jul 7, 2021\nTime: 30 mins (Doors )\nTopic: Comedy\nLocaton: Sheryle's\nChapter: Chiang Mai, Thailand\nEntry: (5 for $0)\nEvent #: 231\nTeam\nJon Dallas - Local Chapter Leader\n</EVENT INFO>\n<TEAM>\nEvent Info\nDate: Wed, Jul 7, 2021\nTime: 30 mins (Doors )\nTopic: Comedy\nLocaton: Sheryle's\nChapter: Chiang Mai, Thailand\nEntry: (5 for $0)\nEvent #: 231\nTeam\nJon Dallas - Local Chapter Leader\n</TEAM>\n","Copy Prompt to Generate Public Invitation Text":"","Team Canvas":"","Copy to clipboard":"","Copy Team Canvas from Last Event":"{\"formatType\":\"button\",\"disabled\":true}","Special Banner":"","Visibility":"Published","Local Chapter Leader":"Jon Dallas","Team Members":1,"Food & Drink Venue Sales":"","Calculated Entry Revenue":"$0.00","Percent of Food/Drink Revenue Received":"","Calculated Food & Drink Sale Revenue":"","Event Retrospectives":"","Profit Share Pool":"$63.07","Flat Fee Payments":"$0.00","Growth Fund Percent":"","Growth Fund Amount":"$0.00","Expense Report":"**Event #:** 231\n**Date:** Wed, Jul 7, 2021\n**Chapter:** Chiang Mai, Thailand\n**Topic/Title:** Comedy\n#Event Revenue\n## Entry\n**One-time ticket price:** \n**Membership Card Price:** $0\n**One-time paying guests:** 28\n**Membership Cards Sold:** \n**Membership Card Uses:** \n**Team Members:** 1\n**Free Guests:** \n**Free Guest Description:** \n**Total Attendees:* 29\n**Entry Revenue:** $0.00\n## Food & Drink Sales\n**Food and Drink Sales:** \n**Percent of Food/Drink Sales Received:** \n**Food & Drink Sales Revenue:** \n##Total\n**Calculated Total Revenue:** $0.00\n**Actual Total Revenue:** $74.20\n#Deductions\n**Flat Fee Team Members:** 0\n\n**Roalty Fee:** () $11.13\n**Growth Fund:** () $0.00\n**Event Expenses: **0\n","Save Expense Report":"","Food & Drink Sales per Guest":"$0.00","Deductions":"$11","Royalty Percent":"","c-Gs9Mq2Hpmo":"IMG_0732.JPG,IMG_0766.JPG,IMG_0812.JPG,IMG_0791.JPG,IMG_0880.JPG,IMG_0992.JPG,IMG_1021.JPG,IMG_0948.JPG","c-xI3mDGLUCw":"IMG_0732.JPG"}
c-ONMdSKvu0-
Push Button
There are no rows in this table
AddOrModifyRows()
Doc
Table
Key Column
Key Column Value
Column/Value Pairs CSV
Fetch Data from Coda Doc
Response
Real Talk Philosophy
Chapters
Chapter
Sea Girt, New Jersey
Add or Modify Row
{
"requestId": "mutate:d21b1645-f3f3-4a20-8950-b42061e0fa44",
"status": "Upsert queued (processed within seconds)",
"keyColumn": "c-atYYNJhJ2v",
"columnsSet": 1,
"action": "updated (or will update matching rows)"
}
There are no rows in this table
Copy Doc
Doc
Doc ID
New Doc Title
Fetch Data from Coda Doc
New Doc URL
Response
u41r59VdhB
Copy Doc
{
"requestId": "copy_doc:u41r59VdhB:FPslgigKVw",
"docId": "FPslgigKVw",
"name": "Real Talk Philosophy",
"browserLink": "https://coda.io/d/_dFPslgigKVw",
"folderId": "fl-NElpCeo-Us",
"workspaceId": "ws-Ycq4MJMMTN",
"createdAt": "2025-10-29T22:15:17.329Z",
"status": "Doc copy created successfully"
}
There are no rows in this table
fetchTableData()
Doc
Table
Columns
Metadata to Include
Filter
Num Rows
Format
Fetch Data from Coda Doc
Data
Length
Copy Fetched Data
Connect to Cross-Doc Actions via API (No Sync Tables Required!)
grid-NzRsjzbDhI
c-fDLwyghEW0
c-7RaGRUplt2
c-fqgvyjbT4n
c-Hgam24iiUV
c-Nlz8hU_16H
c-SXlCIZaKbC
_rowId_rowIndextypeformuladefaultValuerelationName
5
csv
Fetch Data
# Source: Doc u41r59VdhB, Table grid-NzRsjzbDhI
# Rows: 5
# Generated: 2025-10-21T21:07:53.871Z
# Metadata Included: _rowId, _rowIndex, type, formula, defaultValue, relationName
# WARNING: Reached maxRows limit (5)
6,182
Connect to Cross-Doc Actions via API (No Sync Tables Required!)
grid-NzRsjzbDhI
c-fDLwyghEW0
c-7RaGRUplt2
c-fqgvyjbT4n
c-Hgam24iiUV
c-Nlz8hU_16H
c-SXlCIZaKbC
_rowId_rowIndextypeformuladefaultValuerelationName
5
json
Fetch Data
{
"data": [
{
"_rowId": "i-Bi4oFfbm8G",
"_rowIndex": 236,
"Chapter": {
"value": [
{
"name": "i, Indone"
}
],
"type": {
"table": {
"id": "grid-_MuMmBB_9n",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-_MuMmBB_9n",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-_MuMmBB_9n",
"name": "Chapters"
},
"type": "lookup",
"isArray": true
},
"defaultValue": "Team.filter([Coda Account].contains(user())).Chapter"
},
"Date": {
"value": "1-11-19T01:42:59.000+02",
"type": {
"dateFormat": "ddd, MMM D, YYYY",
"type": "dateTime",
"isArray": false
},
"defaultValue": "max(today()+7,Events.filter(Chapter=Chapter).Date.max()+7)"
},
"Topic": {
"value": {
"name": "yam"
},
"type": {
"table": {
"id": "grid-bkc6AUt8Zz",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-bkc6AUt8Zz",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-bkc6AUt8Zz",
"name": "Topics"
},
"type": "lookup",
"isArray": false
}
},
"Actual Total Revenue USD": {
"value": "",
"type": {
"currencyCode": "USD",
"precision": 2,
"format": "currency",
"type": "currency",
"isArray": false
}
},
"Event #": {
"value": 232,
"type": {
"precision": 22,
"useThousandsSeparator": false,
"type": "number",
"isArray": false
},
"formula": "find(thisRow,[Events DB].sort(true,Date))"
},
"Notes": {
"value": "",
"type": {
"type": "text",
"isArray": false
}
}
},
{
"_rowId": "i-bdwAZyUfUk",
"_rowIndex": 235,
"Chapter": {
"value": [
{
"name": "are, Zimba"
}
],
"type": {
"table": {
"id": "grid-_MuMmBB_9n",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-_MuMmBB_9n",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-_MuMmBB_9n",
"name": "Chapters"
},
"type": "lookup",
"isArray": true
},
"defaultValue": "Team.filter([Coda Account].contains(user())).Chapter"
},
"Date": {
"value": "4-08-15T21:47:26.000+02",
"type": {
"dateFormat": "ddd, MMM D, YYYY",
"type": "dateTime",
"isArray": false
},
"defaultValue": "max(today()+7,Events.filter(Chapter=Chapter).Date.max()+7)"
},
"Topic": {
"value": {
"name": "yam"
},
"type": {
"table": {
"id": "grid-bkc6AUt8Zz",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-bkc6AUt8Zz",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-bkc6AUt8Zz",
"name": "Topics"
},
"type": "lookup",
"isArray": false
}
},
"Actual Total Revenue USD": {
"value": {
"@context": "http://schema.org/",
"@type": "MonetaryAmount",
"currency": "USD",
"amount": 787
},
"type": {
"currencyCode": "USD",
"precision": 2,
"format": "currency",
"type": "currency",
"isArray": false
}
},
"Event #": {
"value": 236,
"type": {
"precision": 22,
"useThousandsSeparator": false,
"type": "number",
"isArray": false
},
"formula": "find(thisRow,[Events DB].sort(true,Date))"
},
"Notes": {
"value": "",
"type": {
"type": "text",
"isArray": false
}
}
},
{
"_rowId": "i-jvROM2l-P9",
"_rowIndex": 234,
"Chapter": {
"value": [
{
"name": "are, Zimba"
}
],
"type": {
"table": {
"id": "grid-_MuMmBB_9n",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-_MuMmBB_9n",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-_MuMmBB_9n",
"name": "Chapters"
},
"type": "lookup",
"isArray": true
},
"defaultValue": "Team.filter([Coda Account].contains(user())).Chapter"
},
"Date": {
"value": "4-10-03T05:37:25.000+02",
"type": {
"dateFormat": "ddd, MMM D, YYYY",
"type": "dateTime",
"isArray": false
},
"defaultValue": "max(today()+7,Events.filter(Chapter=Chapter).Date.max()+7)"
},
"Topic": {
"value": {
"name": "sciousn"
},
"type": {
"table": {
"id": "grid-bkc6AUt8Zz",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-bkc6AUt8Zz",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-bkc6AUt8Zz",
"name": "Topics"
},
"type": "lookup",
"isArray": false
}
},
"Actual Total Revenue USD": {
"value": "",
"type": {
"currencyCode": "USD",
"precision": 2,
"format": "currency",
"type": "currency",
"isArray": false
}
},
"Event #": {
"value": 237,
"type": {
"precision": 22,
"useThousandsSeparator": false,
"type": "number",
"isArray": false
},
"formula": "find(thisRow,[Events DB].sort(true,Date))"
},
"Notes": {
"value": "",
"type": {
"type": "text",
"isArray": false
}
}
},
{
"_rowId": "i-NVgYpo9Cy8",
"_rowIndex": 233,
"Chapter": {
"value": [
{
"name": "are, Zimba"
}
],
"type": {
"table": {
"id": "grid-_MuMmBB_9n",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-_MuMmBB_9n",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-_MuMmBB_9n",
"name": "Chapters"
},
"type": "lookup",
"isArray": true
},
"defaultValue": "Team.filter([Coda Account].contains(user())).Chapter"
},
"Date": {
"value": "3-07-04T00:00:00.000+02",
"type": {
"dateFormat": "ddd, MMM D, YYYY",
"type": "dateTime",
"isArray": false
},
"defaultValue": "max(today()+7,Events.filter(Chapter=Chapter).Date.max()+7)"
},
"Topic": {
"value": {
"name": "ic Masculin"
},
"type": {
"table": {
"id": "grid-bkc6AUt8Zz",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-bkc6AUt8Zz",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-bkc6AUt8Zz",
"name": "Topics"
},
"type": "lookup",
"isArray": false
}
},
"Actual Total Revenue USD": {
"value": {
"@context": "http://schema.org/",
"@type": "MonetaryAmount",
"currency": "USD",
"amount": 100
},
"type": {
"currencyCode": "USD",
"precision": 2,
"format": "currency",
"type": "currency",
"isArray": false
}
},
"Event #": {
"value": 235,
"type": {
"precision": 22,
"useThousandsSeparator": false,
"type": "number",
"isArray": false
},
"formula": "find(thisRow,[Events DB].sort(true,Date))"
},
"Notes": {
"value": "",
"type": {
"type": "text",
"isArray": false
}
}
},
{
"_rowId": "i-2FxB04bjlX",
"_rowIndex": 232,
"Chapter": {
"value": [
{
"name": "are, Zimba"
}
],
"type": {
"table": {
"id": "grid-_MuMmBB_9n",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-_MuMmBB_9n",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-_MuMmBB_9n",
"name": "Chapters"
},
"type": "lookup",
"isArray": true
},
"defaultValue": "Team.filter([Coda Account].contains(user())).Chapter"
},
"Date": {
"value": "3-06-27T00:00:00.000+02",
"type": {
"dateFormat": "ddd, MMM D, YYYY",
"type": "dateTime",
"isArray": false
},
"defaultValue": "max(today()+7,Events.filter(Chapter=Chapter).Date.max()+7)"
},
"Topic": {
"value": {
"name": "es of Dating, Sex, and Cons"
},
"type": {
"table": {
"id": "grid-bkc6AUt8Zz",
"type": "table",
"tableType": "table",
"href": "https://coda.io/apis/v1/docs/u41r59VdhB/tables/grid-bkc6AUt8Zz",
"browserLink": "https://coda.io/d/_du41r59VdhB#_tugrid-bkc6AUt8Zz",
"name": "Topics"
},
"type": "lookup",
"isArray": false
}
},
"Actual Total Revenue USD": {
"value": {
"@context": "http://schema.org/",
"@type": "MonetaryAmount",
"currency": "USD",
"amount": 16
},
"type": {
"currencyCode": "USD",
"precision": 2,
"format": "currency",
"type": "currency",
"isArray": false
}
},
"Event #": {
"value": 234,
"type": {
"precision": 22,
"useThousandsSeparator": false,
"type": "number",
"isArray": false
},
"formula": "find(thisRow,[Events DB].sort(true,Date))"
},
"Notes": {
"value": "",
"type": {
"type": "text",
"isArray": false
}
}
}
],
"metadata": {
"rowCount": 5,
"docId": "u41r59VdhB",
"tableId": "grid-NzRsjzbDhI",
"timestamp": "2025-10-24T07:52:22.047Z",
"columnsRequested": "c-fDLwyghEW0,c-7RaGRUplt2,c-fqgvyjbT4n,c-Hgam24iiUV,c-Nlz8hU_16H,c-SXlCIZaKbC",
"filterApplied": "none",
"metadataIncluded": [
"_rowId",
"_rowIndex",
"type",
"formula",
"defaultValue",
"relationName"
],
"warnings": [
"Reached maxRows limit (5)"
]
}
}
11,401
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.