TimD
Qrew Trainee
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Sorting a date range as string
Thanks Mark! This is what I have var date start = If(DayOfWeek(ToDate([ppcd_formula]))=6,ToDate([ppcd_formula]), PrevDayOfWeek(ToDate([ppcd_formula]), 6)); var date end = If(DayOfWeek(ToDate([ppcd_formula]))=5, ToDate([ppcd_formula]), NextDayOfWeek(ToDate([ppcd_formula]), 5)); ToText($start) & " - " & ToText($end) ------------------------------ Tim D ------------------------------Sorting a date range as string
Hello, I have a summary report where depending on their completion date will get grouped together by the work week they're supposed to be in but im having issues trying to sort them properly since the days are text. They show up like this. I would very much like these sorted from oldest to newest. Any ideas? The choices for the custom sorting didnt really give me a lot ------------------------------ Tim D ------------------------------Re: Embedded Grid Edit Report help
Mark, are you talking about using the form that uses report dropdown (filters out inactive tasks) as the grid edit form? We're already doing this but it is not limiting the dropdown options on grid edit ------------------------------ Tim D ------------------------------Embedded Grid Edit Report help
Table A · field - Task (text) · field - Job Number (text) · field – Active (checkbox) · and a field called Task_Job Number which is the Key Table B · field called Job Number (a lookup field from another table) Table C · child table of A and B · lookup field from Table B to get the Job Number · lookup field from Table A to get the Job Number · has a conditional dropdown field o show Tasks (from table A) that matches the Job Number from Table B the conditional dropdown works fine, it only shows tasks that are for the specific job number, however, I'd like to further narrow this down to only Active tasks from Table A. On Table C Form, the dropdown is narrowed down by using a report that only shows Active Tasks as a dropdown. How can I mimic that same functionality on the embedded grid edit report on Table B as well? Currently, the grid edit only follows the conditional dropdown. I've tried using formula fields to use as the conditional dropdown but it keeps telling me that I have to select a Job Number first even though it should already be there since it is a lookup field. Any ideas on what I'm doing wrong? (also making sure that the fields were visible in the form just in case that would cause an issue) Hopefully, this all makes sense. I'm still learning how this particular app was made. ------------------------------ Tim D ------------------------------Re: Saving record glitch
in this Example: you are on "Your First Test Table" on Record ID# 76. You click the button with the red circle. You then get redirected to a form where you can enter your information and when you press save, you get redirected back to Record ID# 76 form? is that right? ------------------------------ Tim D ------------------------------Re: Report Mangement - Track Report usage
Something to consider, but i haven't really verified this: I once heard that if the report is in a dashboard/homepage and the user never goes to the full report but only access the report through the dashboard/homepage, then it won't count as 'usage' Do you happen to know whether this is true, Chayce? ------------------------------ Tim D ------------------------------Re: JSON Handler - Max JSON size exceeded
Michael, This might be of use to you when you are trying to get a value from the response: To capture an XML response from an API in Pipelines | Discussions (quickbase.com) maybe {{ b.json["status"] }}? ------------------------------ Tim D ------------------------------Re: Last iteration of the Search step
well, unfortunately, it seems that it is dependent on the amount of records on the Search step. I was able to use the max|attribute='id' no problem when i tested on a very simple app but when i tried it on an app with larger data, it gave me the same error: Query step produced too many items too allow inline indexed access. Please use a LOOP construct. I assume it has something to do with the way results are paginated? Anyway, just in case you had another thought: My use case was to do a Search step and for each of those records, I want it to update two fields. For one of those fields, i only wanted it to update when it was the last iteration of the loop. What I ended up doing is: outside of the for loop, I went with a Make A Request step that queries the table with the same conditions as my Search step and then from a discussion that you were also a part of, i take the highest record id from there (since my table settings is sorted by Record ID - low to high) and then just use look up and update the record. thank you for your help and insights! ------------------------------ Tim D ------------------------------
