NelsonArce
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Formula Help: Adding Non-Consecutive Numbers
I developed an "audit" application that works well for the most part, but there is a specific scenario I could use some help with. Each question is worth "x" points but when the question does not apply the user can enter "N/A" as a result. Quickbase is correctly ignoring these in my total point calculations but is also counting them as "0" and throwing things off when performing my weighted average adjustments in each category (in the screenshot Compliance questions are worth 40% of the total). I've been using summary formulas and it's easy when all questions are N/A (which is possible) to add all those points back in to my adjusted total. However, when there's a gap like what is shown in the screencap I can't find way to "skip" a question that has a legit answer (e.g. Fail) and needs points deducted. I don't know if this is solvable short of writing out every combination possible and adding those points back in, e.g. 1-2-3, 1-2-4, 1-3, etc.). ------------------------------ Nelson Arce ------------------------------15Views0likes1CommentRe: How to "copy" data captured in a single field to more than one multiple choice field in same table (can a pipeline do it?)
Brilliant! I understand exactly how to do that, many thanks for the knock on the head to see more clearly. ------------------------------ Nelson Arce ------------------------------34Views0likes0CommentsHow to "copy" data captured in a single field to more than one multiple choice field in same table (can a pipeline do it?)
Hello! I am working on "performance management" app and have a form that captures "staff member" along with the staff member's "manager" in separate fields on a "phone call" form. Next, we are capturing how many "errors" the staff member made on a phone call, thus I created SIX multiple-choice fields (error 1, error 2, etc.) to capture each error. I am stuck trying to associate "staff member" and "manager" to each error committed. We need to be able to summary report out on all errors, errors by staff member, and errors linked each manager. I'm trying to link/copy the value of the staff member and manager captured 1x per form to each error made captured in error 1, error 2, etc. A colleague suggested looking at the "bucket" channel in pipelines, but I am new to pipelines and cannot figure out how to make it do what I need. Bulk Record Set also doesn't seem to do the trick. Am I on the right track looking at pipelines or is there another solution I am not seeing Thanks for any guidance! ------------------------------ Nelson Arce ------------------------------17Views0likes2CommentsPipeline Help: Inserting a Timestamp Into the File Name (SharePoint Channel)
Hello! I am generating a CSV file 6x day (i.e. every 4 hours) and uploading it to a SharePoint folder. Everything works great overalI; I am currently attaching the record_id to the beginning of each file (to solve for the latest file overwriting the last one), however I am being asked if we can begin each file with a date/time stamp instead if possible. I successfully used {{time.now|date_ymd}} to create a date but nothing is working for time; not {{time.now}} nor {{time.today}}. Error messages are embedded for context. Has anyone succeeded doing this? ------------------------------ Nelson Arce ------------------------------11Views0likes1Comment