Pack Building Roadmap - Maker Stories Webinar

Share

Explore

Pack Data & Formulas

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

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.