Column 0 not found error (even when my column names are fine)

💬 App Building
1

image
image1028×270 20.5 KB

[{"id": {{ formatDataAsArray(skusNotInPO.data).find(sku => sku.unique_sku_id === recentSkuAdded.value)?.unique_sku_firestore_id || null}},
"sku":  {{ formatDataAsArray(skusNotInPO.data).find(sku => sku.unique_sku_id === recentSkuAdded.value)?.unique_sku_english_description || null }},
"qty": 0,
"payable": 0,
"cp": {{poTable.data.invoice_consumer_price_pkr[poTable.data.sku_firestore_id.length -1 ]}},
"comment": null,
"vendor_invoice_code": null,
"vendor_sku_tax_type": {{  poTable.data.vendor_sku_tax_type[poTable.data.sku_firestore_id.length -1 ]}},
"tierage": {{  poTable.data.invoice_selling_units_per_procurement_unit[poTable.data.sku_firestore_id.length]}},
"advance_tax": {{  advanceTaxPct.data.advance_tax_pct[0] }} / 100.0,
"per_unit_pp_with_tax": `=D{{  poTable.data.sku_firestore_id.length}}/(C{{  poTable.data.sku_firestore_id.length + 2}}*I{{  poTable.data.sku_firestore_id.length + 2}})`,
"advance_tax_ratio": `=1+J{{  poTable.data.sku_firestore_id.length}}`,
"advance_tax_rs": `=(K{{  poTable.data.sku_firestore_id.length}}/L{{  poTable.data.sku_firestore_id.length}})*(L{{  poTable.data.sku_firestore_id.length}}-1)`,
"pp_pre_advance_tax": `=K{{  poTable.data.sku_firestore_id.length}}/L{{  poTable.data.sku_firestore_id.length}}`,
"sales_tax_ratio": `=IFS(H{{  poTable.data.sku_firestore_id.length}}="VAT", 1.18, H{{  poTable.data.sku_firestore_id.length}}="VAT (imported)", 1.25, H{{poTable.data.sku_firestore_id.length}}="3rd Schedule", 1.18, H{{poTable.data.sku_firestore_id.length}}="3rd Schedule (imported)", 1.25, H{{  poTable.data.sku_firestore_id.length}}="8th Schedule", 1.1, H{{poTable.data.sku_firestore_id.length}}="No Tax", 1)`,
"sales_tax_rs": `=IF(AND(H{{poTable.data.sku_firestore_id.length}}<>"3rd Schedule",H{{poTable.data.sku_firestore_id.length}}<>"3rd Schedule (imported)"),(N{{poTable.data.sku_firestore_id.length}}/O{{  poTable.data.sku_firestore_id.length}})*(O{{  poTable.data.sku_firestore_id.length}}-1),(E{{  poTable.data.sku_firestore_id.length}}/O{{  poTable.data.sku_firestore_id.length}})*(O{{  poTable.data.sku_firestore_id.length}}-1))`,
"total_sales_tax_rs":`=P{{poTable.data.sku_firestore_id.length}}*C{{poTable.data.sku_firestore_id.length}}*I{{  poTable.data.sku_firestore_id.length}}`,
"vendor_price_rs_pre_taxes": `=N{{poTable.data.sku_firestore_id.length}}/O{{poTable.data.sku_firestore_id.length}}`,
"total_tax_rs": `=P{{poTable.data.sku_firestore_id.length}}+M{{  poTable.data.sku_firestore_id.length}}`}]

I am trying to append data to my google sheet. Kindly help me debug what's the issue over here.

2

Hey @engineering-tajir

There is a some columns name you passing in data is not exited in google sheet , so for it from the using transformer filter out the data and append to the google sheet.

3 Likes