ContributionsMost RecentMost LikesSolutionsWeek on Week Sales Comparison using Formula QueryHi, We have a sales summary table that has a sales total per week. [Week Ending], FID 6 and [Sales Total], FID7. We would like to do a week on week sales comparison using a Formula Query (if that is possible) We have tried various formula queries with this one being the "best" so far. var text LASTWEEK = "{6.BF.'"& [Week Ending] &"'}"; var text THISWEEK = "{6.AF.'"& [Week Ending] &"'}"; GetRecords($THISWEEK,7)-GetRecords($LASTWEEK,7) However we are getting the following error; "The types of the arguments or the number of arguments supplied do not meet the requirements of the function GetRecords. The function GetRecords can be used with the following arguments: GetRecords (Text q). GetRecords (Text q, Text t)." Any suggestions would be greatly appreciated. Tim ------------------------------ Tim Egerton ------------------------------ Button to Check, Pause, Uncheck, RefreshHi, I am trying to create a formula URl button that will check [Check Box A], pause by calling a Code Page, uncheck [Check Box A] then refresh to call a Pipeline, the pause being to give the Pipeline time to trigger. I was using one of Kirk Trachy's Magic Buttons but I need to change it at some stage because it contains java code. So far I've got this but not sure what the Code Page "URl is to execute" is. ---------------------------------------------------------------------------------------------------------------------------------- //Check FID 367 then Uncheck FID 367 var text url = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=c7y3n83dz8fuc2n8jum5dzq4iky&rid=" & [Record ID#] & "&_fid_367=1&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=c7y3n83dz8fuc2n8jum5dzq4iky&rid=" & [Record ID#] & "&_fid_367=0")); //Call Code Page var text callCodePage = URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=10" // Open CodePage 9 & "&url=" & URLEncode($urlToExecute) // Pass in the URL to execute // Add some button styling var text style = "style='background-image: linear-gradient(to bottom, #00b300 0%, #00b300 100%); background-color:#00b300;color: white;' "; Any assistance would be appreciated. ------------------------------ Tim Egerton ------------------------------ Issue with Is NullHi, Can anyone assist with the IsNull part of this formula which is returning a syntax error of "Expecting )" at the first comma. var TimeOfDay TOD = [Interaction Time]; If( $TOD > ToTimeOfDay("12:01am") and $TOD <= ToTimeOfDay("12:00pm"), "Morning", $TOD > ToTimeOfDay("12:00 pm") and $TOD <= ToTimeOfDay("5:00 pm"), "Afternoon", $TOD > ToTimeOfDay("5:00 pm") and $TOD <= ToTimeOfDay("12:00 am"), "Evening", IsNull($TOD ,"", "Other") Thanks, ------------------------------ Tim Egerton ------------------------------ Re: Use IF Statement in RTFfield to dispaly imagesThanks Mark ------------------------------ Tim Egerton ------------------------------ Use IF Statement in RTFfield to dispaly imagesHi, Is it possible to use a IF statement in a Formula RTF as per below, as I am getting a syntax error. IF( [Funds Remaining Total Contract]0>=,"<img src=\"https://images.quickbase.com/si/24/228-rect_green.png\">", [Funds Remaining Total Contract]<0,"<img src=\"https://images.quickbase.com/si/24/230-rect_blue.png\">") Thanks ------------------------------ Tim Egerton ------------------------------ Edit EOTI app record Hi, We have a EOTI app that users outside QB use to create a two step international travel request. They are first required to complete the personal information fields on the form, including First Name, Last Name and Passport Number. This creates the record. This can be done at anytime, even up to 6 months before they want to travel. Then 24 hours before travel they need access the record and enter health and travel details. For step two we have looked at sending them a link to access the record via SMS and/or email. However there are some issues with that. Is it possible for them to enter their First Name, Last Name and Passport Number on the EOTI (maybe using a different form?) to retrieve their record for entering step 2 data? Thanks. ------------------------------ Tim Egerton ------------------------------