Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I was wondering if anyone knows a work around to the limit of the number of form rules you can have on the new form? We have a form that currently has 140 form rules. I am trying to move it over to the new form and it stopped me at 100 and said rule limit has been reached. ------------------------------Amber Goodman------------------------------
I have not been able to find a solution on how to extract the last entry from an appended field when new entries are displayed at the top. I do want the date and name of the person who created the entry included. One solution did display the most recent note, but didn't include the date/person who created it. Trim(Left(NotLeft([Fulfillment Notes],"]"),"[")) How would I adjust this formula to include the date and person name?------------------------------Amy Gosz------------------------------
Hello everyone! I'm hoping that someone can offer me some guidance on how to accomplish my objective. What I'm attempting to do is filter out records available in a Reference Field after they've been associated with records in a second table. I have two tables. 1 – Computers Table The Computers Table currently includes the text fields Model, Hardware # and In Use which can be set to either Yes or No. There are three entries currently. The Model is set to Latitude 1234 in each case. The Hardware # is unique (100, 200, and 300). In Use is set to No. 2 – Employees Table There is only one field currently, the Text field Employee. I have created a table-to-table relationship where Computers is the Parent Table and Employees is the child Table. As a result of creating this relationship the Computers – Model field has been added to the Employees Table/Form, which would be correct. My objective is once I associate Latitude 1234 with Hardware # 100 with an Employee, I do
Hey everyone, I am trying to embed an image in an attachment field from a parent record in the the form of a child with a rich text field formula. I have created a URL field of the attachment in the parent table (Picture URL) and added it as lookup in the child (Product - Picture URL). Embedding the image works, however I need it more as a thumbnail and not full res so I added a height parameter but it does not work for some reason, the picture appears full size. "<img src=" & [Product - Picture URL] & "height=50>" Any help with this will be greatly appreciated. Regards, Yordan
I can't see the forest for the trees on this one, Anyway, we have a requirement to strictly maintain timecards on a weekly basis for several reasons, however, compliance is the crux of all timecard requirements. Each timecard (parent table) is created by the user, also the timecard owner. Once created, they manage charge codes (child table). I can discern the number of missing timecards for the current year through Today() with a basic formula (# required timecards) - (# initiated or completed) = missing timecards. I want my weekly routine in pipelines to create missing week-ending timecards against each employee. I have 70 plus pipelines, so I'm sure I can build the brunt of the requirement, but I cannot figure out how to squeeze out the missing week-ending dates for each missing timecard for the current year through today. ------------------------------Thank you so much,Chuck------------------------------
I created a form by mistake. I do not know how to delete it. Can you please help me?------------------------------Rocio Carrion Rabanal------------------------------
I'd like to track changes made to a record in my `Clients` table by writing the before and after values to a `Change History` table. For instance, if I updated the "Name", "Phone Number" and "Email" field in the `Clients` table , the Pipeline would create a new record for each field updated, showing the old/new values for that field, when it was updated, etc. The Change History records would contain the following fields: `Field Name` `Old Value` `New Value` Is there any way to do this in Pipelines? ------------------------------Matt Makris------------------------------
Hi Everyone! Drop a note below and tell us where you live in Australia or New Zealand! I personally have travelled to Melbourne and absolutely loved it! ------------------------------Ben Simon bsimon@quickbase.comDo you have Feedback on how to make Qrew Discussions a better experience? Let's chat!https://calendly.com/bsimon-2------------------------------
Hello, I have a legacy form that a relatively simple condition that I am having trouble replicating Using the New Form. Legacy Form: User selects a Related Record to start the form. When they change the Related Record from <blank> to a value, a File Attachment field becomes Required due to a dynamic form rule. This has prevented the record from being saved without a File Attachment. New Form:User selects a Related Record, and the File Attachment field becomes required (Dynamic Form Rule) - but this does NOT prevent saving. I do see the ability to add an action to Prevent Save when the condition is true, but it doesn't revert to Allow Save when the condition is false.What am I missing? Do I need multiple rules to make this work? ------------------------------Troy MacPherson------------------------------
I need help to accomplish the redirect to the Exact Forms doc generation. Here is what I tried but not correct: URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=cav92prc9it7rfdfbvc32xuy2vj" & "&_fid_172=1" & "&rdr=&URLencode("https://www.aws-juiced-client2.com/Juiced/ExactFormsPlus10/doc_merge_ua.aspx?"& "request="& Base64Encode("clientid=Q2683"& "&appid=" & AppID()& "&tpdbid=" & [_DBID_DOCUMENT_TEMPLATES]& "&tpid=2"& "&fn=BoM Purchase Order"& "&msid=" & URLEncode ([Record ID#])& "&msdb=" & Dbid()& "&faid=58&efpdte=59"& "&docfmt=doc&stream=y"& "&apptoken="))------------------------------George Bramhall------------------------------
I used the code sample from this QB resource site link to create a custom formula rich text field that allows me to place multiple "save and keep working" buttons throughout my form. Works like a charm as an admin but for a more restricted user role it has consistently weird behavior. For this other role it works fine when I'm adding a new record but when I'm editing a record, it doesn't work for file attachment fields only. ie, any other regular field works fine and file attachment fields work fine when I'm adding just not editing. Even stranger, the standard built-in save and keep working drop down in the green button at the bottom of the form works fine in both edit and add modes for this role. Only in edit mode for this role does this behavior occur and it occurs consistently. For a minute it seemed to work okay in Chrome but not MS edge but now it exhibits this odd behavior for any browser. It also works fine as an admin for any browser.&n
Hi, I have a complex set of Quickbase Actions that does just what I want it to do... doing one thing in the Quickbase app sets of a cascade of actions all over the place that loop until everything is sorted out. Is there a limit to how many follow-on actions I can trigger based off an initial trigger? ------------------------------Matt Stephens------------------------------
I am trying to simplify some of my more lengthy pipelines by breaking them up into logical sections and then calling each one separately. Basically: Parent Pipeline call pipeline 1 call pipeline 2 call pipeline 3 They need to run sequentially. However, I just did my first run and based on the view windows for the pipelines involved, it appears they run in parallel. As soon as the parent pipeline kicks off pipeline 1, it immediately kicks of pipeline 2, and then pipeline 3, without waiting for the previous pipeline to finish. I could not find any documentation or previous posts on how these callable pipelines run so was wondering if anybody else could shed some light on this. Thanks....Aaron------------------------------Aaron Bab1692@att.com------------------------------
Hello Everyone I am trying to get bulk data from quickbooks online to quickbase. My process is: 1.Prepare record upsert 2.Search QBO Table (Bills) ---- For Each ---- ---- Add a bulk upsert raw 3. Commit upsert I am getting following errors. Remote service reported an error: {u'Fault': {u'type': u'ValidationFault', u'Error': [{u'Message': u'Unsupported Operation', u'code': u'500', u'Detail': u'Operation Could not find resource for relative : /v3/company/9130356249818236/expense_account/470 of full path: https://c45.qbo.intuit.com/qbo45/v3/company/9130356249818236/expense_account/470?minorversion=65 is not supported.'}]}, u'time': u'2023-08-17T08:00:46.141-07:00'} -------------------------- So My question are: Am I doing the right process? If not, How can I do it? Any resource link related to this will be helpful. Thank You. ------------------------------Syed Ahsan Sirat------------------------------
Old dog learning new tricks here. Long time .NET guy transitioning to QB... I have a form that needs to have (on edit and add): An initial selection in the first field Several fields auto-populate based on the first field A subset of the auto-populated fields need to be editable. This needs to happen when the initial selection field is changed Example scenario: I have used lookup fields and form values to attempt to accomplish this. I can accomplish #1 and #2, but #3 does not work. Either the auto-populated values change with the selection of the initial value but cannot be updated (they revert to the original value), or the form rules allow for auto-populating the values and editing, but this can only happen once. If the user changes the initial value for a second time, the first selection auto-populated values remain. Also, I know there are probably ways to do this by bouncing between several pages, but we are re-working an existing app and the d
I have setup a conditional dropdown with two fields and would like to turn off the ability to create new dropdown options for a particular role. Currently at the bottom of the dropdown list it shows the option to create a new option. Thanks------------------------------Brian Dunk------------------------------
Hi, In one of our application, we have public forms and save the records we have a "SAVE" button (URL FIELD) and using the code as mentioned below."javascript: \"saveBtn.click();\n EvCancelAll(ev);\" Now we want copy the same code in another table, we are getting error that JavaScript is disabled in fields. Could anyone help us in resolving this issue?------------------------------Ravi Siddana------------------------------
Hi Team So I posted yesterday regarding sending an email with attachments from QB via the Pipeline Outlook Channel. Now it worked yesterday but when I tested this morning it is no longer working and throwing up the error - Remote service reported an error: HTTP status code 404 for URL The image below is the pipeline for Attachments* (list) I also tried running the Pipeline without an attachment and it threw up the error - Validation Error: Please provide a valid source url(s). Does this mean I have to create separate pipelines? One for attachments and one without? Thank you in advance for any responses regarding this post.------------------------------Jessica Matenga------------------------------
I have a Quickbase Table for tracking monthly survey completion status across multiple people/records. Lets say I have 5 records, Each record is named from 001 to 005 instead of the person's name. Within each record, there are fields to track 1-month survey status, 2-month survey status, 3-month survey status, etc. When a survey is completed, I upload it to Sharepoint. Each file name follows the same structure: "001_1M_Survey_05.20.2023.pdf" i.e. (ID_Month_File_Date). I am trying to create a Pipeline that automatically updates the respective record status to Complete in real-time once I upload the file. If I upload 002's 3-month survey on 08/01/2023, I need the Quickbase record for 002, the field 3-month survey status to automatically update to Complete. So far, I have tried splitting the file name using a delimiter, separating the file name into 3 variables: ID, month, and date. Once the file name is split into 3 variables, I could fill the correct Record respectively.--------
I'm creating a pipeline that is triggered by the creation of a record and modifies existing records. Every time I run it, I get the following error: "Quickbase reported an error: 34 : You cannot change the value of this field : The field named "[field name]" with field id 64 cannot be modified" The field is a date field. I've tried putting the date in using a jinja template and using the date picker in the pipeline. This is a field I modify manually all the time. I'm using an application token created from my account, which has full edit access to the app. What can I do?------------------------------Christopher Knieste------------------------------
There's a lightbulb icon in the lower right corner of the screen called "feature help" that's on top of the tabs for my dashboard. Can i somehow remove that button? ------------------------------Thanks,Chris Newsome------------------------------
Hi! Is there a way to copy certain info from one column to another? It would be tied to a date. For example, we have an Updates column that can get really long over time and we would like a way to where the latest update is copied into a new column to create a report for review purposes, so we don't have a report 50 pages long and we also want to avoid data entry twice. We want the new column to be un-editable so people can't add updates to the wrong column. It seems like it would be a simple formula to bring over the latest dated update to a new column but it's been hard to figure out. Is there a way to do this? Thanks!------------------------------Trisha Dixon------------------------------
Has anyone figured out how to show/hide a report element on the new forms, via form rules? On legacy forms, this can be accomplished by showing/hiding the report link field--but I don't see an equivalent functionality for new forms. It feels like there should be a "Reports" option here, perhaps? ------------------------------Dan Ladner------------------------------
In the old forms, for a file attachment field, you could add numerous new revisions. You could then see all of the old revisions and even revert back to an older version. The new form builder seems to only allow one document per file attachment field (despite the field settings allowing us to 'Keep all revisions' or 'Keep the last X revisions') . Am I missing something? ------------------------------Jessica Feauto------------------------------
I understand what I want to do, and some of what I need to do - I just can't seem to implement it. We have many tables. We have 2 tables in particular that already have a relationship called Water Systems and Samples. Water Samples are input and assigned to water systems. We get a notification whenever a sample fails - which is great. However, when a sample fails, we're required to take another sample some weeks/months later. We would like to be notified when a sample comes back passing again once a sample has already failed. So, take sample>failed>take another sample>passed after recognized failure>send notification. Ideas? ------------------------------Savi Newman------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.