ContributionsMost RecentMost LikesSolutionsNeed help with BirthdayWe have a Birthday field that is a date field and we would like to show "Birthdays" on a calendar report. Problem is birthdays entered last year don't show on a report because it is showing current year only. What would be the easiest solution to show the birthday on a calendar for every year moving forward.Any way to automate firing of form rules?I know this is probably a no. But is there a way to push form rules to fire automatically without putting the record in edit. I am used to workflows in salesforce which fire in the background. Example would be. I have Accounts and Invoices. I have a field on accounts that shows how many days since last the last invoice. I have a form rule that is setup to change the status of the account to lapsed if the number of days is greater than 20. The change will not happen currently unless you click edit on the account. Any help would be greatly appreciated.Re: I need help creating a button that will ""convert"" a lead.That worked perfectly. Thank you!Re: I need help creating a button that will ""convert"" a lead.Yes so when I use this URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?a=API_GenAddRecordForm&_fid_276=" & URLEncode ([Record ID#])& "&z=" & Rurl() It will take me to the new account record form but when I try to add fields for it to populate like this URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?a=API_GenAddRecordForm&_fid_10"&[Account]&"&=&_fid_276=" & URLEncode ([Record ID#])& "&z=" & Rurl() it is not populating the account field.I need help creating a button that will ""convert"" a lead.I am new to quickbase and am working on the sales process for our client. I have a table called Prospects (basically leads) and what I am trying to do is create a button in the prospect record that is called "Convert". What I want is for when they click convert it will create an account record and populate some of the fields with info from the prospect. Seems simple enough but I keep getting an error when trying to save the URL formula field. Any help would be greatly appreciated.