NicoleCordeiro1
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: If/then with blank field and checkbox
thank you, everyone! the second option worked, and then I just flipped the true,false to false, true and that worked! thank you both for your help! I'll be able to use the first option I believe with another challenge. Thank you!!! ------------------------------ Nicole Cordeiro ------------------------------If/then with blank field and checkbox
Hello friends, question about a field that used to work for me but no longer does. In one form, one field will either be blank or have a number in it, we'll call it "tag number". If "tag number" is blank, I set up a checkbox to check. If "tag number" is filled out, then the checkbox will not check. the formula I used that used to work was Checkbox-formula if([tag number]=null, true, false Am I doing something wrong? The box is not showing checked when I leave the Name field blank. When I use If(IsNull([tag number]), false, true) It checks whether it is blank or not Help ------------------------------ Nicole Cordeiro ------------------------------Pie Chart Report with similar field values
(example) So if this is my table (turned pie chart) Color # of shirts red 10 pale red 3 blue 5 black 7 But in the pie chart, I want Red and Pale red to both be grouped as "red" so the value would be 13 but in a table report, I still want to report them separately in a field. Is there a way to do this? Thanks! ------------------------------ Nicole ------------------------------Re: Date field with only day and month
I went ahead and just made the dates in the date column to all include 2019. I'm still running into an issue with reminders/notifications when it comes to notifying their Supervisor that a performance appraisal is due. (table example below) So how do I make sure that Lonnie and Oreste are always linked with Mark b/c they're on Mark's Team. And then when it comes time for their eval, say maybe 7 days prior to the [eval due date] (the above example are past due, but you know what I mean), how do I ensure that Mark is notified and not all the other Supervisors? Does their need to be a relationship?
