ContributionsMost RecentMost LikesSolutionsRe: Jinja time check in Pipelines thanks.. working now ------------------------------ Pete James ------------------------------ Jinja time check in Pipelines I wish to stop my pipelines running outside of working hours I have an IF section with advanced expression. What is the correct syntax to check whether the current hour is greater than or equal to a given hour? I have tried {{time.now.hour <= 15'}} {{time.now.hour <= '5}} but these don't seem to work thank you ------------------------------ Pete James ------------------------------ Re: Images on forms thanks.. yours worked for me.. as far as I can see the link in my case was missing the https:// and that's what caused the issue. thanks again ------------------------------ Pete James ------------------------------ Images on forms Hi, I am trying to include an image (logo) on a form. I have read all the posts and followed the instructions but no matter what I try the image shows like the one at the bottom of this post. I have tried: - Different browsers with images enabled - Rich text field <img src="https://ibb.co/4pdhcTt"> - Rich text field <img src=\"https://ibb.co/4pdhcTt\"> - Form text field with html enabled and the above image statements all of the above with a url from an image loaded into a quickbase field Does anyone have any ideas on how to solve this. ------------------------------ Pete James ------------------------------ Re: Is there a way to reference the old field value in a pipeline advanced query? This was the response from QB Support on this topic when I had the same question The March 2021 release is not applicable to advanced queries and is only applicable to the actual field. Advanced queries work in a {Field.Operator.Value} format. We do apologize for the inconvenience. There are always ways to improve Quick Base and we welcome all suggestions. I would suggest posting this to our Feedback forums and sharing it with the community and our developers. You can access the Feedback forums by selecting the blue Feedback tab from the left-hand side of the My Apps page. ------------------------------ Pete James ------------------------------ Re: Using Quickbase solely as a backend (Custom Frontend)We use half and half.. we have developed several external apps which use the API because we wanted custom front ends. I don't see why you couldn't go 100% external. ------------------------------ Pete James ------------------------------ Re: URL Button to edit record and return to original launch screenI think what you need is detailed here: https://community.quickbase.com/blogs/evan-martinez1/2019/12/06/using-ampzamprurl-and-rdr-in-formula-url-fields Specifically URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_7=Approved" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()) Make sure you tick Open Target in Same Page ------------------------------ Pete James ------------------------------ Re: How to write formula for [Due Date] minus 2 weekdaystry this ToDate(WeekdayAdd(ToWorkDate([Due Date]),-1)) ------------------------------ Pete James ------------------------------ Re: Calculate next 2nd Tuesday of a monthHow about this.. where test date is the date you are using to identify the month var number firstday = DayOfWeek(FirstDayOfMonth([test date])); var number delta = 9 - $firstday; If ($delta < 2, FirstDayOfMonth([test date]) + Days($delta),FirstDayOfMonth([test date]) + Days($delta + 7) ) ------------------------------ Pete James ------------------------------ Save child record and redirect to a report in a new windowI think I've found a solution - below var text URL = "https://xxxx.quickbase.com/db/yyyyyyy?a=q&qid=1&query={'7'.'EX'.'" & [Order Number] & "'} AND {'16'.'EX'.'" & [SKU] & "'}"; "<a class='OpenAsPopup' href='" & $URL & "' data-height=1200 data-width=1200 data-refresh=true>Add this SKU</a>" scenario is as follows. User is editing a child record from within the parent record. They need to click on a button which would save the child record and close, returning to the parent record and at the same time open a report in a new window. I found things like this but they are no longer supported. var text URL = "https://xxxxx.quickbase.com/db/yyyyyyy?a=q&qid=1&query={'7'.'EX'.'5484'} AND {'16'.'EX'.'74369'}"; "<div class='Vibrant Success' onclick='RedirectURL.value=" & $URL & ";editform.rl.value=''DoSave();'>Save</div>" I assume it will need a code page but not sure how to proceed. thanks. Peter ------------------------------ Pete James ------------------------------