ContributionsMost RecentMost LikesSolutionsRe: Looking for formula checkbox to check if a record was created in the first 5 days of the current month That worked Gary! Thank you!! ------------------------------ Dawn Rene ------------------------------ Looking for formula checkbox to check if a record was created in the first 5 days of the current month I need to figure out a checkbox formula to check if a record was created within the first 5 days of the current month using [Date Created]. Any suggestions? ------------------------------ Dawn Rene ------------------------------ Re: Is there a way to add a line break to a text field directly in the pipeline Thank you! That worked! ------------------------------ Dawn Rene ------------------------------ Is there a way to add a line break to a text field directly in the pipeline I have a pipeline that creates new records in another app based on a status change. One of the fields that I want to add to the newly created record is a combination of fields from the original application. For instance, to the Description field in the table where I want the record created I want a list of fields from the source table. Description (pipeline) Meeting on {{a.meeting_time}} with {{a.participant_full_name}}. Status: {{a.status}} This can get quite lengthy in the field in the new record and I'm wondering if there is any way to put in some code directly in the pipeline so the field in the new record is in a list (on their own line) rather than bunched together. It would also be nice to formulate any html directly in the pipeline if it is going to a rich text field. Any idea if this is possible? Dawn ------------------------------ Dawn Rene ------------------------------ Re: Trying to find a formula that calculates 24 hours before now Brilliant! Thank you very much! ------------------------------ Dawn Rene ------------------------------ Trying to find a formula that calculates 24 hours before now I'm trying to find a formula to color a record row in a report that if the date in my date/time field, registration_completion, is within the last 24 hours, color it yellow. This doesn't work so I know I'm missing something. If(ToHours([registration_completion]=Hours(-24), "#00FF00") Any ideas appreciated. Thanks. ------------------------------ Dawn Rene ------------------------------ Trouble with query comparing field data between two unconnected tables I'm trying to get a query to work to compare if data contains similar letters between fields in the two tables and output text from another field. Writing the formula in Table 1 Desired output would be if [product code] (FID 116) in Table 1 contains 'EL' and [Product Code Selection] (FID 8) in Table 2 (bs9xqc72i) contains 'EL', list value from Table 2, Name (FID 6). I know I need to use the GetFieldValues(GetRecords( query but I'm new to queries and am lost as to what to do next. Any help would be much appreciated. ------------------------------ Dawn Rene ------------------------------ Re: Formula checkbox not working for more than one parameter Boom! That was it! Thank you! ------------------------------ Dawn Rene ------------------------------ Formula checkbox not working for more than one parameter I have a formula checkbox that doesn't seem to work when adding more than one condition. I want it to be true when a duration field is less than 30 days and another multi-select text contains "In-Person". My formula is: If([Duration-Delivered - Created]<Days(30) & Contains([All Session Modalities Next Session Date NOT CANCELLED or DOWNSIZED],"In-Person"), true) The first one by itself works fine, If([Duration-Delivered - Created]<Days(30), true). However, when I add the second part the < highlights yellow and says the less than sign cannot be applied on types duration, text. Any assistance would be appreciated. ------------------------------ Dawn Rene ------------------------------ Re: How to find a date from the previous record of a user in the same table Thanks Mark. Let me take a stab at it this weekend and I'll connect with you on Monday! -- Dawn Rene QuickBase Administrator dawn.rene@betterlesson.com 616.808.7210