Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
How can I get record ID's for 'data' returned? In the XML version I would specify rid=true or similar. What do we do now to return field id=3? Thanks,~Rob------------------------------"The" Rob White IV------------------------------
Anyone run into this issue and have a solution? The class SaveBeforeNavigating will only Auto Save if it detects a change on the record. However, it does not see a file being attached as a change. Thus, if uploading a file is the only change made, it will not save before proceeding. Indeed, even formula checkboxes looking for a file only recognize it once it is saved. So, any thoughts on how we can get a record to auto save before navigating, if a file upload is the only change? In other circumstances if I am launching to a form, I can use some sort of sneaky field update in the background. However, if someone opens a record, and simply adds a file without making any other changes, I am not quite sure how I can force a change.------------------------------Mike Tamoush------------------------------
how do you filter out records in a report that you mark complete?------------------------------Amy Migliore------------------------------
I am wondering if anyone else is encountering troubles creating pipelines using the GUI. I spent most of the day yesterday attempting to create a very simple pipeline that is triggered by a date change and updates that change in another table. I had a similar Automation that took less than 5 minutes to create. The overall layout of the pipeline: Step A - Triggered when the date changesStep B - change a field in the same table that will be used in the search (as I'm typing this a thought occurred, is the prev option available in the advanced query? for {{fid.XEX.a.$prev.field_name}}? I know the syntax is probably wrong, but will that work conceptually)Step C - Prepare Bulk Record Upsert - All three fields needed for the upsert are definedStep D - Search for changed records (even though in most cases the search will only return 1 record)In Do Loop:Step E - Add a Bulk Upsert Row Step F - Update Record in Step A to clear the search flagLoop CompleteStep G - Com
Hello: I'm working on an approval management app that will send a link out via email, that a non-QuickBase user can click on to change the status of a status field, then redirect to a thank you page. I've done this at a former company, but couldn't locate anything with the same use case.I got the link working where the status will update, however, it won't redirect to a thank you page I have setup. Here's the link that would display in the email:https://company.quickbase.com/db/btj2wrtev?a=API_EditRecord&rid=1&_fid_8=Approved&apptoken=xxx&rdr=https://company.quickbase.com/db/btj2wq5eb?a=Showpage&pageID=5The link will open the XML page with a success, but it doesn't redirect to my thank you page. I've tried dozens of variations, but unfortunately, did not get it to work correctly.------------------------------Quincy Adam------------------------------
I am creating records in Quickbase via API_AddRecord. For some reason some records are missing the "User" (email) field data. I do see in some cases unregistered users were added to the app. Then why are some records not picking up the same field data and are blank?------------------------------Deepa Prashant------------------------------
In case anyone else is looking for a solution to entering a conditional statement into a Pipeline as an out put value, here is what I learned today. Below is the syntax entered into the place where the {{ c.values }} are put in the Pipelines Designer page. If anyone knows what these inputs are named please tell me. {% if step.fieldname is gt(0) %} {{step.fieldname * -1}} {% else %} 0 {% endif %} Explanation: The statement above is an if : else statement. {% %} these things signify the conditional statement part and {{ }} these are the values the field gets if the condition is met. If the fieldname is greater than 0{% if step.fieldname is gt(0) %} then enter the value from fieldname from a previous step times negative 1{{step.fieldname * -1}} else do the next thing, which in this case is enter 0 into the fieldname from a previous step{% else %} finally end the if statement{% endif %} I looked around and couldn't find anything useful so here's a little nugget.-------
I want to change the native add record button to direct to a certain form. I know I can do tht by changing the entire report to use a certain form but I don't want to do that since I still want for viewing to be able to use the form I currently set to be using for this report.I know with a simple onload technique you can do that. Just need some guidance.Thanks in advance
Hi,I have my formula, but i need to add a condition to it LastDayOfMonth(AdjustMonth([Start Date], ToNumber([Months Needed]))) If Employment Status is FTE add 5 years to the start date (and use the last day of the month), otherwise use the formula above.How do I add that condition?Thank You!------------------------------Renee Hansen------------------------------
Hello all, I set up the GANTT plug in and I am wondering how I can set it up to display multiple projects, in case I want to compare them? I can generate project GANTTs fine. But I am having problems figuring out how to display multiple projects at once. Would love some help! Julie ---------Julia S
I am trying to figure out how if CheckBox1 is selected, CheckBox2 is cleared. If CheckBox2 is selected, CheckBox1 will be cleared. Thoughts From a new user------------------------------Steve S------------------------------
Hello,I have a button and when I use ?a=API_EditRecord&rid= it works, but of course saves the record. I would like the record to stay opened in Edit mode. So when I use ?a=er&dfid=2&rid= it doesn't update any of the fields. I need to be able to enter a quantity before I save. I'm starting to feel crazy, but I had the button working the other day fine, and the next day it didn't work. This one updates fields correctly but saves:URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & URLEncode([Record ID#])&_fid_119=" & URLEncode("Change Qty Requested") //Change Order Status & "&_fid_110=1" //Changed Item checkbox& "&_fid_111=" & URLEncode("Waiting on Approval") //Approval Status& "&_fid_109=" & URLEncode("Waiting on Approval") // Change Status& "&_fid_114=" & URLEncode([Qty]) // Change Previous QTY& "&z=" & Rurl()This one opens the record in edit mode, but doesn't
I have a pipeline which runs based on the trigger and the last modified by default field only shows my name. Is there any way I can change the last modified by or create a new field based on who updates that records, it will record that name.Thanks,Fanil------------------------------Fanil Dhirajkumar Mehta------------------------------
Hello! At our company currently we have the need to have vendors and employees submit receipts / invoices. These invoices will have amount, invoice ID, and maybe some vendor information. These invoices and receipts will then need to be correlated to specific Job IDs that will not be included when the invoice is uploaded. Currently, our accounting department seems to be doing this manually. My colleague and I reached a fundamental disagreement on how to improve data flow and are looking for some outside perspective to help forge a path forward. At this time, vendors will submit receipts through Bill.com. These "records" are then sent to our Quickbooks ledger. Once accounting does some processing the information is then sent to Quickbase where a record is created with a string of the job ID (mapped values). This creates an issue as users will then have to manually discover correlation between the invoice and the job from this table (and other places) in order to reconcile
Hello, I'm not sure if what I am trying to do is possible! I have three tables: Company, Contact, Project. Company is the parent table to both Contact and Project. Contact and Project don't have a relationship, but they could if needed. When I go into a Project, I would like to be able to see all of the Contacts that are associated with the Related Company. I'm just not sure how to bring this information into the Project. Any help is appreciated!------------------------------Cassandra Friend------------------------------
Greetings! This request may be a long shot and not even possible, but I am hoping that is not the case and there is a way to accomplish what I need... In my QuickBase App, I have a bunch of checkbox fields that the user will go through and select based on their audit process. I would like to create a new multi-select list based on the entries that have a checked box. I have been able to use the Split/List function to populate a text output. But I really need the new field to be a drop down list so when they are in Edit mode it will allow the user to select from those 'True' values. Is this even possible, or am I not explaining it good. :) Here is my Split/List code that produces the text output - Split(List(" ; ", If([D_MARx_LastName_Err] = true,"D_MARx_LastName"),If([D_MARx_FirstName_Err] = true, "D_MARx_FirstName"),If([D_MARx_BirthDate_Err] = true, "D_MARx_BirthDate") ))------------------------------Matthew Wolffe------------------------------
How via an external API call do I have to format data for a multi-line text entry field in Quickbase? I have properly obtained the JSON data but I cannot figure out how to properly format it to put it back in another multi-line text field. This is how the data looks, but it gives me an error each time I try to place it in the field. "Status: |incomplete\r\n\r\nTroubleshooting steps: |arrived onsite to troubleshoot the connection between a wall plate port and a pharmacy pc. port ph19 is not live. tried 2 patch cables neither worked. plugged pc into port ph 18 and the pc worked. i went back to the switch in the bathroom and traced thevcable from the patch panel to the switch fir ph19 and it was dead. tried a new patch cable, nothing. at this point the pharmacist told me that they were remodeling the pharmacy and there were guys running up in the ceiling and thay is when this problem started. im sure the cable was damaged in the ceiling and a new homerun cable needs ran from port p
Does anyone have a way to write the current count of a Pipeline Loop to an output field? Instead of the total loop count {{ a | count }}, I am trying to write the row that I'm on while looping through a CSV.Perhaps there is a way to index the current row from the row list? ------------------------------Daniel Dabek------------------------------
Does anyone know how to redirect to a specific location after a record is deleted using the "delete" option ("Delete this Record" or trash can) from the standard action bar on forms? I want to allow my users to delete records when viewing (typically opens in a new browser tab) and I don't want them redirected to the app home page or the table page after deleting.------------------------------John Jordan------------------------------
I have two databases and I have a connected table from db1 to db2. When the TIN is updated on a record in DB1, the change it not showing up in DB2. I have the refresh set to make the table match exactly. The refresh key is set to the record id and the key field is TIN. What is happening is the TIN is being changed in DB1 but it is not updated in db2. Does it have anything to do with the key field being set to TIN?------------------------------Carol Mcconnell------------------------------
When looking at a a field in the 'usage' section, it will let you know if that field is part of a pipeline, and say something like:CLOUDPIPES_577074646462316I know if I open a pipeline I can see the number in the address bar, but does anyone know if I want to search for that specific number, if there is a way I can find it? Essentially, I am trying to find the pipeline that includes this field without having to open each pipeline.------------------------------Mike Tamoush------------------------------
Hi, i'm having the hardest time getting data from my sql table (which i've configured and verified in pipelienes) to a quickbase table. All the tables have been created in quickbase the same as the tables and field names in sql server. I dont' know what the process is to just map column to column (as we do in SSIS). i was able to finally get odbc set up and i can connect to the sql server, but what are the steps to pull data from sql to quickbase using pipelines. I knw about qunect, we wont allowed to buy it, so i'm looking for a good alternative. people have pointed me to pipelines, but haven't been able to really help me get the data from sql to qb., ------------------------------Basil Evans------------------------------
I have a table that has employees with a Name field, a Warehouse field, and of course, a Record ID field. I would like to write a custom rule that would allow the role to view Warehouses of "Wisconsin"and "North Carolina" but not view the record with record ID "1019". So what this is doing is the person with this role can view all employees at these warehouses except for their own record which is record ID "1019" irregardless of warehouse. Is this doable? Thanks, Brian------------------------------Brian Dunk------------------------------
Number formatting in pipelines. I am trying to pass some number values in a pipeline. Simple from one table to another My number formats are 123.456,78. I don't use 123456.78 or 123,456.78 Pipelines only work if the original number format field and the destiny field both are formatted with 123456.78. Other setting multiplies de number by 10. Have tried to look up the record before copying the value. Only works with a run import API call, but I have to complicate the pipeline to use run imports…. Use a shadow table, transform the data and do an api call, merging the tables. Is there a jinja transformation needed that can solve the problem? ------------------------------eduardo valdes------------------------------
I have data with some 4,000 records, which I imported on QuickBase and created two tables sharing the parent-child relationship from one spreadsheet. The spreadsheet has several entries with the same ID, so there is no unique identifier for each record in the spreadsheet. On QuickBase, I have established a parent-child relationship. Hence, the parent table has a unique identifier, and the child has multiple records of a single ID in the parent record. The data gets updated every month and there is a new spreadsheet every month that will have some updates in the existing data records and some new forms. Can I find new records and updates in the existing records in the spreadsheet and import the updated data into two different tables that I have on QuickBase? Also, how can I automate the process------------------------------Chaitali Damani------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.