ContributionsMost RecentMost LikesSolutionsFormula to display someone's age based on date? Hello I wanted to see if there was a way to calculate someone's age based on the day that they enrolled with us. I have the DOB as a date field and the Start date as well. It would be easy to just do [DOB]- [Start Date] and get the days but I would like the answer to be displayed in years if the person is older than 1 year old and displayed in months if they are less than a year old on a Formula-Text field. Majority of Clients are Children but we also have mothers join programs. Would this be possible or is manually the only way? Thank you in advance, I appreciate your help. ------------------------------ Maritza Acosta Gonzalez ------------------------------ SolvedFormula to Calculate percentage based on Checkmarks and dates Hello, I need some help. I need to generate a Percentage based on How many times a member joins a meeting per year. I have each attendance as a simple checkmark and then another field for a date. We have various types of meetings some are only like twice a year or the most we have is 11. Each record is per person so I have dates filled and just if they attended or not. Is there anyway to make quickbase know Which meeting is the last and make that a number to use to add to a formula to calculate a percentage? How would I write a formula where I could have the total number of Checked Attendance/ by the Maximum number of meetings per year. Like have one record have 7 meetings and the person only attended 5 and have the field with the formula generate 71%. but then the next record have 5 meetings and have only 1 meeting and have the field with the formula automatically generate 20%? Or does this have to something that Has to be manually done because the records can vary too much? Have attached screen shot for better visualization. I hope I explained well enough but let me know if you need further clarification. ------------------------------ Maritza Acosta ------------------------------ SolvedRe: Button help on formula textYes that would be fine. we just want the same actions to happen the pop up is not necessary. Thank you again. ------------------------------ Maritza Acosta Gonzalez ------------------------------ Re: Button help on formula textSorry about that. Okay here is the code for Incomplaince and N/a they are the same. If( [# of Open FCE File Actions]<>0, "javascript:alert('There is an open action for this question. Please close out the question before marking question In Compliance')", "javascript:" & "$.get('" & URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=bg9b37dz5u7d4b8qz6gqcqq9wkr&_fid_11=In Compliance&rid=" & [Record ID#]& "',function(){" & "location.reload(true);" & "});" & "void(0);" ) and this is the formula text for Followup needed: If( [Compliance]="Follow-Up Needed", "javascript:alert('This question is already marked as Follow-Up Needed')", URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=bg9b37dz5u7d4b8qz6gqcqq9wkr&rid=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ACTIONS] & "?a=nwr&_fid_63=" &[Record ID#]& "&_fid_38=" &[Related Children Assignment]& " &nextURL=" & URLEncode(URLRoot() & "db/" & [_DBID_REPORTS] & "?a=dr&rid=" & [Related Childrens Report])) ) ------------------------------ Maritza Acosta Gonzalez ------------------------------ Button help on formula textLast year we made and finished an app for our company. And while we knew our information might change or be added to we knew it would never be truly finished. So it wasn't until yesterday when I was asked to add a new table to the app that I noticed changes made to quickbase. we have 4 formula fields that are the same in all our tables in our app that do the same thing. when you click on In Compliance and N/A they do the same thing only change the status to that answer. but when you click Follow-up needed we have it so it pulls the information of that record and adds a new record on another table called 'actions'. We have 17 tables with this system and they still work fine and do what they are suppose to do. I would edit them but since they work still I don't wanna touch the text to ruin it. The problem comes with the new table as I want to do the same thing but it looks like quickbase no longer supports javascript? as we get this error for In Compliance/Follow-up Needed and N/A I've tried deleting just the javascript part but it doesn't make my new table button appear like the other 17 tables. I'm unsure if I have to just rewrite the entire thing its self? Note that my company didn't learn this we had our QB start up consultant make the formula text and we basically just copied and pasted each time. I'll be putting the formula text below to see if it will help. This is the Formula for the button In Compliance This is the formula text for Follow-Up Needed And this is for N/A. which is essentially the same as In Compliance This new table that I created is going to be using the same buttons with the only difference being Yes/No/ N/A instead of In Compliance/ Follow up/ N/A As stated above I copied the text above just removed the javascript part but as you can see it just doesn't show up as an actual button. despite having display as button checked on I would appreciate any help. Thank you in advance. ------------------------------ Maritza Acosta Gonzalez ------------------------------Help with text on chartsHello, I was wondering if there is anyway that we can show the full text under a column in a bar graph chart. Our director wants to see the full question but Quickbase seems to always shorten the text. here's an example I can't find anything in the customize report settings that can allow all text. I appreciate any help, Thank you in advanced. ------------------------------ Maritza Acosta Gonzalez ------------------------------