ContributionsMost RecentMost LikesSolutionsFormula to Calculate 3rd working day of a monthHello all, I am looking for a formula which will help me determine 3rd working day of a month taking into account week-ends if any and list of public holidays. I have list of public holiday dates which can be checked. As an example: For the month of May'22, the 3rd working day is 4th May. If I have to add a holiday on 3rd May, the 3rd working day should be 5th instead of 4th. Looking forward to hearing from you. RegardsPost MC ------------------------------ MC Admin ------------------------------ Re: Pipeline Jinja template expressionThank you Sharon for this master piece code on jinga. This worked perfectly. Hats off to you. I also noticed that the search results from step-D are not sequenced and they come in random order. I would like to fetch the search results orded by a start date in ascending order so I can match with a date from step-A. Regards Babi ------------------------------ MC Admin ------------------------------ Pipeline Jinja template expressionHello, I am looking for a jinga expression/syntax which could help me validate the sum(Field-1) > NN value in a step using if condition. Below is the pipeline steps: Table-B structure Record ID#, country, Qty issued 1, UK, 20.5, 2, UK, 30 3, UK, 30.8 Pipeline Step-A When the record is created in table-A Step-B Search records in Table-B where b.country = "UK" If sum(qty) >= 100 Step-C - Create record in Table-C Else Step-D - Create record in Table-D I want the jinga expression to be added in step-B post search is returned to check the sum(qty) and compare if it exceed or equals 100 ------------------------------ MC ------------------------------Re: Can I hide the green Save Record button?how do I apply this on my app. I want to hide the standard quickbase save and save & add new button on the top right corner and instead use the custom save button created using formula url. to ensure users use this instead of standard button. The button should be disabled on form add/edit. Can I request for step by step instructions for this. Any help will be appreciated.