AngelRodriguez
Qrew Assistant Captain
Joined 4 years ago
User Profile
User Widgets
Contributions
New Forms Return and Cancel Buttons Glitch
I've been working on a multi-step form and noticed that the return and cancel buttons on the new forms always return the user back to the home page no matter where they are on the form. Also, is there a way to hide either the return or cancel buttons? Has anyone else experienced the first issue I mentioned where both buttons do the same thing and take you back to the user home page, completely away from the form and table you were on?Re: Rurl() doesnt return to correct Form Page
I'm not sure if this works with tabs on the new forms, but I found that this formula does work with steps. I have a 24 page form and needed custom API buttons to save initials and dates at about 10 different points on different pages. I found that this code worked to save and return me to the specific page that I'm on. URLRoot() & "db/" & "<your table ID here>" & "?a=API_EditRecord" & "&rid=" & URLEncode([Record ID#]) & "&apptoken=<your app token here>" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] & "page%3D&page=1") Specifically, the portion of code that redirects to a specific page on the new forms is `page%3D&page=1`. It's hardcoded and I haven't attempted to pull the page number dynamically, but this certainly works as I'm using it in a bunch of places on my form. The `%3D` in the URL is a percent-encoded version of the equals sign (=), so it looks a bit redundant to state "page=&page=1". This may be some type of variable assignment in the URL. Either way it works.Re: Question About Creating One Record (Combined) inside a For Each Loop
I came up with a workaround for this. It doesn't iterate over the matching activities (with the same part number). Instead, I just ignore these matches (Shipping from multiple locations), since I have everything I need in the first instance (original) of the part. Since the original part is the only line item (matching part - matches the other two activities by part number but shipping from another location) that contains a quantity requested, I would include a condition in the 'Search records' step of the Pipeline to exclude anything that has a blank or null quantity requested. Since my original part uses a formula query field that already combines the total quantity shipped of all like parts, I can use that to create my receiving activity. Keep in mind that the 'shipping from' location in my receiving task does not matter on the receiving end as our ordering locations only care that they receive X quantity of parts. They're not concerned about the location from where the part was shipped. This doesn't solve the technical question of iterating over records with the same part number and somehow combining them, but for this specific dilemma, I was able to create a workaround to the issue. ------------------------------ AR ------------------------------Question About Creating One Record (Combined) inside a For Each Loop
I'm working with two tables, a Parts Task table (parent), and a Task Activities table (child). Each activity represents a part number shipped from a specific location, e.g. MISC-1-A10, MISC-1-A20, etc. Here are the steps, via a Pipeline, I'm trying to achieve but I'm stuck on step D: When the shipping task is completed the Pipeline is triggered. Create a new receiving task from the completed shipping task in step A. Search for all related activities for the task in step A. For each activity I would normally create a copy from step C and append that to the task created in step B, but in this case, I want to create one combined activity for all activities with the same part number and combine their 'Quantity Shipped'. In the attached image, you'll see we have three line items for '2525…., Fake Part'. With a combined 'Quantity Shipped' of 10. I'd like to merge all three line items into one receiving activity of 10 shipped. Is there a way to do this with a Pipeline or do I need to separate the activity creation into a webhook or something similar? ------------------------------ AR ------------------------------Re: Pop up
Yes, you can add the the `data-height` and `data-width` attributes on the anchor, and set the height and width that way. "<a class=\"OpenAsPopup\" data-height=900 data-width=1200 href=\"https://xxxxxx.quickbase.com/db/xxxxxxxx?a=dbpage&pageID=27\" title=\"Verify Service Center\">" & "<img src=\"https://res.cloudinary.com/ethos-outcomes/image/upload/c_scale,w_24/xxxxxxxxx/xxx/blue-marker.png\">" & "</a>" ------------------------------ AR ------------------------------Re: Address field with Pipelines QB channel?
This is not mentioned in Pipelines docs, but you'd want to use bracket notation with fields that have a space in them, particularly, an address field. For example: If you're using a dot (.) to reference a field value in an expression like {{a.Patient Address_city}} You should update that by removing the dot and referencing the field in brackets and single quotes, like so: {{a['Patient Address_city']}} ------------------------------ AR ------------------------------Re: Pipelines/Jinja: How to check if datetime field is empty or not
Hi Matt, You can try replacing the is not defined with is None Here, you're checking to see if date is null, or in Python the comparison would be None. {% if a.$prev.client_live_date is None %} TBD {% else %} {{a.$prev.client_live_date.strftime('%m/%d/%Y')}} {% endif%} Let me know if that works for you. ------------------------------ AR ------------------------------
