Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi,I have created a table that is called upon another report from time to time. However it has a specific sorting and grouping rule that is to be followed. Likely so : - The Materials list is to start at the topmost of the table, Followed by Services & their different kinds. But every randomly on some days and on some devices / systems the order is completely disrupted and distorted reasons being very unknown. Here, the Services & their kinds are sorted out to be at the top of the table followed by Material - Which is completely incorrect. Currently I have understood that by Reloading the page ie. editing and saving the same report again the issue is resolved. But that is just temporary if i may say.Can anyone assist with any part of the settings or filtering that I may be missing due to which this is caused. ------------------------------Rasika Bhosle------------------------------
On one of the Home Pages, the buttons have a border around them. I cannot figure out how I did this, but would like to do it again.------------------------------BuildPro------------------------------
Hello,I am getting stuck trying to make a rich text/multi-select text result value into an actual numeric value , I have the following Formula rich Text Field which will result in a specific dollar amount, var text NextLease = "{6.EX.'"&[Related Unit]&"'}AND{168.EX.''}AND{142.XEX.'Application in Process'}AND{291.XEX.'Yes'}AND{475.EX.'"& [Query Next Valid Lease (Renewals)] &"'}"; SearchAndReplace(ToText(GetFieldValues(GetRecords($NextLease,[_DBID_RENTAL_DETAIL]),69)), ";" , "<br>") Alternatively, this is what I have for the Multiselect version of this field var text NextLease = "{6.EX.'"&[Related Unit]&"'}AND{168.EX.''}AND{142.XEX.'Application in Process'}AND{291.XEX.'Yes'}AND{475.EX.'"& [Query Next Valid Lease (Renewals)] &"'}"; SearchAndReplace(ToText(GetFieldValues(GetRecords($NextLease,[_DBID_RENTAL_DETAIL]),69) However, this isn't a true value, it looks like a dollar amount, but the system is not fooled!Is there a way for me to convert the rich
I am trying to create a calendar that shows 2 different tasks to do. Each has it's own date.------------------------------BuildPro------------------------------
Hello!I recently figured out how to rank records in QB by using the Size function to organize records chronologically.I'd like to take that a step further and be able to rank records that fit a set of criteria and then query the very next record in the ranked sequence.In other words, if I have 3 records Ranked 1, 2, 3 -I'd like to be able to query information on Record 2 from Record 1 and, I'd like to be able to reference Record 3's information on Record 2.If anyone has any suggestions, even if it's not specifically the size function, I'm all ears!Thank you!------------------------------Liz Chartrand------------------------------
I have 3 tables:Tag Library - A table containing barcode information for thousands of pre-printed tracking tagsItem Type A - Table of type A items which will be tagged using tags from the Tag LibraryItem Type B - Table of type B items which will be tagged using tags from the Tag LibraryOnce an item (either type) is assigned a barcode tag, the Item Type table will have a "Tag Number" field which will contain the human-readable version of the barcode from the tag (using the "Get this field's value from a lookup field and don't allow the value to change" in the field settings)Each tag can be used only once. So, if a tag is used on a Type A item, it cannot be used again in the future, and likewise for Type B items.I have done some research and determined that I will likely need a join table, but the example I saw only has 2 tables, so I am having a little trouble trying to figure out how to set up the relationships and configure the join table.Thanks in advance!----------------------------
Hi I have a button that adds a child record to a table with various data from the related table. It's involves three tables: a Company, Quote and Asset. When products quoted turn into a sale, the user clicks the button to create an Asset record on the related Company record with info pulling from the quote regarding the type of equipment purchased, sales order number, etc. Clicking a button causes a checkbox to be checked. The automation runs based on that checkbox being modified to checked; the last step of the automation is to uncheck the box. This works just fine. Since it's capital equipment most often sales are 1-2 items, meaning the button may need to be clicked once or twice to record the assets.Sometimes we get bigger orders at which point it becomes annoying to click the button 10-20 times. Also if the user isn't patient between clicks giving the system time to run the automation, it may not register all the assets.I'd like to ad
Is there any way to change the name of the column dynamically? I want to change the column name to JAN YEAR(TODAY()). Or a value in field.------------------------------Jim Boozer------------------------------
Hi All,I have a Stores table that contains all the data for my stores, including the Delivery/Install date for the equipment we're installing.I'm trying to create a stacked bar chart that shows the number of installs we can schedule in a week vs the number we have actually scheduled (to show how much contingency we have)So for example, in week 1 we could schedule a total of 16 stores. We have scheduled 12, so we have room to schedule 4 more. I think I need the following fields:Week Number (1 to 23 - based on the first day of the week of the Delivery/Install Date)Weekly Capacity - varies by week number, as some weeks have holidays, so less capacity# of Stores Scheduled - how many stores have a Delivery/Install Date in a given weekThe Delivery/Install Date and Week Number fields are in the Stores table. To get the # of Stores Scheduled, I'm assuming I would need to create a summary field in a parent tableI've tried creating a "Capacities" table, with the week numbers and the capacit
I have a simple numeric formula field that sums 8 different fields. However, the result appears to be off by .188 (the total should add up to 11.65). I have quadruple checked the formula and related fields and dependencies and can't figure out why. Any ideas?------------------------------Kiel Berry------------------------------
I am trying to create a formula checkbox for if a checkbox field is not checked and a date field is before today, check this box. It is not working and I can't figure out why. This is what I have: If([Modifications Finalized Checkbox],false & [Session Date]<Today(),true, false)It is telling me that I cannot use '<' because that cannot be used on type text and date. Session Date is a formula date field: ToDate([session_start_time])Can anyone assist?------------------------------Dawn Rene------------------------------
Hello,I have a question needing help with a formula. I have a field called "Start Date" and whatever date I put in that field I want it to auto-populate 3 other fields called "Week", "Month" and "Year". So if I put todays date in the "Start Date" field it would show 7 since its the 7th "Week" in the calendar year and would show 2 in the "Month" field (February is 2nd Month in the year) and show 2022 in the "Year" field. Any help to create this formula would be appreciated.Thanks,Derek------------------------------Derek Pipal------------------------------
Hi,I need to upload a submission (service report) pdf file from FastField to an attachment field in QB.FastField doesn't enable using URL in this case, so I cannot use Upload File from the QB Channel.Instead of that, FF provides a Create PDF Report API (POST). I used both Fetch JSON and Webhook (Make Request) to call that API. In the response I really got the pdf file ... Access-Control-Allow-Headers:"Content-Type" Content-Type:"application/pdf" ...but I don't know how to "pick it up" to QB. Iterate over JSON Records doesn't work (because it is not JSON?): Validation error: Invalid JSON received Do you have any hint?Thanks in advanceAlex------------------------------Aleksandar Lazic------------------------------
Hello,I feel like this is so simple but I've attempted a few different ways to do this with no luck.Every time I input a new record into my projects table, I have to confirm an agency associated with it. We finally found a source we want to use with a specific URL link.I've attempted to generate a new URL field and place the link in the default value for us to select it each time we generate a new record and it doesn't show.I've tried the formula - URL as I have buttons that do other internal actions and figured if I input the URL and selected open new window this would logically make sense but my input is wrong. I'm open to any situation, however the goal is the same URL is applied to the field on any new record for us to select when we are creating a new record. If I can make it a button that's selectable I'd love that as well, but if it's not possible I'm more than happy with a consistent link that appears for me on each new record.Thank You for your help!----------------------
I have a button that allows a user to open a report, and then if they want save as spreadsheet. Is there any way the button can download the report as a spreadsheet automatically? ie, skip the go the the report stage? Essentially, I want my users to be able to download a template, but this template isnt static. It may change periodically based on data in the system, so I can't simply upload a template file.Also, I want the user to get the template on demand, so I can't set it up as a subscription. Ideas?------------------------------Mike Tamoush------------------------------
I know it's not best practice to relate a table to itself, but there are some use cases. One interesting thing I found, wondering if anyone else has noticed this:I have a Related Field of course, which holds the 'Parent' Record ID.If I make a formula number field that is simply a mirror field. Just says [Related Field], it returns 0, no matter what is in the field. Meaning, I cannot use that related field in any way in formulas.It obviously has something to do with it being related to itself and getting confused. I have not found a work around. Has anyone else experienced this?Update: It is in fact finding the number but on the wrong record. ie, the child record will show the related field as a number, but the mirror field will show the number only on the parent....it's definitely confused...------------------------------Mike Tamoush------------------------------
I have created an exact form that pulls data from various tables relating to the parent record where the form is saved. Up till now this form has worked without any issues, but today I was made aware that the resulting report wasn't updating for a specific record. When looking at the parent record all the data that would appear on the form is visible in the different sections/tabs of the parent, there is no missing data. But when I run the exact form report the only content being displayed is the data fields specifically seen on the parent and the report section headers (as they are specifically coded in the exact form) but no child information is being displayed.Other records are displaying correctly so I'm at a loss as to how to begin to troubleshoot why this specific record isn't returning the correct information. Any filters used on the exact form are similar to those that filter the children records when they are displayed within the parent form. Agai
I am trying to create a clock in/out like a timesheet. I would like to create a button that adds the current date and time to the field.I have tried looking for this formula that is probably very straight forward but I can't seem to find it.------------------------------Cassie Hubble------------------------------
Hi,Is there a way to find blocks of "non-interrupted" dates if I have a table with multiple assignments?Below I paste the example. Each assignment has start and end date and person assigned. I would like to find blocks of dates when the assignment was not interrupted by other assignment for other person and create one row for each of this block (Column "Wanted" on the screenshot).------------------------------Piotr Kryszkiewicz------------------------------
Users are seeking fewest keystrokes to open a Project record from Dashboard. Background: Project Table has ~250 projects and ~40 Project Managers who use Dashboards extensively. We have "MY Projects" Tabs on their Dashboard which provides them a filtered list of projects assigned to them. Additionally they want a fewest strokes solution for them to enter the Project ID (for any project including projects not assigned to them) from the Dashboard and result takes them to the Project on the Main Form. Current solutions: Dashboard Button that opens a table report with "Ask User" filter for Project ID. This button properly filters to the right project and then user has to open the table record to launch the Main Form. Is there a way to "Ask User" for the Project ID and launch the record in Main Form directly? Although the Search Widget on the Dashboard appears nifty, we are not using this fea
I have a table to track work tickets. I want to be able to run a monthly summary report which shows the percentage of work tickets completed by type. Basically just [completed tickets]/[total tickets]. If I add a formula field into the table I can see an accurate percentage for each day, but if I run a monthly summary report the percentage is not accurate no matter how I tweak the different options.For example, lets say I have three types of tickets ... Landscape, Maintenance and Misc. Everyday there will be tickets opened and closed for each type. So for one day it might look like this:Type Opened Tickets Closed TicketsLandscape 22 &n
It appears when you edit a record, that the cursor is defaulted to the first manual entry field. Does anyone know if this default can be changed?I'd love it on a different field or even better, no field at all.------------------------------Mike Tamoush------------------------------
Hello, I need some help trying to create the right data entry structure for the report I would like to have. I have a specific list of names and every week each persons sales a quantity of items and revenue. The data entry section has multiple fields of other data within this table. I will have multiple people per week and want to assign the specific sales data to each person so I can aggregate those weekly reports. I'm not sure how to have the names on a drop down list and the have the next set of field data associated to the specific person on the weekly report. Thanks You Cameron ------------------------------Cameron Lee------------------------------
Hello! First post here, brand new to Quickbase. I've done web app development before, but it was PHP + database + HTML + CSS + Java Script stuff by hand many moons ago. I think I am looking for guidance, something like 'you need to read up on Quickbase Thingamajigs and how they relate to Quickbase Whatchamacallits', rather than a step-by-step set of instructions. If someone can point me in the right direction, I can do reading on my own time and figure it out. The graphic I have below is an Illustrator mockup of what my boss wants a form to look like, I drew this by hand:The bit at the top in Section 1 with the radio buttons and a table is what I'm interested in. The tabular rows thing is a screen grab from Excel. I want to create a table-like entry mechanism which allows the user to select a record using the radio buttons on the left side, and details of that record populate in Section 2. I would love it if that table-like entry mechanism could pull in all the records
Hi!A relationship has been built between two tables: Resource Assignments and Ongoing Activities.The Ongoing Activities table houses a list of the Ongoing Activities that is used in the Resource Assignment form. In the Resource Assignment form, the Ongoing Activities drop-down list displays the active Ongoing Activity choices.However, in a report that was built (Resource Grid Edit) in the Resource Assignment table, the Ongoing Activity column/drop-down list is showing both the active and retired Ongoing Activity choices. Is there a way to only show the active choices?Note: We chose to retire the ones we didn't need anymore as they were attached to previous Resource Assignment forms. I went into the Advanced Settings, and "Resource Name" is the default record picker, which if at all possible we would like to keep as is. Thank you!!------------------------------Clarice Dennison------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.