Recent Discussions
Need assistance getting image to show when printing a record
Created a form that has a file upload section. This section allows people to submit photos of themselves. This is used for Medical purposes, we need to print out records to include the uploaded image. Initially this worked as intended by displaying the picture when printing. Once this was officially put in production, it stopped displaying the image as intended. the test record: Print preview: The print preview used to show the uploaded image on the record but now its just the file name.0likes4CommentsCan subscription reports be sent to multiple recipients in same message
I'm finding that when I select a group of users to receive a report subscription, the email is sent separately to each recipient. This is not terribly useful for management reports. I would like the group of recipients to be included on the message together, so that users can "reply-all" and discuss, ask questions of the data in the report. Is there a way to accomplish this in subscription settings? Thanks, Mike0likes1CommentConvert "Report" to "Chart Report"
Apologies if this has been covered elsewhere, couldn't find any help articles or posts that covered this via search. I have reports I've built with filters (that take a while to click and set). Looking for ways to take an existing report, copy the settings, but select another type of report or another type of chart without having to reprogram all of the filters and report settings from scratch each time. Can I: Take an existing Report and convert it into a Chart Report? Take an existing Report and convert it into another type of report? Take an existing Chart Report and convert it into another type of Chart Report? Thanks, Mike0likes4CommentsConsolidate Field Types
Hello, Is it possible to consolidate several Text - Multiple Choice field types into 1 field for a report? I believe I would have to create a new field and a text-formula as well. My working theory is below: [Scope 1 Manufacturer] and [Scope 2 Manufacturer] and [Scope 3 Manufacturer] and [Scope 4 Manufacturer] ="Company A" We have over 100+ customers, so creating 100 field types for each customer seems to be ineffective option. Thanks! I appreciate this community's help.0likes9CommentsPipeline Not Triggering
Thanks to those of you who have helped me get this project manager up and running! I'm encountering I think the last issue related to this specific workflow I'm trying to tackle. When marking off a task on project 5, I want it to create a task on project 8. This is currently how I have it set up, but changing the task in project 5 to complete does not trigger the pipeline to start.Solved0likes4CommentsPrevent save a record - New forms
Hi, I was wondering if anyone can figure out how to avoid saving a record with duplicate attachments. The scenario is as follows: I have created a new version form and added three fields attach type. These are mandatory. In legacy forms, this works partially because as I only validate that the name is not identical between the attach type fields. But quickbase has no validation at the level of the attachment field content level. Thinking outside of the box I have implemented the following dynamic formula to avoid saving, when these attachments are duplicates. But when I implement this dynamic rule in the new version of the form. it doesn't work.Solved0likes8CommentsHow do I save a form and continue to another form, importing the newly created RECORDID?
Hi all, I've been trying to sort this out for too long. I have a form (Form A) with a URL link to another form (Form B) for the same Table. When you click the link it should save the form, create the RECORD ID and use that RID to go to Form B. For some reason the "%%rid%%" functionality isn't working for this. Here is the formula I am using: var text recordid = "%%rid%%"; URLRoot() & "db/*********=er&dfid=24&rid=" & $recordid & "&z=" & Rurl() & "&ifv=1" It says: "DRS Record not found". When I look at the URL that it directed me to it still has "%%rid"" in the actual URL instead of the new Record ID. I have tested this url by hard coding in the next RECORD ID that will be created and the URL link works. I just need the new RECORD ID to be in the formula - URL and it's all golden.0likes1CommentHow do I run a Table to Table Import?
Hi all. I have a webhook for Table A, and I want it to run a Table to Table Import into Table B whenever records are added to Table A. Here are the details of the webhook: Enpoint URL - https://amzl.quickbase.com/db/*********?a=api_runimport Body - <qdbapi> <usertoken>%user.token.************%</usertoken> <id>12</id> </qdbapi> I'm still new to QuickBase so I'm never 100% sure with what I'm doing but I'm guessing the "12" is referring to the ID of the import.0likes1CommentPreventing Scheduling Conflicts
I'm helping develop an app to track and reserve company vehicles. One of the requirements given to me was to prevent scheduling conflicts for the vehicles - essentially not allowing any overlaps for a given vehicle. I have searched this before and I found some answers on these forums that helped point me in the right direction but I'm still coming up short. What I've done is pair two formula queries into a field that would check for start and end time overlaps and add the queries together. The field is simply called Conflicts and if it is over 0, I know there is a conflict. My issue is two-fold. The first formula I used and works (sort of, we'll get to that) is Size(GetRecords("{7.OAF.'"&[Start]&"'} AND {7.OBF.'"&[End]&"'} AND {10.CT.'"&[Vehicle - Vin Last Four]&"'}",[_DBID_RESERVATIONS])) + Size(GetRecords("{6.OAF.'"&[Start]&"'} AND {6.OBF.'"&[End]&"'} AND {10.CT.'"&[Vehicle - Vin Last Four]&"'}",[_DBID_RESERVATIONS])) First things first is that this means each record will presumably 'find itself' so the result will always be at least 2. This is mitigated by simply adding '- 2' to the end to account for that. The trouble is that if you create a new record, it's the pre-existing records that count the conflict, not the new one, which is useless if I'm trying to use a form rule to prevent a new record from conflicting with others. Swapping the OAFs and OBFs seems to work logically but doesn't deliver the expected results. So that's my first sticking point is that I can't seem to get the logic in this formula correct. I just need to check to see if the starting or ending time falls between the start and end times of other records using the same vehicle. My second issue is that even testing this with NOT accounting for a default result of 2, I can't get the form rules to stop a save if the conflict is > 0. Which does make sense to me since it can't count the records before it exists, but I'm not sure how else to notify someone that the record they are trying to create has a conflict. The form rule does work if I reopen the record but that doesn't help during creation. Does anyone have any ideas on how to get this working? Many thanks in advance!Solved0likes2CommentsPipeline shows 0 records found?
Made a scheduled pipeline to look at a "formula - duration" field on Table A (Calendar) that signifies how many days until an event there are. If it is between 0-75 days, it should create a new record on Table B (Project Manager). For some reason, however, its just returning 0 records, and going through as successful. Even though I have a record where the column is 5 days away. I will continue to work on this, but I didn't know if anyone might have some ideas why it is not seeing this record on Table A and making a new one on Table B?0likes8Comments