Qrew Groups
Connect with others from your area, or who share the same role, professional interest. Find your Qrew here!
Links Banner
Main Content
Recent Discussions
Pipeline Jinja For Duration in Seconds
I would like to have a pipeline condition where nothing happens if the current time is less than or equal to 30 seconds from the value in a given field, which is a date/time field. I have tried multiple variations of jinja code and mostly get the error message: Validation error: Incorrect template "whatever my jinja is". ValueError: invalid literal for int() with base 10: 'my_date_time_field_name' I have tried subtracting and converting the time.now and my field to an integer before comparing to 30 for seconds, I tried using time.delta(seconds=30) and adding it to the date field then comparing it to the current time, and some other things. I get the above error each time. I would really like to do this with Jinja, if at all possible. If anyone can help, that would be greatly appreciated. I know, worse comes to worst, I can add a helper field and just work off of that, but I am doing this for learning purposes. Thank you in advance to anyone who can help.Solved74Views1like10Comments
Bulk upsert field limit in pipeline
Hi, I have a pipeline that I'm using the bulk upsert steps for. Essentially, I'm just copying data from one table to another table and I need to do this bi-weekly. It's my first time using this bulk upsert and now I see there is a 250 field limit. Is there any way around this limit? I checked online and the solution seems to be to using a helper table, I'm not sure how to do this. I only have about 400 fields so I don't want to do that if unnecessary. I also saw something about a loop but I don't know how to do this either. What's the best way to go about this? I have the following steps in my pipeline: Prepare bulk record upsert Search Records In Loop: Add a bulk upsert row - End loop Commit upsertSolved60Views0likes6CommentsHide Save Button on New Forms
Do you want to remove the native Save/Cancel buttons on new forms or new mobile forms? Add &ifv=1&hs=1 to the form URL. They must be used together for it to work and this work in Edit mode. Note: It must be ifv=1 — other values like ifv=10 won’t work with hs=1.Solved466Views1like2Comments
'Equal to' 'Not Equal to" not opposites
I am trying to filter a report and am struggling to get the inverse of the if/then to show properly. I have tested the 'equal to' formula and it is working properly. i.e. I set a filter to be equal to that word so it only pulls records with that word in the field I am referencing. However, if I want the inverse of that report. i.e. I want all the records that do not contain that word to pull on the report however the inverse which I believe should just be switching the 'equal to' to 'not equal to' is not filtering the report at all. even though I have told the report to show me words not equal to the value I've entered are still pulling to the report. I can make a work around with multiple 'equal to' lines. I just believe that selecting the inverse of equal to should pull the records properly. TIA, KbarrySolved37Views0likes4CommentsNew Style Forms in Mobile - native Save button keeps user on Add Record form
Has anyone else run into this issue? We created a new style form for desktop and applied it to mobile as well. On desktop, when a user saves a new record by selecting the "Save" option (not Save and new or any of the other available options), they will re-direct as normal. But on mobile, when the user clicks the native save button that follows them down the form, the record saves, a "record saved" message briefly shows at the top of the screen, and then the user remains on the Add Record page with all of the information they just recorded. If you do not notice the message that flashes on and disappears from the screen, it appears as though no action occurred, which naturally makes a User want to click the save button again. This is causing many duplicate records to be created and causing confusion for users as they are unsure with what to do next. We created a work-around by adding a Rich Text field that will complete the save action and redirect the user as intended, but we are unable to completely remove the native save button which lingers. Does anyone know of a fix in the works for this, or even a way to completely hide the native save button from the form?Solved72Views1like2CommentsHow to create a pipeline to count records in a table
I want a pipeline to do the following: Go to a table in an application A Search for records meeting a certain criteria in that table (specifically, the number of records that were completed in the previous month) Count the number of records found Go to application B Create a record in a table in application B Put the count of the records found in application A in a field on the form (fields: 1 application A name, 2 is count of records found, 3 date the pipeline ran) I want the pipeline to run this monthly on a scheduled date. Can someone kindly tell me the steps I would need to include in the pipeline to make this work? High-level is all I'm looking for. Thank you!Solved59Views1like5Comments
Pipeline after import (heavy traffic/transient error)
I am trying to improve pipeline performance and need guidance on the best approach please. When approx 1000 records are created from csv import using ImportExport action in TABLE A, the pipeline should look for TABLE B ID based on a text field in TABLE A and relate. Attached sample pipeline. When records are imported, the pipeline runs, but noticed the traffic warning. Bulk upsert may not work as each pipeline trigger is on single record update.Solved33Views0likes4CommentsDropdown Choice Update force reselection
Hi all, I have a drop down field with choices for a 'job status'. I've recently refined the list of choices, and I want to know if there's a way to force a user to have to select one of these new choices next time they update the job record. Currently, they can leave the existing status in place and save the record anyway, with the choice highlighting in red in the report. Is there a way to do this? Thanks in advance.Solved45Views1like2CommentsRedirect after API_EditRecord
Greetings, everyone! I'm at my wits end trying to get a redirect to properly fire in a Formula URL button. I'm using the URL as a "Submit" button that changes the phase of the record, then I want the app to redirect to a report. All I can get is a redirect to the app homepage which is not intuitive and undersirable. Here is the URL Formula: var text submitURL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_34=Items&apptoken=<token hidden>"; var text redirectURL = URLRoot() & "db/" & Dbid() & "/a=q&qid=7"; $submitURL & "&rdr=" & URLEncode($redirectURL) Can someone help me figure out what's wrong with this implentation? Thank you!Solved54Views0likes4Comments
