Gallery
Pack Building Roadmap - Maker Stories Webinar
Share
Explore
Gallery
Pack Building Roadmap - Maker Stories Webinar
Pack Data & Formulas

icon picker
My Pack Formulas

Pack Formula 1 - TBCountries()

Returns all COUNTRY NAMES and URLs in the travelbrief.org database
Output:
⁠
Afghanistan
Aland Islands
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antigua and Barbuda
Argentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Azores
Bahamas
Bahrain
Balearic Islands
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bonaire
Bosnia and Herzegovina
 Show 226 more
⁠
⁠
Extract the COUNTRY NAMES with the ParseJSON formula from the TBCountries() results
Formula Name: SELECTCOUNTRY
Formula Text:
FormulaMap(TBCountries,ParseJSON(CurrentValue,"$.name"))
⁠
⁠
⁠
AfghanistanAland IslandsAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntigua and BarbudaArgentinaArmeniaArubaAustraliaAustriaAzerbaijanAzoresBahamasBahrainBalearic IslandsBangladeshBarbadosBelarusBelgiumBelizeBeninBermudaBhutanBoliviaBonaireBosnia and Herzegovina Show 226 more
⁠
⁠

Pack Formula 2 - TravelBriefData(”Belgium”)

Returns the travel data from the travelbrief.org database for the selected country
The pack formula is used in the Name column of the
TravelBriefData
⁠
table.
Use the dot operator to display related data returned from the API in other table columns.
TravelBriefData (Table view)
⁠
Examples for Belgium:
TravelBriefData.timezone
Europe/Copenhagen
⁠
⁠
TravelBriefData.currency
Danish Krone
⁠
⁠
⁠

Addendum: Overview of ParseJSON Coda formula

ParseJSON(jsonString, path)
Object
Parses a JSON string
ParseJSON('{"name": "Mike", "location": "New York"}', "$.name")
Output: Mike
REQUIRED INPUTS
jsonStringA JSON string.
For example: '{"name": "Bob", "age": 42}'
OUTPUT
Outputs the value parsed from jsonString at path. If path is not specified, outputs the entire parsed value.
⁠
⁠
Data & Formulas
⁠
⁠
Pack Formula 1 - TBCountries()
Pack Formula 2 - TravelBriefData(”Belgium”)
Addendum: Overview of ParseJSON Coda formula
Gallery
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.