I have tried multiple way, know I am missing something, but can't work out what. I have one column for Date and the next column is yes. Meaning that consent has been given and on the date in the column. I now need a formula field that will return the...
Ok this seems pretty simple, but I just can’t get my head around it. I am new to formulas, so get the basics, but want to move beyond.
Fields are - Member, Age, Clearance, Expiry, Valid, Current Member, Needs attention.
Basically, if the Valid field ...
Hello all, my Friday afternoon brain just can’t get my head around this. I have a large database set up for our members and need to add new functionality to it. I have duplicated the base to try and nut it out.
I need a column that is for ‘past group...
I have set up and automation to email a client when their job is marked as done, and it is working. However, I just want to make it more intuitive if possible.
Currently - When marked as done and there is an email in the ‘client email’ field there is...
We have done a pantry inventory, and want to make a shopping list sheet. We would like things to auto add to the shopping list when they reach a certain level of stock.
So for instance,
If we have 12 soy milk in pantry, we want soy milk to add to the...
Thank you @Kenneth_Raghuna That works and gives me the valid, not valid row I was after. My work around was working too, but this is more what I am after. Thank you
I have kind of come up with a workaround that isn't exactly what I was after but works ok. I have used IF({Media Consent},DATETIME_DIFF(TODAY(), {Consent Date}, 'days'))and then created a view filtered by that column, only showing if the column total...
Thank you again! Brilliant. The first edit does exactly what I need, but will also look over the other offering. Thanks so much :slightly_smiling_face:
In this instance, I am using it for cast and production teams. Sometimes a member can be in the cast of one show, and then at a later date be on the production team of another. So I don’t want to give a specific type to each member.
So in the example...
Hi @Adam_TheTimeSavingCo
Sorry just wanted to quickly revisit this. I Would also like to have a ‘teacher’ column for this.
So in the top screenshot, the group tab, there would also be a list of teachers alongside members, all relating back to the mem...
