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!Formula Query (Size) - Question
I have created the following Number Formula query in Table A: My goal is to calculate the total records in 5 non-related Tables. The [Table Alais] field represents the Table Alais for the 5 different tables -- and the [AlaisTableFieldID] is my query field. This formula is not working.....any advice is appreciated. Size(GetRecords("{"&[AlaisTableFieldID]&".EX.'"&[Record ID#]&"'}","&[Table Alais]&"))Formula Query with options
Hi, Is it possible to sort the results from a formula query. I have a formula query to get list of dates from a table. I would like to get the latest of the returned dates. Is it possible to use options=sortorder-D in the formula query? var text Query = "{65.EX.'" & [PBG Number] & "'}"; var number NUM = Size(GetRecords($Query, [_DBID_ACTION_ITEMS])); If([Active_Ind] = true and $NUM > 0, ToText(GetFieldValues(GetRecords($QUERY,[_DBID_ACTION_ITEMS]),2)) )
Sum Overlapping Time/Remove Timeframe Gaps
Hi all, is there a way to do this formula queries? I have a table of people who have child residence & employment records, with start & end dates for each, as well as a numeric field that summarizes each timeframe in months. I need to query for all child residence & employment records related to each person, find any potential overlapping timeframes between the 2 tables based on start & end dates, and sum the total # of months from the Duration (months) field from applicable records. Essentially I need a final number in months of time each person provided to us across 2 tables, so any overlapping time would basically get deduped out. I also need it to be smart enough to recognize some of these timeframes are not contiguous and contain gaps, so we might not have any date for particular person from 2010-2015, but we do from 2005-10 and 15-18, so any gaps would need to be excluded from the final count.
