ContributionsMost RecentMost LikesSolutionsRe: Welcome to the Women's Qrew! Tell us about yourself. Hi all! What is your name? Brittany Scheid What company are you with? SimiTree Acquisition, LLC What is your role there? Director of IT Special Projects - I'm basically the Quickbase guru, but also provide elevated support and data integrity for a lot of other systems as well. It often turns into "no one knows what this is/how to do this...Brittany can you figure it out?" π The goal of my role is to focus more and more on process improvement and new development. What brought you to the Qrew board, specifically the Women's Qrew? Good ol' Ben Simon :) But also, as one of only 2 women on our IT team, it's encouraging to be around other women in the tech space. What is one thing you are most looking forward to this summer? My summer schedule is a bit up in the air, but I'm looking forward to just getting outside and maybe going fishing with my hubby and father-in-law. Fun fact: My husband and I love to travel and since we got married in August 2021, we have traveled to 11 countries, including Iceland where we saw an active volcano, Australia and New Zealand which were other-worldly, and a whirlwind Eurotrip of 7 countries, 12 cities in 19 days. (For those counting, Canada is the 11th, but that one is a lot less exciting π). Re: The Discord Qrew - What's It All About? I'm in! Thanks! Re: The Discord Qrew - What's It All About? How do I join this? I tried clicking the link, had to create an account, but then it just says I'm not a part of any text channels/servers yet. Even after creating the account and going back to the link, it still shows the same thing. I've never used Discord before. Help! :) Re: Formula to get the roles of everyone in people table For jinja & JSON novices like me, here's what I finally figured out in order to deal with the error message that is thrown when a user has no role in the app and you're trying to populate a field with the role name property. I added a condition that checks to see if a role is returned, and then if so, populated with the role name property, and if not, populated with None. It took me forever to figure out the right syntax to get the expression to actually evaluate properly (I had to use the tojson filter to actually get a value to compare against), so hopefully this helps someone else as well. Expression evaluates to TRUE: {{quickbase_make_request_1.json.qdbapi.user.roles|tojson!='null'}} If TRUE, then populates the Role field with {{quickbase_make_request_1.json.qdbapi.user.roles.role['name']}} If FALSE then populates the Role field with 'None' Re: Jinja for User List field Hi there, I'm looking for help on this too. Did you ever find an answer? ------------------------------ Brittany Scheid ------------------------------ Re: Looping through field values in PipelineHi Kristoffer, Thanks for your response. See my answers to your questions below: that you grabbed the correct list-user field? Yes there is more than 1 user listed in that field for the record you found. Yes, I've tried multiple various selections and triggered the pipeline several times. do you have the for each loop after this step? Yes. See the attached screenshots. ------------------------------ Brittany Scheid ------------------------------ Re: Looping through field values in PipelineHi Kristoffer, I'm brand new to regex but I'm trying to loop through the users in a List-User field to then create a child record for each. I used the expression and process you indicated above, but it seems to only be returning the first user, not any of the others. I wasn't sure what all the other fields should be set to in the Query step, so I just left them as the defaults. Any help would be greatly appreciated! Thanks! ------------------------------ Brittany Scheid ------------------------------ Re: Formula URL button - save and redirectThat worked like a charm! Thank you so much Sharon! I will definitely look into taking the Button Masterclass. Thanks again! ------------------------------ Brittany Scheid Special Projects Manager SimiTree ------------------------------ Re: Formula URL button - save and redirectSo that got me to the right form, but because the starting page is adding a new record, it pulled up the correct form, but for adding a new record. Is there any way to get it to save that new record, go to the pause code page, then redirect to form ID 12 for that record that was just ssaved? ------------------------------ Brittany Scheid Special Projects Manager SimiTree ------------------------------ Re: Formula URL button - save and redirectThank Sharon. I tried this, but it's still just sending me back to the same page after it goes to the code page. I tried sending it to the form that I want and also just to the app home page and neither worked. Both times it just went back to the same edit form screen. Any thoughts? Below is the code from the formula-URL field. I used the code directly from the code page Body on this page without any changes. var text rid = If([Record ID#]>0, ToText([Record ID#]), // Record ID already exists "%%rid%%" // New record, no Record ID exists yet ) ; // API URL to Add/Edit/etc. var text urlToExecute = URLRoot() & "db/" & Dbid() & "?a=er&dfid=12&rid=" & $rid; //& Dbid() & "?a=er&dfid=12&rid=" & $rid; URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=4" // Open code page 4 & "&url=" & urlencode($urlToExecute) // Pass in the URL to executeβ ------------------------------ Brittany Scheid Special Projects Manager SimiTree ------------------------------
GroupsHealthcare Qrew Quickbase users in Healthcare industry can connect here.1 PostPipelines Qrew A Qrew dedicated to sharing all things Pipelines.12 Posts