column "0" not found!

💬 App Building
1

image
image1322×310 32.3 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]}},
      "comment": null,
      "vendor_invoice_code": null,
      "vendor_sku_tax_type": {{  poTable.data.vendor_sku_tax_type[poTable.data.sku_firestore_id.length]}},
      "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}}*I{{  poTable.data.sku_firestore_id.length}})`,
      "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}}`
]}

Team, kindly help.

2

Hello @Sadia_Umar, Welcome To The Retool Community!

You can pass values as integers or numbers in a string format. The system will interpret them as columns. I recommend passing the value 0 as an integer or number.

Let me know if you need any assistance!

3 Likes
3

Hi @Sadia_Umar,

Thanks for reaching out! Are you still looking into this? Can you share the schema and query? What resource type are you using?