{
"App":"{App}",
"Table":"{Table}",
"RowID":"{RowID}",
"AccID":"{AccID}",
"AccName":"{AccName}",
"BusinessID":"{BusinessID}",
"CompanyName":"{CompanyName}",
"UEN":"{UEN}",
"Country":"{Country}",
"Website":"{Website}",
"Address1":"{Address1}",
"Address2":"{Address2}",
"PostalCode":"{PostalCode}",
"WA":"{WA}",
"Email":"{Email}",
"SupportWA":"{SupportWA}"
}

import * as glide from "@glideapps/tables";

const clientsTable = glide.table({
    token: "a34d88da-e866-47c1-8b07-c8f805514f31",
    app: "JZgNvUXlV8M7lEqWawFa",
    table: "native-table-jSXvMG6omlHj5owuoO9E",
    columns: {
        accId: { type: "string", name: "Upoqg" },
        accName: { type: "string", name: "3Rzae" },
        businessId: { type: "string", name: "AFYtA" },
        companyName: { type: "string", name: "Name" },
        companyUen: { type: "string", name: "xPAs7" },
        companyCountry: { type: "string", name: "CFlAF" },
        companyWebsite: { type: "string", name: "Rhz6K" },
        contactAddress1: { type: "string", name: "FJI5D" },
        contactAddress2: { type: "string", name: "0MXQ8" },
        contactPostalCode: { type: "string", name: "uLl4m" },
        contactWa: { type: "string", name: "G7ML1" },
        contactEmail: { type: "email-address", name: "wNTSn" },
        contactCcEmail: { type: "email-address", name: "4yYNI" },
        supportWa: { type: "string", name: "5BJl7" },
        picRowId: { type: "string", name: "tzIf5" },
        financeRowId: { type: "string", name: "XblAT" },
        hrRowId: { type: "string", name: "6Zuso" }
    }
});

await clientsTable.update(clientsID, {
    // Add columns here
});



{
"App":"{App}",
"Table":"{Table}",
"RowID":"{RowID}",
"ClientId":"{ClientId}",
"Name":"{Name}",
"Designation":"{Designation}",
"Mobile":"{Mobile}",
"Email":"{Email}"
}

{
"App":"{App}",
"Table":"{Table}",
"RowID":"{RowID}",
"BusinessID":"{BusinessID}",
"No":"{InvoiceNo}",
"Date":"{InvoiceDate}",
"Date":"{Description}",

"CompanyName":"{CompanyName}",
"UEN":"{UEN}",
"Country":"{Country}",
"Website":"{Website}",
"Address1":"{Address1}",
"Address2":"{Address2}",
"PostalCode":"{PostalCode}",
"WA":"{WA}",
"Email":"{Email}",
"CcEmail":"{CcEmail}",
"SupportWA":"{SupportWA}"
}

{
"App":"{App}",
"Table":"{Table}",
"RowID":"{RowID}",
"BusinessID":"{BusinessID}",
"BusinessName":"{BusinessName}",
"InvoiceFolder":"{InvoiceFolder}",
"Folder":"{InvoiceFolder}",


"Date":"{InvoiceDate}",
"Date":"{Description}",

{
"RowID":"{RowID}",
"TemplateID":"{TemplateID}",
"BusinessId":"{BusinessID}",
"Name":"{Name}",
"DocID":"{DocID}"
}

{
"Currency":"{Currency}",
"Year":"{Year}",
"Service1":"{Service1}",
"Service2":"{Service2}",
"Period":"{Period}",
"DiscountType":"{DiscountType}",
"DiscountAmt":"{DiscountAmt}",
"Remarks":"{Remarks}",
"BankInfo1":"{BankInfo1}",
"BankInfo2":"{BankInfo2}"
}

import * as glide from "@glideapps/tables";

const templatesDbTable = glide.table({
    token: "a34d88da-e866-47c1-8b07-c8f805514f31",
    app: "JZgNvUXlV8M7lEqWawFa",
    table: "native-table-3VZo7rMFXjG55XxUkCb2",
    columns: {
        templateId: { type: "string", name: "GLVf6" },
        templateType: { type: "string", name: "Xfrfv" },
        templateName: { type: "string", name: "M30Uo" },
        templateDocId: { type: "string", name: "L6vv0" },
        businessId: { type: "string", name: "Name" },
        uiCurrency: { type: "string", name: "Nkkaz" },
        uiService1: { type: "string", name: "oUykT" },
        uiService2: { type: "string", name: "s7QMr" },
        uiPeriod: { type: "string", name: "MeQB6" },
        uiDiscountType: { type: "string", name: "OOuiY" },
        uiDiscountAmt: { type: "string", name: "OVsWP" },
        uiRemarks: { type: "string", name: "pEOf8" },
        uiBankInfo1: { type: "string", name: "uLVL1" },
        uiBankInfo2: { type: "string", name: "ktu9o" }
    }
});

await templatesDbTable.update(templatesDbID, {
    // Add columns here
});



{
"RowID":"{RowID}",
"InvoiceNo":"{InvoiceNo}",
"InvoiceDate":"{InvoiceDate}",
"DueDate":"{DueDate}",
"Description":"{Description}",
"Period":"{Period}",
"Service1":"{Service1}",
"Service2":"{Service2}",
"UnitAmt":"{UnitAmt}",
"Unit":"{Unit}",
"DiscountType":"{DiscountType}",
"DiscountAmt":"{DiscountAmt}",
"InvoiceNetAmt":"{InvoiceNetAmt}",
"OutstandingAmt":"{OutstandingAmt}",
"Remarks":"{Remarks}",
"DocID":"{DocID}",
"DocLink":"{DocLink}",
"CreatedWhen":"{CreatedWhen}",
"CreatedBy":"{CreatedBy}",
"CreatedBy":"{CreatedBy}"
}

import * as glide from "@glideapps/tables";

const invoicesDbTable = glide.table({
    token: "a34d88da-e866-47c1-8b07-c8f805514f31",
    app: "JZgNvUXlV8M7lEqWawFa",
    table: "native-table-EpQuqkdMQVnweyh7UvFP",
    columns: {
        businessId: { type: "string", name: "VPQ2O" },
        payorId: { type: "string", name: "0BJhB" },
        templateId: { type: "string", name: "jtIWl" },
        invoiceNo: { type: "string", name: "n7tZw" },
        invoiceDate: { type: "date-time", name: "UqJ5Q" },
        invoiceDescription: { type: "string", name: "0HpWo" },
        invoiceUnitAmt: { type: "number", name: "FQMdw" },
        invoiceUnit: { type: "number", name: "73m1t" },
        invoiceService1: { type: "string", name: "0fv5H" },
        invoiceService2: { type: "string", name: "XukXD" },
        invoicePeriod: { type: "string", name: "QUQL1" },
        invoiceDiscountType: { type: "string", name: "qqDr4" },
        invoiceDiscountAmt: { type: "number", name: "dcTz0" },
        invoiceRemarks: { type: "string", name: "oJv8a" },
        docId: { type: "string", name: "iVSFR" },
        timeStampCreatedWhen: { type: "date-time", name: "InLZm" },
        timeStampCreatedBy: { type: "string", name: "yh9KO" },
        timeStampCreatedEmail: { type: "email-address", name: "FPYRN" }
    }
});

await invoicesDbTable.update(invoicesDbID, {
    // Add columns here
});


{
"App":"{App}",
"Table":"{Table}",
"RowID":"{RowID}",
"InvoiceNo":"{InvoiceNo}",
"InvoiceDate":"{InvoiceDate}",
"DueDate":"{DueDate}",
"Description":"{Description}",
"Period":"{Period}",
"Service1":"{Service1}",
"Service2":"{Service2}",
"UnitAmt":"{UnitAmt}",
"Unit":"{Unit}",
"DiscountType":"{DiscountType}",
"DiscountAmt":"{DiscountAmt}",
"InvoiceNetAmt":"{InvoiceNetAmt}",
"OutstandingAmt":"{OutstandingAmt}",
"Remarks":"{Remarks}",
"DocID":"{DocID}",
"DocLink":"{DocLink}",
"CreatedWhen":"{CreatedWhen}",
"CreatedBy":"{CreatedBy}"
}

{
"Fee1Name":"{Fee1Name}",
"Fee1UnitAmt":"{Fee1UnitAmt}",
"Fee1Unit":"{Fee1Unit}",
"Fee1Gross":"{Fee1Gross}",
"Fee2Name":"{Fee2Name}",
"Fee2UnitAmt":"{Fee2Amt}",
"Fee2Unit":"{Fee2Unit}",
"Fee2Gross":"{Fee2Gross}"
}

{
"WA":"{WA}",
"FinanceEmail":"{FinanceEmail}",
"CSEmail":"{CSEmail}"
}

import * as glide from "@glideapps/tables";

const invoicesDbTable = glide.table({
    token: "XXX",
    app: "XXXX",
    table: "XXXX",
    columns: {
        businessId: { type: "string", name: "VPQ2O" },
        payorId: { type: "string", name: "0BJhB" },
        templateId: { type: "string", name: "jtIWl" },
        invoiceNo: { type: "string", name: "n7tZw" },
        invoiceDate: { type: "date-time", name: "UqJ5Q" },
        invoiceDescription: { type: "string", name: "0HpWo" },
        feeItem1Name: { type: "string", name: "0fv5H" },
        feeItem1Amt: { type: "number", name: "FQMdw" },
        feeItem1UnitNo: { type: "number", name: "73m1t" },
        feeItem2Name: { type: "string", name: "XukXD" },
        feeItem2Amt: { type: "number", name: "PakHc" },
        feeItem2UnitNo: { type: "number", name: "YkSvL" },
        invoicePeriod: { type: "string", name: "QUQL1" },
        invoiceDiscountType: { type: "string", name: "qqDr4" },
        invoiceDiscountAmt: { type: "number", name: "dcTz0" },
        invoiceRemarks: { type: "string", name: "oJv8a" },
        docId: { type: "string", name: "iVSFR" },
        docCreditNoteId: { type: "string", name: "BmlfP" },
        docReceiptId: { type: "string", name: "ZO8Am" },
        timeStampCreatedWhen: { type: "date-time", name: "InLZm" },
        timeStampCreatedBy: { type: "string", name: "yh9KO" },
        timeStampCreatedEmail: { type: "email-address", name: "FPYRN" }
    }
});

await invoicesDbTable.update(invoicesDbID, {
    // Add columns here
});