Recent Content
Duration between record creations
I have a project log table that tracks each status change for a related project. How do I calculate the duration of time in each status? Essentially the difference (in days) between each record Start Date. I'm thinking this can be done in a report formula field19Views0likes1CommentRemoving Blank Input Type
Hi, I am new to Quickbase, I have a table with multiple columns in it and there is a location column that I am using. In the Location column I want to show only 3 values. When I try to add the 3 items, the system auto creates a blank option too. I don't want that option, I am trying to turn that off. Any ideas on how to do that? The field properties are Text - Multiple Choice.22Views0likes5CommentsShare your Empower Photos with the Qrew!
Who here is having fun at Empower in New Orleans? We would love to see your photos or videos. Reply and add your pictures for everyone to see on the Community. Here's a few from our Day 1 and 2 keynote sessions: & Analytics at Albertsons, sharing how Albertsons were able to leverage Quickbase for future -planning and execution of real estate life cycle management.94Views2likes2Commentssyntax help with formula
I am making a formula and I am having trouble with syntax I want the statement to say If([Sale]="Yes", than show [Manifest Price] but if ([sale]="cancelled" show 0.00) I need the syntax for "than show" "and but if" Edit I got some of that formula to work If([Sale]="yes",[Manifest price w/o iva],([Sale]="Cancel"),(0)) all it give me is the Cancel ones at 0 The manifest price one is blank Edit - Solved by AI Chatgpt If(Trim([Sale])="Yes",[Manifest price w/o iva],Trim([Sale])="Cancel",0,0)//Default value if[Sale]is neither "yes"nor "cancel"Solved42Views0likes6CommentsEmbed hyperlink in Formula Rich Text field
Hi, I have a rich text formula field with an IF function to display specific text when a criteria is met. I want to add a link to a file in between the text output that opens on a different window. I need the display text to show as a hyperlink. Example: If ([Platform] = "A", "Complete all tasks assigned for 'Priority Sites' once every 2 months", "No action necessary for this year") Where 'Priority Sites' is the display text for the SharePoint web link https://sharepoint/prioritysites.pdf From what I could find online, I guess I have to create a hyperlink field to store the web address but I'm not too sure how that works. Can someone provide a step by step guide on how to achieve the desired output?Solved17Views0likes4CommentsPop up window from table home to preview record
Wondering if there is a way to create a button or link on each record so that when viewing from a table home report would open a smaller pop up window that would display some of the records details? Would also like to then have that window pop up have a button which could be clicked to view the full record. Would be nice to not have to display so many columns on a table home report, instead the preview pop up could hold 3-5 data fields with the option to open the full record.42Views0likes7CommentsOngoing Schedual Calendar
Hello Everyone, Our food rescue picks up food from different stores in our city. We then partner with distribution sites that pick up food from us on specific days each week or month. Most of our sites are weekly; for example, they pick up every Tuesday. In other cases, the sites pick up on the fourth Thursday of the month. Is there a way to build or create a calendar where I can enter this data, and it generates all the sites and what day they would come to our location to pick up food? Currently, we have a table for each site with the day they would pick up and other additional information. I have attached an example of the calendar that we created in Excel. Thank you.5Views0likes0CommentsPipelines Variables
I get that we can use a Pipelines for each loop based on a record found, but is there a way yet to add a variable as a counter to run the loop based on the variable instead of the '1' record count? I'm trying to search the record, capture the qty ordered and run the loop that many times to create that number of records in another table. I also really want to avoid having to create a code page to do this and make a bunch of API calls. Thanks! ------------------------------ AR ------------------------------75Views2likes1CommentHow to send field values to a Mailgun template in Pipelines
In my Pipeline, when a record is created, it tells Mailgun to send an email using a specific template within Mailgun. How can I pass Quickbase field values to the Mailgun template? There doesn't appear to be an obvious solution from looking at the interface (see screenshot). ------------------------------ Matt Makris ------------------------------18Views0likes2Comments