MikeRedfearn
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Have a action trigger run without open/edit/save of a record
Hello - The notification email filters within Quickbase require that a record is modified in order to send a notification. I am attempting to create a action/trigger that creates some sort of change on a job record without opening, editing, or saving a job record. It can be any action field...even a simple checkbox. That action would then trigger a notification email to be sent to a list of our clients. To summarize; We have clients who we are scheduled in a calendar. And on the clients job record is the date/time we will be arriving as well as all the information relevant to the job such as contact info and scope of work to be done. I am attempting to create a trigger field on the job record that when fired would create the change on the record that qbase notification filters require, to then send a notification email to be sent to the client reminding them of their upcoming appointment. I attempted to create a formula-checkbox but it still only seems to fire when the job is modified/saved. Formula currently using = If ([Status] = "Scheduled - Unconfirmed" and Now() + Days(2) > ([Job Start Date/Time]) , true) From my reading it sounds like this can be a tough task but I know its possible. Currently within our qbase app we have a status field that is able to change without a job record being opened/saved. The only problem is we had our app custom built by a firm and I am hoping to learn these sorts of small changes myself. Thank you for your help in advance! ------------------------------ -Mike Redfearn ------------------------------Create a new field that takes the number from another field, then divide to calculate hours.
Hello - I am trying to create a new field that tells me the total number of hours that a job will take. We already have a numeric field that calculates the total number of minutes required to do a job, which pulls that data internally from another relationship. But I would like to create a new field that takes those number of minutes from the other field, and then divides it by 60 (60 minutes in a hour), to then give me the total number of hours it will take to complete a job. Can you advise which field type and the formula to do something like that? Thank you in advance! ------------------------------ Mike Redfearn ------------------------------Re: user name not spelled correctly
And how would a "admin" do that? I am an admin but cannot change the name of a user. Her name is grayed out in the admin console and that seems to be the only place I could possible change her name. ------------------------------ Mike Redfearn ------------------------------Quickbase extremely slow and some features will not load at all
Quickbase currently very slow and some features of our app are not loading at all. I cant find a a place to report Quickbase issues so reaching out here. Quickbase status page only shows downgraded performance for Quickbase community which for me, seems to working perfectly, while Quickbase itself is not. Anyone else experience issues and know of a place to report these performance issues? Thanks for your help.Colorize a number in a column/row in a summary report
Hi There, I have a summary report that displays 3 columns; months, dollar amount scheduled or completed, and our dollar amount goals. The rows are broken down by each month of the year. I would like the "amount" number for each specific month to be colored red or green. The "amount" number for each month should be Red IF the amount number is less than the number in the Goal column for that month. The "amount" number should be Green IF the amount number is greater than the number in the the Goal column for the specific month. Is this possible to do with the new report formulas feature? Thank you for your help. I've attached a picture for your reference.
