HannahEngelson
Qrew Trainee
Joined 9 months ago
User Profile
User Widgets
Contributions
Date to show as MMM YY
I have a due month formula field that needs to be sorted and reported by date and not by text. I'm trying to have it show as MMMYY (JAN24, FEB24, etc) since it's just a due month and not a specific date. I have a "dummy" date field that's the first day of the month, and I am using a formula text field to get the right formatting I need. I have the date field formatted as the abbreviated month, but it still includes the day. I'm using the formula below, but it says the first Month (red and bolded below) can't be used as a variable name. I copied this from another thread that worked for everyone who responded in it. What should I put there instead to get the date to change to the text month? Am I missing a step somewhere? Is this even the right way to go about this? var date DateWords = [My Date Field]; var text Month = Case(Month($DateWords), 1, "JAN", 2, "FEB", 3, "MAR", 4, "APR", 5, "MAY", 6, "JUN", 7, "JUL", 8,"AUG", 9,"SEP", 10,"OCT", 11,"NOV", 12,"DEC"); $Month & "" & ToText(Year($DateWords))Re: Pulling field from one table to another
Mark, thank you for the reply. I'm unsure what you mean by adding the Summary field. I can't add a summary field that will pull the date. If I try, I get an error that says the summary field can't be applied to the date field. I already have a summary field that adds whether the employee has a record for the meeting. That's how I filter out the reports of who still needs to have one scheduled. ------------------------------ Hannah Engelson ------------------------------Pulling field from one table to another
I've been trying to for days to figure this out on my own and I can't. I'm newish to writing formulas, and I'm not even sure if what I'm trying to do is best or even right. I have Table A, Employees. I have Tables B, for tracking probationary meetings. I have the relationship set up that Table A is the parent and Table B is the child. I need to track whether the employee had a meeting and that it happened prior to the due date. However, I can't have a lookup field from the child go to the parent. I need to bring the date from Table B to Table A so I can set up a report that will color code the record if the meeting was not done on time. I know how to do the color coding part, I just need help with getting the field from Table B to Table A. I've tried the GetFieldValues but I don't know how to point to a different table's field id. Table A emp id field is id 9. Table B related emp id is field id 15 and date is field id 28. Help! And thank you in advance! ------------------------------ Hannah Engelson ------------------------------Random sampling of records
I have an app that will be used for tracking when our employees are due for training. I want to have a table that can randomly pull a certain percentage of records that will receive a formal check event. For example, say I have 200 employees that are due for training this month. I need to pull a random 50%, who have also not had a check event in a certain period of time. Is there any way to do this with Quickbase? ------------------------------ Hannah Engelson ------------------------------Re: Syntax Error
And I do have the color set as a formula field, not the entry field. But if I understand what you're saying, if I make the Send Letter field a text field, I could do it the way I have it set up now? Just with "no" as the condition instead of false? ------------------------------ Hannah Engelson ------------------------------Re: Syntax Error
This is a formula-rich text field to get a different field to turn red if it isn't checked. It will work on the formula field when it's on a form, but it won't work in the Send Letter field anywhere. I have a table on the dashboard that has the checkbox field on it and I want that field to turn red if false. I followed the directions word for word on a Quickbase article about it and it's not working. It would just be normal if true. ------------------------------ Hannah Engelson ------------------------------Syntax Error
I have the following code on a formula field to highlight a checkbox field if it's false. I copied this code directly from the Quickbase article about it so I cannot figure out why it wouldn't work. The first backslash highlighted below is the one producing the error. Please help! If([Send Letter]=false, "<div style=\"color:white;background-color:red;\"> false</div>, [Send letter] ) ------------------------------ Hannah Engelson ------------------------------
Groups
Pipelines Qrew
A Qrew dedicated to sharing all things Pipelines.
