Find Multiple Dates older than 2 Weeks and not blank.
For future me. Leaving this here because I was unable to find any reference using the Khoros Search or Google Search. If((ToText([Email Date]) <> "" and [Email Date] <= (Today()- Days(14))) or (ToText([Instructions Send Date]) <> "" and [Instructions Send Date] <= (Today()- Days(14)) or (ToText([Verification Email Date]) <> "" and [Verification Email Date] <= (Today()- Days(14)))),true,false) This formula defines a checkbox formula field. The Checkbox formula field is used in a Pipeline to filter records meeting the criteria. The entire purpose of the Pipeline is to clear the dates from these records once they are older than 14 days in the past. I add this formula field to a report with the fields being evaluated and then look at the report. Only the ones that meet my criteria should be checked. I can use the report to verify it is working or make changes as needed. Once satisfied with the results, I add the formula checkbox to the Pipeline as a single filter. In case you're wondering, I also put in a Give Feedback asking to grant rights to use reports as a filter in a Pipeline.
Identifying identical values between two table
Hi Everyone, It's been a while since using QB and my brain appears to have lost QB memory! I have two tables: Preferred Providers eligible for auto-assignment All Providers that have been auto-assigned (regardless of preferred designation) I am looking for a formula that will look for a TIN match between both tables and pull into table 2 under new field "Preferred Provider" Ultimately, I need to identify the auto assigned preferred providers without scrubbing a list of thousands of TINs. Any help is greatly appreciated!
Need help resizing pop-up window
I am trying to my Change Status field to a Formula Rich Text field from Formula URL field because the popup that opens when clicked is never the correct size for me. This is what I was able to cobble together with my limited qb knowledge but it gives me and error saying it doesn’t allow javascript. I can’t suss out why. Any ideas? var text RID = If([LEAVE REQUEST - LEAVE STATUS]="FINAL APPROVAL", "", "%%rid%%"); // only displays button if decision is ‘pending’ or ‘rejected’ var text URL = URLRoot() & "db/" & [_DBID_DECISION_STATUS_CHANGES] & "?a=API_GenAddRecordForm&_fid_26=" & URLEncode ([Record ID#])& "&dfid=11" & "z=" & Rurl(); // when clicked opens popup window with DECISION STATUS CHANGES form #11 – Add Form Temp "<a class='Vibrant Success' onclick=\"window.open('" & $URL & "','Edit','width=800,height=700')\">MAKE DECISION</a>" // link code for popup with dimensions for width and height
Formula Help
Hello, I need help combining text fields into a formula(s). Here are my formulas: [Finance Disposition]=""&[(Text) PipeLine Value Requested]="<$500,000"),"YELLOW") I'm getting the operator "=" can't be applied on types bool, texterror message [Current Status]="Submitted",[Finance Disposition]="",[(Text) PipeLine Value Requested]="<$500,000","Red") I'm gettingexpecting text, but found boolerror message
Users are overlapping times on same date
Okay I have a user field a date field, time mobilized field, and a end time field. I need a message to pop up letting the user know if they put overlapping times in, that they need to adjust their times or have another user take care of the issue. How can I do this? Thank you all who take the time to help!
Expanded URL to Formula Query
Hello, I am hoping someone much smarter than I can help solve this puzzle. I have a report on an activities table. I want to search the same parameters that the report has within a size(GetRecords()) formula query in order to showcase how many records the user can expect to generate. The first thing I did was to go to the report, unswitch the 'new style', choose 'more', and then select "show expanded url for this report". Which gives me this (made minor change to allow the formula query to save): Size(GetRecords((("{'33'.IR.'this+wk'}OR{'33'.BF.'today'})AND{'76'.XEX.'No+Street+Address'}AND{'61'.XEX.'No+Employer+Name'}AND{'68'.XEX.'0'}AND{'19'.EX.''}AND{'82'.EX.'Send+Letter'}AND{'60'.XEX.'ABC'}AND{'69'.XEX.'Paid'}AND{'69'.XEX.'Promise+to+Pay'}AND{'69'.XEX.'Escalated'}AND{'17'.EX.'Delinquent+in+30+days'}")), [_DBID_ACTIVITIES])) The above expanded url equals the below (report parameters) How can I modify this expanded url and turn it into a workable formula query? Any and all tips/ tricks are welcomed. Thank you!
