Solved

I'd like to show values from a field in a child table that is related to its parent table (Product Selections) as a multi select text field (formula). Here is the database topology: Products (contains product types) Product Selections (assignment of a product to a client record) Product Allocations (more specific product selection attributes related to Product Selections table records) Example record: Client: Acme Anvils Product Selection: Advertising Product Allocation: Google Search Network Product Allocation: Bing Search Network Product Allocation: Waze Advertising I'd ultimately like to display the list of Product Allocations in a Product Selection report, but as a single multi-select text field.Is this possible? Thank you!!!------------------------------Matt------------------------------

Hi everyone! I've just started playing with a connected Quickbooks table. I'm trying to find a way to have the records in the Books table automatically select a parent record in my Jobs table. Each Books record has a Job Number field that should associate it with the proper Job record (each Job record has a unique Job Number), but I can't figure out how to create an automation that tells the Books record to "select the job with the matching 'Job Number' as the related Job for this record". I've tried to have it automatically write the Job Number to the Related Job field, but it just inputs some numbers and doesn't select the correct job. Any ideas? Thank you in advance!- Elena​------------------------------Elena Larrabee------------------------------

Hey all, I wanted to know if anybody knows how to add an if statement to a URL formula with javascript? Currently my formula looks like this: var text url=URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&_fid_30=Sent&_fid_29=Sent&apptoken=XXXXX&rid=" & [Record ID#];var text ifStatement=If([Submitted for Payroll Log] != "Sent" and [Commission for Homeowner] != 0, $url, " "); "javascript:" &"$.get('" & $url &"',function(){" &"location.reload(true);" &"});" & "void(0);"Everything is working great except for the button is showing up still when the parameters: [Submitted for Payroll Log] != "Sent" and [Commission for Homeowner] != 0 are met when it shouldn't be.------------------------------Amanda------------------------------

Hello everyone!I am developing a Quick Base app for Real Estate and I am stuck here:When a [Client] wants to rent an [Apartment], they must send me an [Application].The [Application] contains a lot of information that will already be on Quick Base, such as the [Client] name and number, as well as the [Apartment] address.However, to complete the [Application], I need each [Client] to submit additional information, such as:- Annual Income- Social Security NumberAs well as upload a few PDFs:- Bank Statements- W2What is the best way to collect this data so it's plugged into my tables on Quick Base?Thank you kindly!Rez------------------------------Rez Cury------------------------------

Is there a way to add a button that will edit a record with "pre-planned" data?  Looking for a quick approval system for an app I created for employee overtime requests.  This button would be only accessible to the app admin(s) and would generally set a Text multi select field to "yes", User List to the approver, and add a brief description of "Approved" to a multi-line text field.  Any help is appreciated.------------------------------Joshua Case------------------------------

Hi All,Probably I missing something from Quick Base documentation. Could anyone please explain technical limitation different between Application Manager and Administrator?. One thing that I encounter when using Quick Base is the ability to create and manage multiple homepages for each user.Kind regards,Syaeful Bahri------------------------------Syaeful Bahri------------------------------

Is it possible to have dynamic form rules affect an embedded report?Meaning, I have a form with an embedded report in grid edit.I would like to only show certain fields of that embedded report when adding/editing and other fields when only viewing.I know how to do it for the actual form and directly related fields, but it didn't seem possible to do it to the embedded report.Thoughts?------------------------------Andrewandrew.fry25@gmail.com------------------------------

Hi All,Have anyone implement touch input field to write signature?.  User can write down their signature using digital pen in a field and mark it as attachment.Many thanks------------------------------Syaeful Bahri------------------------------

Take for instance you have three hotels each in a different country and all have different rates which change by season. High season is from Nov 14 to April 14 and low season is from April 15 to Nov 15 every year.For example: Is it possible to automatically populate the seasonal rate ((high or low) based on the current date? If yes, how?------------------------------Ijnanya Isaac------------------------------

Hi All,just playing with formula duration to count the duration of the event. Unfortunately its show 0 (zero) duration for one day event. Following formula date duration [End date] - [Start date] if the event have same start date and end date which is one day event is show 0 (day) duration.It's possible for this case to count one day event as 1 day duration?Many thanks------------------------------Syaeful Bahri------------------------------

Hi All,I have two fields participants name and participants category. I need to count total of the participant but to exclude one of the participant categories, for example teacher category.The table is as shown belowParticipants name | Participants categoryDavid                         | TeacherNadia                         | StudentSam                            | ScholarRather than count total of 3 participants, because its excluded teacher category, the result will show total 2 participants.Can you please explain to me available formula for this case?Many Thanks------------------------------Syaeful Bahri------------------------------

Hi All,I have a field duration. If the workshop duration is more than 1 day, it's possible to create field automatically based on input of  field duration.For example, duration is 2 (days), it will create new 2 field  - day 1 and day 2. If duration is 3 (days), it will create new 3 field - day 1, day 2, day 3 and so on. The field will contain checklist - attend or not attend to track workshop attendance for each day.Many thanks------------------------------Syaeful Bahri------------------------------

Hi all,For example users have credit  $10000 for every month. They can use and spend it every month for their activity.There is table that record their spending each month like thisSpending Activity | Quantity | PriceNew computer                1          $2500Its possible to achieve something like thisSpending Activity | Quantity | PriceNew computer                1          $2500-----------------------------Total Spending                             $2500Balance                                           $7500Many thanks------------------------------Syaeful Bahri------------------------------

HeloI have preparing a Bar Chart and have a series for Project A, B, C, D & EWith this bar chart, I am summarizing the 3 Sum Values01 Initial Cost02 Current Cost03 Forecast End CostSo I am expecting a bar chart that have 5 sets of 3 bar values starting from Project A from the left and ends with Project E on the right. However, I get a sequence of Project A, C, D, E & BI have tried various ways to change the sort order but can't seem to find a solution. Appreciate some help. Thanks------------------------------Nigel Ho------------------------------

Hello QB CommunityI am trying to build a formula combining more than one variable Variables:First Name Middle Name Last NamePreferred First Name Preferred Middle Name Preferred Last Name I want to show the Prefered Names when student have one otherwise the Legal name------------------------------Data (Administrator)------------------------------

Hello,I have one app that i am unable to see a way to test a user or a role but I am able to see it in all my other apps.  How did I break it?  and more importantly, how do I fix it?I am the admin for the app.------------------------------Blanca Anderson------------------------------

I have 3 tables: Assessment, Locations and Workstations. Assessment connects to one or many Locations; A location has many workstations.I would like to display the grandchild (workstation table) records in the Assessment form? Is this possible without making a relationship between assessment and workstation table?I am afraid that making a triangle relationship may result in mismatched data (if workstations are moved from one location to another). Please advise. Thanks.------------------------------Uma Harithsa------------------------------

I have a field formula - text.I am trying to write a formula to check and see if all Assignments have a Date Scheduled and a calendar time.If they do, then I need the Text in the field to be a "YES" otherwise a "NO"The number of assignments can vary, but regardless of the number of assignments, I need to ensure that all assignments have a scheduled date and a calendar time.I have to incorporate this part of the formula into a bigger formula that I am working out, but I am stuck on this portion of it because of the fact that there could be 1 assignment or there could be many assignments and I am not too well versed yet in determining how to go about catching all assignments. Based upon the above, the results in the field would be "NO", because there is no Calendar Time for Test, Jeff, or Date Scheduled for Test, Sarah.Both Date Scheduled and Calendar Time need to be filled in for every assignment in order to populate "YES". Any pointers, thoughts, ideas, etc that any of you can provide

Hi All,I have a contract start date and contract end date field. It's possible to create if statement for status field like this belowIf date is more than 30 days before contract end date, contract status field is activeif date is 30 days before contract end date, contract status field is will expiredif date is equal contract end date, contract status field is expired?How can I achieve this?, Can you please give me step by step direction for this?Many thanks------------------------------Syaeful Bahri------------------------------

Hi All,I'm creating a timeline report to track the process of recruitment from advertisement until contracted. Below is the result It's possible to show how many days is needed from start to end? in my case is from referee checking date until contracted date. For example, 30 days needed for the process, etc.Many thanks------------------------------Syaeful Bahri------------------------------

So I have a User field in a table that I'm directly inserting into an exact form, but regardless of how I have the User displaying in QB, I can only get the username to display on the form. Is there a code snippet to change the format of the User in the exact form or should I just try making a new field?Thanks,------------------------------Benjamin Golden------------------------------

I have HTML Text on my form, and I want to have it show only if certain conditions are met (checkbox is checked). Since its not a field on my table, rather just an HTML text on my form- in dynamic form rules this field (field 0) isnt listed as an option to do anything with. Is there a better way to do this?  What this field i'm trying to hide is, is an image coming from our website.------------------------------Mike Klausing------------------------------

Hi, I have 3 graph reports with the same set of Dynamic filters. I use these filters to compare the Customers by their amount of Purchase.I want all these 3 reports in the Dashboard.The problem is, these reports while placed in the dashboard doesn't show Dynamic Filters. I require this dynamic filters to compare.Is there any way to show this dynamic filters along with their graphs in the Dashboard?Thanks------------------------------Vivek Vishwanath------------------------------

Does anyone know how to display radio buttons horizontally?

I am wanting to create a button that will redirect the user to another table within the same application, to a specific form within that table and the related record. I am aware you can do this using the key field in the table. However, the key field in the two tables I'm working with are not the same. (One is a project ID# and the other is a QB generated Record ID#)Can I utilize another field in the starting table that relates to the key field in the end point table? If so, how does that look in a formula. I've tried it all and am starting to lose hope.Thanks in advance!