Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Is there away to freeze a field that has been updated by a formula. So if the formula changes in the future it does not change the value for a that has already been approved and processed? Example - miles rate .555 x miles if the miles rate changes in the future, I don't want the value to change of pervious rates calculated. ------------------------------Willis Taylor------------------------------
I'm searching for a way to use a record picker field without a related table. I want to add a record and as I can enter part of the data the matches are listed in the dropdown, otherwise, I have the option to add the record. I can only find ways to use this function from child table. I'm sure this is easy to do and I'm just not seeing it. But I would be eternally grateful if someone could say, "it's right there in front of your face!"------------------------------Barry Dolan------------------------------
I would like to be able to click the phone number in contacts and use my computer's default dialer to place a phone call, just like in the system you click an email, and my default email pops up to complete the email. ------------------------------Cassie Hubble------------------------------
I have built a formula for a multi-select formula field. The formula looks like this: GetFieldValues(GetRecords(("{F1.EX.'"&[xxx] &"'}"),[_DBID_xxx]),F3)). The formula is working fine. But it also populates duplicate values. How can we get distinct values from a list? ------------------------------Amir Sohel------------------------------
Hi, i am applying daat validation on table form. i wrote one condition for mandatory manager email while filling up form. the validation works fine. but i could also see different error message i do not want display on end user side. how remove "Order manager(Email) is equal to <blank>".
I need a Formula Checkbox that checks against emails entered in a field on another table or a list of emails. ------------------------------Stephanie Milburn------------------------------
Hello,I have a strange issue that I cannot seem to find an answer to. One user has an issue seeing an editable report on a form. When he pulls the form up, the grid edit appears but with only column headers and no rows so he cannot actually enter data. Below are some troubleshooting steps I have taken.Permissions:I have checked his permissions, and other users with that role do not have this issue. I gave him administrator rights and had him checked and the same issue occurred.Forms:I switched both the form and the report and the same issue occurred.Browser and Computer:I have checked his browser, and other browsers with his login have the same issue. He even tried another computer and the same thing happened.Can anyone tell me if there are any other troubleshooting steps I can take?------------------------------Ezra Torres------------------------------
I am creating a customer portal application where I want our companies customers to be able to submit a record to a related app via a custom URL save button BUT I would want the QB native "Save and Close" button to not show up. Any thoughts on how to achieve this? Would I have to make changes to the users role permissions?------------------------------Joshua Case------------------------------
I was just told by Support that I would have to make our developer/integrator a realm admin in order to get the Switch User option in Pipelines. Our previous integrator became suddenly unavailable, and I have hired someone to take her place.Am I overreacting to say that QuickBase should fix this so that a Realm Admin can allow a third party the Switch User option rather than having to make them a Realm Admin?------------------------------Denis Rochat------------------------------
Will this rule trigger to check the checkbox field named "14day_renewal" 14 days prior to the date in the field "Subs_To"? ------------------------------Brian Dunk------------------------------
Hi, i would like to see which Database has been connected quickbase tool by default. how we can see physical data base and tables for which we created tables from QB application end.
Team, i have an requirement like i need to upload CSV data into quick base application from my Own Personal system. i tried myself but getting this error. can some please correct me.
Hi, I have a "Control Number" field that has to be 7 digits. I need to prefill when it is not. See example below I used "1" but it can be any number and I need to make it 7 digits. 1 needs to be 0000001 11 needs to be 0000011 111 needs to be 0000111 1111 needs to be 0001111 11111 needs to be 0011111 111111 needs to be 0111111 Thank you in advance. Kathy------------------------------Kathy Benjamin------------------------------
Since java is no longer supported, is there a method for creating a button that will mimic the save & keeping working button? I found older threads on this topic but nothing recently. Seems like a nice easy customizable functionality that would make workflow a little easier. I personally think we have to click the mouse too many times to do our jobs as it is. A little bit of automation would be nice. Any thoughts?------------------------------Barry Dolan------------------------------
We need to populate a 'month' field if family member 1 or family member 2 has a birthday that month. Each month has its own field. In this example, I am using the MAY TOUCH field. So, if (family member 1 or family member 2 has a May birthday) and MAY TOUCH is blank, add the value 'Birthday Month' to MAY TOUCH. However, I get the red box around that field which means something isn't right. I have scoured this forum and can't seem to figure out what part of the code is wrong. I have tried many different words like isNull, ="", and using quotes around "Birthday Month", etc, but none of those work. Here is my code:{% if (a.account_number_family_1_birth_month_3_charac is May or a.account_number_family_2_birth_month_3_charac is May) and a.may_touch is not defined %}Birthday Month{% endif %}The second part of this will be....if MAY TOUCH is defined, then MAY TOUCH value will have 'Birthday Month' appended to the text already in the field.Step A in the Pipeline is Search Records where account_
Is there a way to disable Import from clipboard option to not recognize text as "Importing from Microsoft Project" or to have it "unchecked" by default, or diable completely?Recently my users started to receive error "Access needed" when uploading data, as this option is by default ticked.I wrote to them to untick it but to avoid further questions and "access requests" I wanted to check if possible to disable it. EDIT (add picture with option "Importing from Microsoft Project" visible)------------------------------Adam Krzyzanek------------------------------
I have an application that has 3 different forms based on the data necessary. When the form is submitted a field is changed to the type of data entered, "Flyer Request", "Rep Sample", and "Project Worksheet". Based on this I can then create reports on each type of form submitted. I just created a Summary type report to display the amount of each of the three type of submissions that were submitted in the past week. When I run the report the summary works fine, however when I click on one of the form types to show a "Drilldown" report it shows me fields that have nothing to do with form submitted. How can I adjust the fields displayed based on the type of form that is clicked on in the Summary report?------------------------------Brian Dunk------------------------------
Hello Quickbase Community! I am doing a development for a project. Years ago a search button was made like this: Image #1 Does anyone have any idea how this is done? It is not a field.I look for them within the form and it does not appear, its function is only to search for a record in a table. Thank you. Regards, Herberth Solano V. ------------------------------Herberth Solano------------------------------
Please help me with the formula to move and delete the records with API button in quickbase between two table URLRoot() & "db/" & [_DBID_INPROGRESS] & "?act=API_AddRecord"& "&apptoken=dpvtvtrbuvtrjjd5ydp38bccn9np"& "&_fid_23=" & URLEncode([Task Type Details - Task Type])& "&_fid_24=" & URLEncode([Task Name Details - Task Name])& "&_fid_13=" & URLEncode([Study Number])& "&_fid_14=" & URLEncode([BMS-TMF-Number])& "&_fid_15=" & URLEncode([Site Number])& "&_fid_16=" & URLEncode([Country])& "&_fid_17=" & URLEncode([Request Received Date])& "&_fid_18=" & URLEncode([TAT])& "&_fid_19=" & URLEncode([Planned Completion Date])& "&_fid_20=" & URLEncode([Assigned])& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_INPROGRESS] & "?a=dr&rid=" & [Record ID#])& "&disprec=1"& "&_fid_21=" & URLEncode(URLRoot() & "
Is there a way to disable Import from clipboard option to not recognize text as "Importing from Microsoft Project" or to have it "unchecked" by default, or diable completely?Recently my users started to receive error "Access needed" when uploading data, as this option is by default ticked.I wrote to them to untick it but to avoid further questions and "access requests" I wanted to check if possible to disable it. ------------------------------Adam Krzyzanek------------------------------
If(Contains([Status] , "Start Task")," ",URLRoot() & "db/" & [_DBID_INPROGRESS] & "?a=API_EditRecord&apptoken=dpvtvtrbuvtrjjd5ydp38bccn9np&rid=" & [Record ID#] & "&_fid_45=" & URLEncode("Start Task") & "&_fid_6=" & Now() & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_INPROGRESS] & "?act=dr&rid=" & [Record ID#]) ) I'm using above formula for hiding the API button but it is not hiding please find the screenshots------------------------------manohar vankireddy------------------------------
I understand, with ALM activated, table-to-table imports do not work within Automation's. I understand, with ALM activated, I am physically able to go into the configuration for a table-to-table import and manually trigger it. What, if anything, is a valid work around to overcome this issue with ALM activated? I have a number of fields across a number of tables that have two instances for each field - a 'read' and a 'view' - that, based on a users permissions, may get out of sync.Previously, I would run an automated table-to-table import on each table on each occasion a record was added / modified and a trigger was activated. I would also run a catch all table-to-table import across all tables on a daily routine to pick up any mismatches triggered by the rollover to the next day.I have a need to keep ALM activated and work in a sandbox for an extended period. This means currently I am having to go in manually on a daily basis to trigger the table-to-table imports. Frustrating and ine
We're switching to using pipelines and need to be able to create a sandbox where pipelines will work in the same way as the live application so that changes can be tested before implementation. I've read that 'A sandbox does not support tracking or publishing changes to automations, actions and webhooks' (see Sandbox limitations and details). Does that mean when a sandbox is created, automations, actions and webhooks won't work on the sandbox? Pipelines aren't mentioned here, but I guess they are likely affected in the same way. If pipelines won't work in the sandbox (which I guess is the likely situation) could we create copies of our pipelines and search/replace DBIDs between the export and import to point them to the sandbox?We're likely to make changes in several iterations and I wondered if the DBIDs from the second sandbox would be different from those in the first sandbox (meaning we'd need to repeat this exercise every time we created a sandbox). Has anyone tried this
I have a pipeline like: Webhook: incoming request json body with { "bucket": "some_bucket", "key": "processed/some_data.csv", "partner": "c1", "table_id": "abcdefghi", "headers": "a,b,c" } S3: Lookup an Object bucket = {{a.body_json.bucket}} key = {{a.body_json.key}} Quickbase: import with CSV table = {{a.body_json.table_id}} merge field = fixed_merge_field csv url = {{b.file_transfer_handle}} first row is headers = True header row = {{a.body_params.headers}} First two steps appear to work. Third step does not expand the jinja template and appears to insert a literal string. Is jinja prohibited in certain fields? Do I need some extra magic to make this work? ------------------------------Dan Locks------------------------------
I'm trying to set up the default Record Picker fields on a table. The table is called Landing Pages because it's about identifying specific web pages--especially by their URL. However, the dropdown for selecting the Record Picker fields does not include the field I need, which is the URL field on that table. Is it possible that Quick Base doesn't allow a URL field as a Record Picker field?------------------------------Kevin Gullickson------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.