About Chacal33

Chacal33 · 08-20-2022

Hey all,I have 4 tables:Quote: QuoteID / Date / AcceptedQuoteDetails: QuoteDetailsID / QuoteID / Job / Qty / PriceInvoice: InvoiceID / QuoteID / JobInvoiceNumber / DateInvoiceDetails: InvoiceDetailsID / InvoiceID / QuoteDetailsID / ProgressI would li...

Chacal33 · 08-15-2022

Hey all,It is a very long shot type of question.I have 3 tables:- Order table: OrderID / DeliveryDate / Received- OrderDetails table: OrderDetailsID / OrderID / Product / Qty- OrderReport table: StartDate / EndDate / List of OrderID (VC)I would like ...

Chacal33 · 08-10-2022

Hey all,I cannot get my head around this problem of mine.I have 4 tables:T_Supplier--- SupplierID / SupplierT_Product --- ProductID / Product / SupplierIDT_Order --- OrderID / OrderNum / OrderDate / SupplierIDT_OrderDetail --- OrderDetailID / OrderID...

Chacal33 · 12-05-2021

Hi all, I have an automation that sends an email and archive the attachment. I set the name of the attachment on a computed key. And when archiving, the app creates a folder and a sub-folder in which the pdf file is saved under a fairly random name… ...

Chacal33 · 10-08-2021

Hi all, Can anyone help me figure out how to have an action button doing: If data exists then LINKTOFILTEREDVIEW else LINKTOFORM? Many thanks Matt

Chacal33 · 08-16-2022

Hi Steve,I know of this. I have already used it multiple times.In my app, i do not have a Ref column, but a Virtual Column with a list of OrderID. How would you make it work?

Chacal33 · 12-05-2021

Actually found out that a date was in the computed key. And you have to refer to a date as text. Thank me!

Chacal33 · 10-12-2021

Hey, The IF formula worked a charm. I did not think it would work with the LINKTO… expression. Many thanks mate

Chacal33 · 10-08-2021

Hey guys. Thanks for your replies. I will try the if with linkto… and let you know if this works. This is indeed an answer to my question

Chacal33 · 09-21-2021

Hi, Finally managed to make it work. For those interested here is my code to generate uniqueID in multiple tabs in one google sheet: var SHEETNAME1 = "1"; var SHEETNAME2 = "2"; var SHEETNAME3 = "3"; var ID_COLUMN = 1; var ID_LENGTH = 8; function gene...

My Stats

abiramradhakris's Bio

Badges Chacal33 Earned

Recent Activity

Add multiple rows into another table with bots

Refer to list of keys

Dependent dropdown on ref

Attachment name creates folder

LINKTOFORM or LINKTOFILTEREDVIEW

Re: Refer to list of keys

Re: Attachment name creates folder

Re: LINKTOFORM or LINKTOFILTEREDVIEW

Re: LINKTOFORM or LINKTOFILTEREDVIEW

Re: Google Sheets UniqueId Apps Script