DrewVoge
Qrew Cadet
Joined 7 years ago
User Profile
User Widgets
Contributions
Changing ownership of pipelines
We have created a service account to manage pipelines (as suggested by QB), which seems to be good way to handle multiple developers working on our account. However, we have dozens of pipelines that I need to change ownership of in order to take advantage. I'm really hoping someone has a better solution than what QB is suggesting because this is wild for changing ownership of an existing pipeline. https://helpv2.quickbase.com/hc/en-us/articles/10943861915284-Transferring-ownership-of-a-pipeline64Views0likes3CommentsPossible to duplicat a near-identical pipeline
I have a number of pipelines I use to sync two quickbase tables. Basically, quickbase sync but it runs in real time as opposed to hourly among other benefits. No issues building the pipeline, but curious if I can save myself some time. I have multiple copies of the same table in multiple apps. They all have a single source table in a single app that acts as the source. These pipelines sync the records from the source table to a number of different tables in different apps with the only difference being the filters that determine which records are synced to which apps. (umbrella company has a number of independent business units that operate differently / separately sharing a single shared financial / accounting system) Each of these synced tables has additional fields that are unique to those tables, but those fields aren't part of the sync process (most are formula or relationship fields) The field NAMES are always the same in the source table and the synced tables, but the FIDs are not. Is there any way with some of the new tools they've created that I can more simply duplicate these pipelines given my setup? Frustrating to build essentially the same pipeline numerous times with only one filter difference, especially if i'm syncing 30-40 fields on each one.19Views0likes0CommentsRe: New Form Rules
Bumping to see if anyone has an answer yet. I very much want to use these new forms, but the form rules have taken a step back, this being a perfect example. I understand this can be accomplished with pipelines . . . ------------------------------ Drew Voge ------------------------------37Views0likes2CommentsRe: Pipelines - Delete unmatched records
I had a similar thought using a checkbox field called 'delete'. Basically the update process first sets all checkboxes to true, then the upsert process unchecks the boxes. After the upsert is committed, I delete all records where the checkbox is still checked. My concern there is an interruption in the process that results in all records being deleted. I had hoped to do it within the pipeline not using new fields as I assume there is a method that my peabrain can't figure out. ------------------------------ Drew Voge ------------------------------37Views0likes2CommentsPipelines - Delete unmatched records
I've been using pipelines to replace some synced tables that I need to be updated "live". Basically two nearly identical tables with the same primary key. I've created a pipeline for when a record is created in table A to create a record in table B. I've created a pipeline for when a record is modified in table A to update the record in table B. I've created a pipeline for when a record is deleted in table A to delete the record in table B. Now i'm working on a daily refresh pipeline to ensure the tables are synced in case of errors. The bulk upsert process is what I have been using for that, and it works great. My problem is I don't understand how to include the logic to delete records out of table B that no longer exist in table A as part of my daily refresh. Is there a way to do this within my daily refresh pipeline or another pipeline? ------------------------------ Drew Voge ------------------------------62Views0likes4CommentsRe: Matching part of a user-list to another user list
using contains instead of includes fixed it for me. Thanks so much for your help. here is the completed formula for anyone else that may need it: var text activeusers = ToText(UserListToEmails([User - Current - User and Covered])); Contains([Users - Active For - Final],ToUser((Part($activeusers,1,";")))) or Contains([Users - Active For - Final],ToUser((Part($activeusers,2,";")))) or Contains([Users - Active For - Final],ToUser((Part($activeusers,3,";")))) or Contains([Users - Active For - Final],ToUser((Part($activeusers,4,";")))) or Contains([Users - Active For - Final],ToUser((Part($activeusers,5,";")))) or this just continues until you hit the max users in a userlist, which is 20. ------------------------------ Drew Voge ------------------------------5Views0likes0CommentsRe: Matching part of a user-list to another user list
I fixed (I believe) one part where you need to wrap the individual user values in a touserlist() to compare to the other user list. Being said, it works sometimes, but not always. Here's what i figured out so far: If userlist1 has 4 users in it, and the formula tests 4 parts of list1, it works correctly. If userlist has less than 4 users in it, and the formula tests 4 parts of list 1, it returns positive no matter what. Basically, it only seems to work if the number of "tests / comparisons" you make is equal to the number of users in the userlist1. Make sense? This is what the formula currently looks like: var text activeusers = ToText(UserListToEmails([User - Current - User and Covered])); Includes([Users - Active For - Final],ToUserList(ToUser((Part($activeusers,1,";"))))) or Includes([Users - Active For - Final],ToUserList(ToUser((Part($activeusers,2,";"))))) or Includes([Users - Active For - Final],ToUserList(ToUser((Part($activeusers,3,";"))))) or Includes([Users - Active For - Final],ToUserList(ToUser((Part($activeusers,4,";"))))) ------------------------------ Drew Voge ------------------------------23Views0likes2CommentsMatching part of a user-list to another user list
I have two list-user fields - List1 and List2 I want to compare these two fields in a formula-checkbox field and have the result be true if ONE OR MORE user(s) from list1 appears in list2. Example 1: List1 - user1,user2 List2 - user2,user3,user4 Result would be true because user2 exists in both list1 and list2 Example 2: List1 - user1,user2 List2 - user1,user2,user3,user4 Result would be true because one or more (both) user1 and user2 exist in both lists Example 3: List1 - user1,user2 List2 - user3,user4,user5 Result would be false Any help? ------------------------------ Drew Voge ------------------------------90Views0likes5Comments