ContributionsMost RecentMost LikesSolutionsRe: Minimizing side menu when opening a pop up You are an absolute rock star. Worked perfectly. And I already had the close window code page worked into a button on the child form so it worked seamlessly. Many thanks Re: Minimizing side menu when opening a pop up Much appreciated Mark. Below is the html portion I'm currently using for that button "<div style='display: flex; background-color: #3e62d6; padding: 5px 15px; font-size: 12px; border-radius: 25px; width: 200px; height: 30px; align-items: center; justify-content: center;'><a style='color:white; text-decoration: none;' class='OpenAsPopup' data-height=500 data-width=750 data-refresh=true href='" & $url & "'>Add Sales Approval</a></div>" Re: Minimizing side menu when opening a pop up New Forms Minimizing side menu when opening a pop up Any options/tricks for minimizing the side menu when opening a pop up from a rich text button? What I notice is if the side menu is expanded in my parent page it will also be expanded in the pop up... ideally I want to always minimize the side menu in a pop up Using GetRecords to query a table in a different application? Is it possible to use GetRecords to query a table in a different application? The formula only seems to accept the table alias for tables within the same application. Thanks for the help. Solved'Catching' non http 2XX API responses in Pipeline Is it possible to add a condition in a pipeline that 'catches' a non-2XX HTTP response from a Fetch JSON or webhooks request. It seems pipelines automatically go into a failed status if anything but a 2XX code is returned. I tried a condition with 'Status' equal to 404 (for example) but the pipeline still failed rather than branching. Thanks Re: New Form - Rule Trigger for Field Value Change OR accessing old value? Curious if a solution for this that doesnt require the use of pipelines and can be done directly in the new form rules was ever identified? Branching a pipeline based on the number of records in a fetched JSON Currently my pipeline: Does a JSON Fetch to retrieve a JSON response Does an Iterate over JSON records After the iterate I'd like to add a condition step that checks whether the # of JSON records is exactly 2 and then branch accordingly My iterate JSON step is Step 'd'. I'm trying to figure out the right syntax to use in my condition step. In the advanced expression of my condition step I've tried {{ d | count}}=2 {{ d | count}}==2 {{ d | length}}=2 {{ d | length}}==2 and all always resolve to 'True' even when the returned json only has 1 record Any help is appreciated. SolvedHow to support complex query with conditional dropdowns I have a generic 'Contacts' table that is a child table to both a 'Company' table and also to a 'Customer' table. In then have an 'Issues' table where I want to use a relationship to 'Contacts' to select the Issue Owner (thus 'Contacts' is the parent table to 'Issues') . 'Issues' is also a child table to 'Customers' (Full Diagram below) When creating a new issue record, I'd like the Owner (Contact) dropdown to contain all of the contacts related to Company A + the contacts related to the Issues related customer. I'm familiar with the conditional dropdown concept but can't wrap my head around how it might support this type of query (e.g. contacts related to Company A AND contacts related to the Issue's related customer) Hoping I'm just overthinking it. Appreciate any help. ------------------------------ Jennason Quick Base Admin ------------------------------ Dashboard KPI Widget Delta ChangeTrying to understand how to correctly use the dashboard KPI Widget Delta change feature. My scenario: I have a chart/gauge report called 'Alerts today' that counts the # of alert records based on an Alert Date field. The report is filtered where the Alert Date is during the current day I then created a Dashboard KPI widget and selected the Alerts Today report. I want to take advantage of the Delta Change feature and selected the same Alert Date field as the 'Field for Comparison' and the comparison period as 'Yesterday'. My hope was this would show some kind of "delta change" of the # of alerts from today compared to the # of alerts from yesterday. But the delta change is always showing the value of alerts from today. For example- if we received 100 alerts yesterday and 20 alerts today I was hoping 'delta change' would show either "↓80 alerts but instead its showing "↑20". I'm assuming I have some conflict between the filter in my report looking for alerts from today and then setting the comparison date to yesterday. In which case I appreciate any help as to how I might meet my requirement which is to show a KPI widget that displays alerts with and alert date from today and shows the delta change compared to the # of alerts with an alert date of yesterday. Thanks. ------------------------------ Jennason Quick Base Admin ------------------------------