AngelRodriguez
Qrew Assistant Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Pipelines Variables
I know it's been quite some time since I asked this question but here's the solution. It is possible to use a bucket in Pipelines to create a row for each user in a User List field. The key is to break the User List into individual users and loop over them, creating a record for each item in the bucket.Re: Microsoft Power Automate
I guess it depends on what you're trying to do but I've had success using it for several things in my organization. Here's a couple of them. SMS messaging to patients using Vonage SMS APIs. Extracting images from Outlook messages (that are pasted into the body) and converting them to base64, then converting those to attachments that can be pushed back into a Quickbase table. We're using this for our help desk app since our users like to paste images into the body of the email.Re: Pipeline to remove file attachments
That's odd. I'm just not getting that result. Unless I'm doing something wrong here. When I run this in my Pipeline using the 'Make Request' step (in a for loop for all attachments), it shows the attachment is gone in form and report view: https://<my_realm>.quickbase.com/db/<my_db_id>?act=API_EditRecord&rid={{a.id}}&_fid_113=&delfile_fid_113=1 But when I go to 'App Management > Manage File Attachments' in QB, the attachment space remains the same and shows that all the attachments are still there. Ah, I see what I did. I set to the HTTP method to GET and not POST. I also needed to set the number of versions to retain for each attachment field to 1. My bad. What MarkShnier__You and PrashantMaheshw mentioned is correct.Re: Pipeline to remove file attachments
Since I can't delete the post, please disregard what I said below this. I was using GET and not POST when running my Make Request. Also keep in mind that when using this technique, Quickbase still keeps a backup of these files that utilizes your attachment space. You can find this in App Management > Manage File Attachments.Re: Last Triggered Timestamp
I've noticed the same thing happening to my Pipelines. I've been migrating some Actions and Automations over to Pipelines and it's only happening with newly created Pipelines. Seems like some type of bug. I'm still seeing the 'Last Triggered' timestamp with older Pipelines, but with more recent Pipelines that I created, the 'Last Triggered' timestamp does not show on the Pipelines dashboard. I physically have to go in and check it by clicking on the ellipsis and viewing activity.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 ------------------------------
Groups
Philadelphia Qrew
A place for members of the Philly Qrew to connect and learn from each other.
