Hi,
I’m kind of stuck currently.
I try to generate google slides document out of a template wit variable values marked with {{ }}.
The data source is airtable where I have stored customer data. After some hick ups it works now.
One issue still persists: I take the values out of airtable and define them as variables. After that I use the “replace text” module of google slides.
module 1 - airtable - output
[
{
"contract_id": 9,
"start_date": "2024-04-27",
"end_date": "2024-05-15",
"mileage_allowance(permonth)": 1000,
"deductible": "1000",
"contract_status": "generate_contract",
"minimum_term": 2,
"total_driven_mileage": "not ended yet",
"price_extramileage": 0.15,
"monthly_fee": 99,
"car_id": [
"reciWgIsQe5I8nXCu"
],
"license_plate (from car_id)": [
"B-TS1234E"
],
"VIN (from car_id)": [
"FHSM4854IFR4594F3"
],
"car_model (from car_id)": [
"Test Model"
],
"car_brand (from car_id)": [
"Test brand"
],
"# (from car_id)": [
1274
],
"deposit": 0,
"customer": [
"recNXzodNyajWPVqT"
],
"Country (from customer)": [
"DE"
],
"City (from customer)": [
"München"
],
"ZIP (from customer)": [
"80796"
],
"Address_line_1 (from customer)": [
"Teststr. 3"
],
"birthplace (from customer)": [
"Zurich"
],
"birthdate (from customer)": [
"1980-12-01"
],
"phone (from customer)": [
"+4912345678910"
],
"language (from customer)": [
"de-DE"
],
"email (from customer)": [
"test.mail@gmail.com"
],
"Name (from customer)": [
"Test Mustermann"
],
"last_status_change": "2024-04-26T08:54:55.000Z",
"payment_type": "Kreditkarte",
"record_id": "recRl46YLFpSd0qde",
"driver": [
"recS4s7cnueCsqHlH"
],
"Zweitfahrer erwünscht? (from driver)": [
null
],
"Verifizierungsstatus (from driver)": [
"accepted"
],
"Führerscheinnummer (from driver)": [
"A78378934B3"
],
"Ablaufdatum / Ausstellungsdatum (from driver)": [
"2022-01-01"
],
"email (from driver)": [
"test@test.de"
],
"Name (from driver)": [
"Test Driver"
],
"driver_license_id (from driver)": [
21
],
"setup_fee": 0,
"id": "recRl46YLFpSd0qde",
"createdTime": "2024-04-26T08:46:25.000Z"
}
]
module 2 - set variables - input
[
{
"scope": "roundtrip",
"variables": [
{
"name": "customer_name",
"value": "[Test Mustermann]"
},
{
"name": "address",
"value": "[Teststr. 3]\n[80796]\n[München]"
},
{
"name": "birthdate",
"value": "[1980-12-01]"
},
{
"name": "birthplace",
"value": "[Zurich]"
},
{
"name": "payment_type",
"value": "Kreditkarte"
},
{
"name": "license_plate",
"value": "[B-TS1234E]"
},
{
"name": "vin",
"value": "[FHSM4854IFR4594F3]"
},
{
"name": "start_date",
"value": "27.04.2024"
},
{
"name": "end_date",
"value": "15.05.2024"
},
{
"name": "signature_date",
"value": "26.04.2024"
},
{
"name": "deposit",
"value": "0"
},
{
"name": "deductible",
"value": "1000"
},
{
"name": "extmileage",
"value": "0.15"
},
{
"name": "included_mileage",
"value": "1000"
},
{
"name": "car",
"value": "[Test brand] [Test Model]"
},
{
"name": "car_color",
"value": "weiss"
},
{
"name": "setup_fee",
"value": 0
}
]
}
]
module 2 - set variables - output
[
{
"customer_name": "[Test Mustermann]",
"address": "[Teststr. 3]\n[80796]\n[München]",
"birthdate": "[1980-12-01]",
"birthplace": "[Zurich]",
"payment_type": "Kreditkarte",
"license_plate": "[B-TS1234E]",
"vin": "[FHSM4854IFR4594F3]",
"start_date": "27.04.2024",
"end_date": "15.05.2024",
"signature_date": "26.04.2024",
"deposit": "0",
"deductible": "1000",
"extmileage": "0.15",
"included_mileage": "1000",
"car": "[Test brand] [Test Model]",
"car_color": "weiss",
"setup_fee": 0
}
]
Some of the values are printed with brakets like following:
The output of the airtable modul is this:
Some other values are printed correctly.
What is causing those brakets? I could work now with transforming the text but I rather want to solve the root cause to solve it.
blueprint (2).json (106.1 KB)
