Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
So I have a code page that is client facing so when the user hit submits (the submit button) I would like them to be directed to another webpage (code page) that in the URL holds the newly created record id. Below is some of the code: The xxxx are placeholders</table><input type=hidden name=rdr value='https://xxxxxxxx.quickbase.com/db/xxxxxx?a=dbpage&pageID=2'><input type=submit value=Submit>ideally the value should be: "https://xxxxxxxxxxxxx.quickbase.com/db/xxxxxxxx?a=dbpage&pageID=2" + "&rid=" + ridHere is the java code:$.ajax({url: "xxxxxxxxxxx?act=API_AddRecord",type: 'POST',data: req1,contentType: "text/xml",dataType: "xml",processData: false,success: function(data, status, xhr) {var _rid = $(data).find('rid');var rid = _rid[0].innerHTML; var customRedirectURL = "https://xxxxxxxxxxxxxx.com/db/xxxxxxxxxxxxx?a=dbpage&pageID=2" + "&rid=" + rid; window.location.href = customRedirectURL;------------------------------Lija Harris--------------
If I have several logged Notes fields, and I use a combined text field, is there any possible way to put the notes in date order, newest to oldest? To be clear, each combined text notes field will only include ONE date, so I do not need to separate the notes in a particular field and rearrange them. My instinct is to break the combined text into many parts, extract the date from each part, and then somehow arrange from there??------------------------------Mike Tamoush------------------------------
Hi everyone,On several of my tables I have a User To Receive Notifications which is a formula list user field. It takes the various users involved in a project from various user fields on my projects table and aggregates them into a user to receive notification. This way if, for example, someone uploads or adds comments to a contract everyone involved gets a notification. The problem with this is the user that edits the record also gets the email notification. They really do not need it since they made the change, it just creates another email.Any idea on how to prevent the "current user" from getting an email notification? It needs to be dynamic as we never know who will add the comments but they dont need to get their own comments in an email.Thanks!------------------------------Ivan Weiss------------------------------
I've a notification which triggers when some specific fields on the form changes. Current functionality does not show the field changes in the email body so it's difficult to identify what was really modified. We would like to include the only fields which were modified with the before/after field values in the email body. Is there any way to do this?------------------------------Mrunali Kadam------------------------------
in a form I have 5 required fields, two of them are date type, doing tests I filled in 4 required and tried to save the record, it shows me the message that I need to fill in a required field (that's fine) but when I click on okay to the message and then return to the form, it autocompletes the missing field with the value of another date type field------------------------------Maria Del Carmen Ortiz Garcia------------------------------
I have a code page input form as a easy web intake interface for our clients. I was able with the form wizard to grab all the input fields (example code is below). However, I was wondering if it was possible to add a formula field to the code page? Specifically a formula - text field that is just static text but needs to be on the code page. Is it possible to put a formula field that is static on a code page (html/javascript):<h2 span style="color: white; font-family: Sans-serif; text-align: center; background-color: #358281;">Customer Data Intake Form</h2><form name=qdbform method=POST onsubmit='return validateForm(this)' encType='multipart/form-data' action=https://blahblah.quickbase.com/db/XXXXXXXXx?act=API_AddRecord&apptoken=xxxxxxxxxxxxxxxxxxxxxxx><input type=hidden name=fform value=1><table class="center"><table><tr><td style="font-family: Sans-serif;" class=m>Contractor Business Name:</td><td cl
If I am using a Sync to a Box Drive, and also using a Pipeline, what time zones does each use?The sync I would presume the time zone of the App? The pipeline....if it uses multiple apps - time time zone of the trigger app?------------------------------Mike Tamoush------------------------------
HI All, When I apply an initial filter to a report and then added it a dashboard and then user a filter on that report widget in the dashboard it seems to wipe out the initial filter of the report. Is there a way to make initial filters operate like a view in a DB? What I would like is a way for all filters applied after an initial filter be "and" conditions on top of the initial filter ? Is that setting available today ?------------------------------ARIC WALKER------------------------------
This one has me confused. I have a step in a pipeline to update a field in a table with the record ID from another record in another table. I have a search in step E for records that match a criteria. If the records don't exist, the pipeline makes one and captures that new record's ID in the original record. If the record does exist, it (tries to) copy the record id of that record into the original record.For some reason, Pipelines is seeing the record ID as the literal text {{e.id}} rather than the number. But, when it creates a record, it has no trouble using {{f.id}} (the created record) as a number.I've included the YAML since I've spent an hour trying to figure out why one branch works and the other doesn't.Any help on how to get the existing record ID copied over? Either what am I doing wrong, or a possible work around?The specific error is: Validation error: Incorrect template "'{{e.id}}'". ValueError: invalid literal for int() with base 10: 'id' Input/output Input (Mappin
I was wondering if it is possible to use the API_GetSchema to retrieve the next record id from a specific table - query that and display the result on a code page? Basically I have a code page in HTML and Java that is a customer intake form. What i would like to give the customer is a unique id or code to reference once they have submitted their form. I would like to use the record ID as this code but having trouble putting that information on the code page.------------------------------Lija Harris------------------------------
I am working with two tables: Parent Table: Work Orders Child Table: Status History I have a formula-URL button that is supposed to do multiple things: Add a record in the Status History table: [Type]=Work Order Status, [Status]=Closed, [Status Changed By]=Current User If [QC/QA Status] Contains "QC/QA Fail", then Add a record in the Status History table: [Type]=QC/QA Status, [Status]=Revision Complete - QC/QA Needs Review, [Status Changed By]=Current User Open Code Page 9, Prompt User for Comments, then Edit the record added in step 2 by populating [QC/QA: Work Order Review/Revision Comments] with User Prompted Input. Everything works perfectly, except the User Prompted Input doesn't populate the [QC/QA: Work Order Review/Revision Comments] field on my Status History record (created in Step 2). I've tried including a formula query (as a variable) and referencing it in my formula to use as the Record ID from the record added in Step 2 above but it didn't work. Then I tried us
Hey All,I am having an issue with my custom reports that I have created. I have about 18 different evaluations that I want to have their own report (where it only shows the responses to "Evaluation A" in "Report A"). In order to do this, I created a hidden variable in each evaluation and then set the default value to a defined value (see below):I then used this hidden variable as my filter in the reports, where it only populates the report when that specific variable equals the default value (see below):The issue is that the filter is not filtering anything out. All responses to all evaluations still appear on every report. The 6 responses shown below were not from the "Health Professional QA" evaluation, which is the only evaluation where the hidden variable "Eval_Type_HealthProf" even exists. So why is it saying that there are 6 evaluations where "Eval_Type_HealthProf is Health/Professional QA" (the default value for that variable and the filter criteria) when the variable "Eval
I have a litigation matter that is showing as QB Status Inactive. How do I make this matter Active? It is an active litigation matter and should not show as inactive. This is not a field I can edit. It's affecting our reporting. Any help is appreciated!------------------------------Amber Beale - Senior Paralegal------------------------------
One of our quickbase users encountered an issue when saving an outlook email as an attachment in a record in Quickbase. She drags and drops an email into the file attachment but the file doesn't save as a msg. It is opening a blank tab with no information. Has anyone else experienced this? How do we fix it?Thanks!------------------------------Nancy Wagner------------------------------
It looks like based on the permission options we should be able to trigger a pipeline based on an email received in a shared inbox?I don't see anywhere to access the info/folders/inboxes of the shared email address while connected to the Outlook Channel using my account - I only see my personal folders. Can this be done? What am I missing?------------------------------Dan Beauchamp------------------------------
Hi all, I want to first note that I've seen the really excellent explanations by Sharon Faust (QuickBase Junkie), Scott Galloway, and what's on QB University for doing something similar (but less complex, I guess) to what I'm about to describe. I'll link to those at the end in case anyone stumbling upon this could benefit from those. Ultimately what I'm trying to do is use the Audit API to generate a CSV file and drop it into a third party cloud storage location. Most of the individual pieces of this are in place. I can pull data from the Audit API. I can generate a CSV by pushing query results into a Bucket channel pipeline table (if it doesn't require pagination, which is the big issue – more on that in a minute). I can then use the "Download CSV" step to grab a download URL for the CSV. I can then use the "Fetch CSV" step to grab the CSV data, which I then send to the third party cloud service with a "Make Request" step. The problem for me is that the Audit Log generates tens
I need to come up with a formula that evaluates the closest past date from a reference date. For example, If the dates are Jan 2022, May 2022 and my reference is April 2022, then I must go with Jan 2022 and not May 2022.------------------------------Karthik Sekhar------------------------------
Does anyone know if it's possible to create an api link to Microsoft's "Dynamics 365" : Business Central product?We would like to push data to Dynamics 365 to utilize their Biz Central financial tool.Thanks,Rob
Scenario:When a date has been entered in the [SYSTEM START] field on the JOBS table,Create Record in the MATERIAL ORDERS table and populate the [ORDER TYPE] field with DWAND...Create a 2nd record populating that record [ORDER TYPE] field with PRIMENOTE: [ORDER TYPE] is a Multiple Choice field...is this the problem?------------------------------BuildPro------------------------------
I want to pull a value from one table based on a field in another table.I have a summary table with raw material prices, lets call this table B. each entry is for a different month/year, so this field is text. It is called Date and the field id is 10 on my raw materials table. The other fields on this table are numeric and have various RM costs. For this example I'll use: RM 1, field id 25.I have another table with customer product information, lets call this table A. I use this table to calculate product margins at a certain time. This has a field called Date as well and it is a multi select text field, id 120. There is another field on this table called RM A Cost, this is where I am entering the formula.When field 16 [Date] on table B = field 120 [Date] on table A, return the value from field 25 [RM1]Here is the formula I used:GetFieldValues(GetRecords("{16.EX.'"&[Date]&"'}","tableB"),25)It is not returning a value. It is
I am getting an Error with my Pipeline that is trying to insert a text field in to a text multiple choice field of the same record.Error reads: "Remote service reported an error: 2 : Invalid input : You must provide a valid choice for the field named "Water" with field id 59."My source fields must be text fields. The receiving field must be multichoice as the user may change the field after the pipeline runs.Any ideas how to work around this?------------------------------George Bramhall------------------------------
Has anyone else run into issues getting Formula-Rich Text fields (as buttons) to run a process when clicked?Formula-URL buttons work as designed, but when I try to consolidate multiple buttons into a Formula-Rich Text field to conserve precious real estate on a Dashboard, clicking the button returns an errorThe buttons add a child record and redirect to where the button was clicked.They work as designed when they are clicked from a Home Page or a report, it's only on the Dashboards where these fail.------------------------------Eric Evans Vargas------------------------------
I have been trying to prepopulate an add button to take the current user and automatically add a new related record and user to a child table.I have three tables - Contract Coaches (synced table from another app, key field cb_id). Contract Coaches is a Parent to Contractor Projects. Contractor Projects is a parent to Project Bids. Contract Coaches is a parent to Project Bids. In the Contactor Projects table I have a button, Bid Yes, to Add a record to the Project Bids table and prepopulate the Project Bid yes/no field (which it does) but also prepopulate the related Contract Coaches field with the current user so they don't have to pick from a dropdown. There are no related Contract Coaches from the Contractor Bids table as Contractor Projects data is filled in by the Project Manager.This is my current button formula:URLRoot() & "db/" & [_DBID_PROJECT_BIDS] & "?a=API_GenAddRecordForm&_fid_17=" & URLEncode ([Record ID#])& "&_fid_67="& URLEncode([Cur
I want to add color to the form background. How do you change the color of a form background?.
Hi,I have a html code thank you page, that the user sees after clicking submit (via another separate html code page that uses API_AddRecord). I would like to have the record id that was generated be visible on the thank you page. So that when the user clicks submit, they get the thank you page with their respective record id to reference. Is this possible in javascript or html?Below is the thank you page code:<p style="font-family: Calibri; font-size: medium; text-align: center;"><strong><span style="font-size: 16pt;">&nbsp;</span></strong></p><p style="font-family: Calibri; font-size: medium; text-align: center;"><strong><span style="font-size: 16pt;">Thank you for submitting your Form. </span></strong></p><p style="font-family: Calibri; font-size: medium; text-align: center;"><strong><span style="font-size: 16pt;">If you have any immediate questions, please contact us at th
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.