ContributionsMost RecentMost LikesSolutionsRe: 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 ------------------------------ Re: Formula URL button - save and redirectThat is helpful, thanks! Is there a way to have the action pause in between when the record saves and the next page displays? I have a pipeline that runs when the record is saved, and I want that to be finished before displaying the next page. I tried looking at the examples on Code Pages App, but the examples are either Prompt & Redirect, or Run, Pause & Refresh. I would need something like Save, Pause & Redirect. I don't know javascript really at all to be able to figure out what needs to be changed. ------------------------------ Brittany Scheid Special Projects Manager SimiTree ------------------------------ Re: Formula URL button - save and redirectNever mind! I found another post that explained how to create a formula-rich text field that acts as the "Save & Keep Working". I just updated the URL to include the form ID to get what I needed. Here's the post for anyone else who's interested. https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=d959cde4-8af7-4499-b793-c3f8807c57cd&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer ------------------------------ Brittany Scheid Special Projects Manager SimiTree ------------------------------ Re: Formula URL button - save and redirect@Quick Base Junkie What field type does this code get used in? When I tried both Formula-URL & Formula-Rich Text, I received syntax errors saying javascript was not allowed. (screenshot below). I've included my code below as well. My scenario is that I'm actually not saving a parent record, but wanting to save the record being edited, and bring up that same record but in a different form. Almost like the "save & keep working" but using a different form. Would turning on the "Save parent record automatically when a child record is created" option address this too, negating the need for the javascript? var text URL = "javascript:void(DoSaveAdd())"; var text URLTWO = URLRoot() & "db/" & [_DBID_EVENTS] & "?a=er&dfid=12&rid=" & [Record ID#]; var Text Image = "<a id='saveButton' class='Vibrant Success' onclick='DoSaveAdd()' href='#'>Submit</a>"; "<b href =" & $URL & "&rdr=" & $URLTWO &">" & $Image & "</b>" ------------------------------ Brittany Scheid Special Projects Manager SimiTree ------------------------------ Re: How do I use Today() in a Pipeline Query line?Thanks for the reply. I did find that Advanced Query workaround through another post and have been using that for now. I too was confused because I was sure I had it working in a pipeline previously as well, but over the last couple weeks/month, I haven't been able to get it to work. Please let me know if you find a solution. Thanks! ------------------------------ Brittany Zane ------------------------------