Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I am trying to create a Button that opens a specific form from a table within my app. I change the "fid_XX" to any of the form ID's and it doesn't matter. The form roles are overriding what form opens and opens the form designated in the Form Roles section. Here is my current URL for the button: URLRoot() & "db/" & [_DBID_NOTES] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Employee ID])& "&z=" & Rurl() It doesn't matter if I change "11" to "2" whatever is select in the form roles section opens. Can I specify the form to open and still have it open in Edit mode? Thanks, Brian------------------------------Brian Dunk------------------------------
Is it possible for me to use a report link or any other trick, to display a record (and specific form), in the record I am currently in? Essentially, I would need to display a URL in some sort of embedded way, if that makes sense.------------------------------Mike Tamoush------------------------------
Hi,I'm new to QB and API. I'm trying to update a field (checkbox) in a table for multiple records using an unique Key field.I managed to update the field for one Key field, but failed to update multiple in one request.My script for one record looks like :{"to": "ID of my table","data": [{"72": {"value": "unique Key field"},"60": {"value": true =>tick the checkbox}}],"fieldsToReturn": [3]}Is there a simple way to run this action with multiple values for my FiD 72?Thanks for your help.------------------------------David NEGROBAR------------------------------
Hi, I am looking for a way or the best way to filter some comments in a project record. I have a table called projects and a child table called comments, in order to follow the process the users will add comments. I will need to let them search and filter the comments the best possible way. I thought that maybe when adding a comment they could set different key words and base their search on that, but I was looking for an opinion or help for this. Thanks!------------------------------Francisco Ojeda------------------------------
I'm trying to build a mentor tracking app for our employee group. I have a table of new hires and a table of mentors. Currently, I go in to edit the existing record and "assign" the mentor to the new hire using the related text lookup. I'm wondering if there is a way to add a link or button in the table that would bring up a form or something that could do this all from the dashboard without having to go in to edit the record. Thank you!------------------------------Hannah Engelson------------------------------
I have projects that run multiple days and would like to record for each day: (1) Num. Laborers (2) Num. Hours I want the number of form fields available to fill to be related to an entry titled "Num. Days". Such that if I enter n days, it creates fields for Day 1, Day 2, ... Day n. Is there a way to automate this or do I need to manually duplicate the same fields for n days?------------------------------Elizabeth Berrett------------------------------
Hi everyone, I'm going in circles trying to figure this out, and I'm just not quite sure how to achieve what I want to do. I'm trying to customize one of the Project Management/Task Management templates in the library; many 'tasks' in our organization come with 20 or 30 "sub-tasks", and that's where I'm a bit stumped. If I build a table which contains a list of sub-tasks that are standard and apply to a specific task that is recurring, Then when a project is creating, the 'task' is selected, and all the sub-tasks automatically get assigned. Has anyone tried to do this? Could it be done using the list of sub-tasks that relate to the 'parent task' to create a kind of summary table, where a field gets created that lists all the subtasks (with checkboxes) - because I wouldn't want the 'Task' to be marked as complete until all of the sub-tasks are completed. Ideas? an example would be: HR Manager creates a project for a new hire and assigns the task: Create New User Accoun
Hi, I copied the URL for New Activity in one app and used as a button in another app to act as a "Create New Record Button". Question, is it possible to add a default value to the URL? I would like the related activity code for a field to always be 7 when this URL button is selected. Thanks!!------------------------------Christine White------------------------------
Hi, Has anyone in this community have users in China that have experienced QuickBase API call errors such as these: The users have used VPN, they are able to log in, but cannot proceed with anything else. So they are stuck. It could be the firewall, but we are trying to figure out solutions. Thoughts if anyone else has seen this... Thanks, Sandra. ------------------------------Sandra Fernandes------------------------------
I have an app where values get entered daily. I want to create a report that shows only the top 25 of all time and then a summary of how many of the top 25 were in each year. Not sure where to start?------------------------------Steven Nelson------------------------------
Hi, is there a way to use rich text in Quickbase? Currently I am using plain text but would like to be able to highlight areas with italics, bold, color etc. Please message if you know how. Thanks!------------------------------Elizabeth Chewter------------------------------
I am creating an ask the user report and would like to add some instructions or clarifications to the mail report page (where the requested fields show for input). Is this possible? If so, can anyone point me to a help article or site to help me configure it? Thanks------------------------------Ember------------------------------
I have a field that I would like to set up if certain selections are made then I want the field below it to only populate the additional options based off of that selection. I would like to do this without creating multiple fields for the selection categories and not have to use a dynamic rule. is it possible to set up 2 fields to interact this way without using a dynamic rule?------------------------------LB------------------------------
I'm trying to set up in a pipeline an email with attachments (outlook). When I include the browser url of the field where the document is that i want to attach, it errors and says there's a permissions issue. What do I need to change to have it attach the file in the "file upload" field of the table? ------------------------------Jeff Elliott------------------------------
Can anyone else confirm that the %%rid%% functionality that is supposed to grab the new record ID, has suddenly stopped working? **Did not mean to post this. I was meaning to cancel and accidentally hit save. Functionality appears fine. ------------------------------Mike Tamoush------------------------------
Hello All - I have created a survey form that includes a variety of questions. For one of the questions, I would like the user to be able to rank 7 different options from 1-7 Example: How would you rank the following 7 areas from most important (1) to least important (7)?: Option 1 Option 2 Option ... Option 7 I am completely lost on how I would achieve this and have it work on an html webform open to Everyone On The Internet.------------------------------Myoshia Boykin-Anderson------------------------------
I have a "definitions" table and a "citations" table. One citation can be related to many definitions. The data for both was populated by importing from a spreadsheets. The Definition table has a "Citation" field with a short version of the citation. The Citations table has an "ID" field that provides the same format used as the Citation field in the Definition table. I would like to relate the Definitions to the citations by matching the Citation field in the Definition table to the ID field in the Citations table. I can't figure out how to do this using a Table‑to-Table relationship. Is there a fairly simple solution that will enable me to do this in QuickBase? Or am I going to have to manipulate in Excel with vlookups to associate a citation record ID with each definition record and do an update import?------------------------------Paul Easton------------------------------
Hi,Someone may have answered this question already but I cannot find. I am trying to set up a table (A) to store employee names that I can add or delete as they come and go. Along with the employee name will be the crew ID (A,B,C or D) and position title. In the other table (B) I want to select the crew ID and when I do it automatically populates the employee name associated with the employees title and crew. So for the Supervisor title it will populate one field that is named Supervisor with the employee associated with that title and crew.I can easily make this happen in an excel VBA userform but cannot seem to figure it out in quickbase. Thanks,David------------------------------David Isely------------------------------
Hi, I am trying to set dependencies to different stages in a process. I know that for setting dependencies for tasks, Quickbase has the Predecesors field, But what I need to do is to "lock" the next stage (of my kanban) until the tasks that are opened in the present stage are already completed. I think I saw a video of someone doing this but I cant find it again. Does anybody know how can I do this? Thanks!------------------------------Francisco Ojeda------------------------------
Hi, I am developing an app for project management. It has a table called Projects and each projects goes throughout different stages in wich some tasks are asigned to different people. Our PMs needs to see the days spend in each stage in order to see which stage is the more time consuming. So, I need to count how many days it has been in that stage and when it change the stage to keep that information. We see the process through a KanBan report, I will like this "Days in stage" field to be seen in the kanban card. How can I do this? Thanks!------------------------------Francisco Ojeda------------------------------
I am trying to create a rich text field to put in the form that shows what the current value is in another field. This doesn't work directly in the new form. Instead, I am building a formula rich text field that I will then add to the field. I am getting an error that I'm not sure how to get around: There are extra characters beyond the end of the formula. Thoughts? "Current State is" ToText([state])". Current Target Completion Date is" [target completion date]"." ------------------------------Elizabeth Schlagel------------------------------
I am trying to create a pipeline that searches a record where a date in step A matches a date in step B, but the only options on the pipeline is where the date is: set, not set, before, after, between, not between, more than or less than equal to is not an option here. Is there a way to use an expression instead to say where date in step A matches date in step B?------------------------------Amber Goodman------------------------------
In adding a Report component to a new form, and using the form element option to "Filter using report link settings"... even with "Value Matching" in the Report Link field options not checked, it will only display a record if that exact string matches and is the only value in the Target field. Same Report Link field filters perfectly in old forms, but not in new forms. Has anyone else come across this? Is it just a bug in the new forms? Or are there tweaks that need to be made to target fields, etc in order to filter correctly on the new forms? Would love to use the new forms, but definitely want to be able to see the filtered report directly in the form ------------------------------Sam Cole------------------------------
Hi,I am trying to create a sort of workflow for people creating a case.Essentially, I want them to:1. Choose a department.2. Then choose a level based on the chosen department.3. Then choose a role based on the chosen level.4. Then choose Position ID based on the options left from filtering it down to this.Does that make any sense?Thanks!------------------------------Renee Hansen------------------------------
I have two Tables. Table 1 is a list of locations. Table 2 is a list of tasks. Some tasks apply to a specific location and some tasks apply to all locations. I have a table to table relationship set up (1 Location can have many tasks) and can view the Location Specific tasks under the location record in Table 1. I am not sure how to get the tasks that apply to ALL Locations to show up under each Location record in table 1.------------------------------Nick Bellows------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.