email notification error
Simple user here. Not an expert or well versed in Quickbase, but it's what my office has used in the past so I inherited it. I recently updated the language in an email notification (triggered by a checkbox). The email sends, but is still using the old language, even though when I go check the notification itself in settings, it shows the new language. I have no idea why it won't send the updated custom message. any help is greatly appreciated.Can I setup a reminder email to remind me on the date, instead of x days before or after?
I have a reminder email notification setup, based on the date in a field called "Remind Me On." This is a date field where the user can specify a date in which he or she wants to be reminded of the task. We chose this path rather than standardizing reminders to be sent X days prior to the due date. This way, if someone wants to be reminded a week before or a day before, they can customize their remind date. In the reminder email template, I have the option to select to be reminded X days before the "Remind Me On" date, or X days after. I attempted to insert a 0 value in that field, and selected "before," hoping that I would get a reminder on the date specified in the field. I did not. The only other solution I can think of is to create a formula field that takes the Remind Me On date and adds 1 day. Then setup the reminder email to send 1 day before that formula date - which would end up being my Remind Me On date. Are there any better solutions? Thank you Sherri
How can we email a custom dashboard page as a subscription?
I've found that sometimes users prefer dashboards to multiple emailed reports. How can I email the users a dashboard pageI have created that includes a couple of summary reports, a chart as well asone full reportin an email subscription? Is this possible with native QB? If yes, where is the setting option? I'm only seeing a report drop down in subscriptions. I'm not seeing a similar option to select a page . Thanks in advance for any direction/suggestions.Triggering Emails Based on Field Status
Hello, I am trying to automate an email either by email notifications or a Pipeline based on updating a related field. I have 3 tables: 1. All Flights - Enter any new flight in the schedule - I have a field called "flight verification" that is a multiple choice field allowing to show the flight as "pending" or "final.") - I have another multiple choice field for "Flight Status" with options "Active" or "Flown" 2. Current Flights - Connected to "All Flights" and pulls only "Active" flights 3. Request Log - Where passenger requesting a seat are entered - I have a related field from "Current Flights" so there is a drop down menu that only allows you to select "Active" flights - There is also a related field for the "Flight Verification" I would like to trigger an email that sends the list of passengers entered in the "Request Log" when "Flight Verification" status is changed to "Final." Since this is a related field, this field changes when the "All Flights" table is updated and the subsequent tables are refreshed. Is this possible? I don't think the email notification will work since the field in the "Request Log" table isn't being updated and saved. Is it possible to utilize pipelines? If so, how do I do this to include a table of passenger information from the request log? Thank you!Subscription Email Contact
Hello, I'm building an app for another department, which will have some information be sent externally. The subscription emails have on the very bottom. "This is an automated email from a Quickbase application. If you feel that you received this email in error, please contact the application's manager, xxx@xxx.com." Right now, my email address is listed there since I built the application. Is there a way to remove my email address from that? Since I won't be the user of the app, I don't want these external people having my contact. Is there a way to have the subscription email without any contact there? If we can't issue a license to a general email distribution address, then I have a feeling any individual would feel the same as I would. Thank you. ------------------------------ V W ------------------------------Invoice Routing
Tried a few searches but not quite sure how to describe my desire in just a few words. What I'd like to find out if it is possible would be to build an application for the tracking and routing of invoices. I know I can build tables and pipelines to functionally achieve this but the part I'm not sure how to do is to design the app so that when a user receives an email, indicating they have an invoice to review, to build in the ability for them to indicate somehow in that email their response. We are currently using a SharePoint Power Automate workflow but it seems to run into issues and I am the only one that knows how to investigate and fix those flows. The email provides basic information in the body, includes the original invoice as an attachment and then gives them the option to Approve or Reject from right in the email. For the majority of our invoice approvers they never actually visit our SP site, their interactions are solely through the approval emails they receive. Once they've selected their response the flow continues on to create an "approval page" and then merges that page with the original invoice. Post merge it is forwarded to a specific accountant for payment. I've been trying to migrate our solutions to various QuickBase apps as it has proven easier for non-technical persons to use and manage. Just wondering if a similar set up could be built in QB so that users wouldn't have to log into QB to respond to invoice approval requests. Thanks ------------------------------ Ember ------------------------------
Enforcing Uniqueness on a Formula Field
I have created a formula field on my Project Status record to concatenate Project record id (totext version of it) and a date field on the project status record (child of project). I would like to make this unique so the system would prevent the user from creating multiple statuses on the same date for a project. When I try to enforce uniqueness on this field I get the following error message: Here is the formula: ToText([Project - Record ID#]) & Mid(ToText([Status Week Of]),7,4) & Mid(ToText([Status Week Of]),1,2) & Mid(ToText([Status Week Of]),4,2) Here is the error message when I try to enforce uniqueness: ?This formula is incompatible with this field being marked unique. Please change the formula or uncheck the unique checkbox.? How can we meet the requirement underlined above? Let me know if you need further clarity.BCC in email notifications
Hi, I am trying to find a way to send email notifications to clients with a BCC. I was told directly by Quickbase that this was possible, as long as the BCC was pre-set, but I cannot see any way to add a BCC. I know I can send to multiple email addresses, but we need it to BCC to an internal unmanned email for our internal mail server to pick the email up, read who it was sent to and then link it to that client on other software we use. Many thanks in advance. ------------------------------ Joe Alderson ------------------------------
