ContributionsMost RecentMost LikesSolutionsRe: Size(GetRecords Formula Query I sent you an email. ------------------------------ Denis Rochat ------------------------------ Re: Size(GetRecords Formula Query That was embarrassing. Thank you for helping me with thus. Unfortunately, it still does not work. ------------------------------ Denis Rochat ------------------------------ Re: Size(GetRecords Formula Query 1. Is the phrase "Water Trmt" actually in the data? verified 2. Isbrravks49the correct target table? verified ------------------------------ Denis Rochat ------------------------------ Re: Size(GetRecords Formula Query I tried the formula you posted and now I am getting: Formula syntax error A formula cannot end with an assignment to a variable declaration. var text QUERY = "{145.OAF. ' " & ToText(FirstDayOfMonth([Month (First Day)])) & " '}AND{145.OBF. ' " & ToText(LastDayOfMonth([Month (First Day)])) & " '}AND{80.CT. ' " & "Qualified" & " '}AND{81.CT. ' " & "Water Trmt" & " '}"; I also tried it without ToText and got the same error. ------------------------------ Denis Rochat ------------------------------ Re: Size(GetRecords Formula Query Month (First Day)] is a Date field. Lead Status and Lead Type are Multiple Choice. ------------------------------ Denis Rochat ------------------------------ Size(GetRecords Formula Query I am trying to populate a table named Metrics using formula queries. I populated several fields from the Opportunities table with no problem. See Attachment. I am trying to populate # QWT Leads (number of qualified water treatment leads) from the Leads TBL with no success using the following formula query: var text QUERY = "{145.OAF. ' " & FirstDayOfMonth([Month (First Day)]) & " '}AND{145.OBF. ' " & LastDayOfMonth([Month (First Day)]) & " '}AND{80.CT. ' " & "Qualified" & " '}AND{81.CT. ' " & "Water Trmt" & " '}"; Size(GetRecords($QUERY, "brravks49")) 145 is a date field, 80 is the Lead Status and 81 is the lead type, all in the Leads table and "brravks49" is the Leads Table. What am I doing wrong? ------------------------------ Denis Rochat ------------------------------ Using "and" in If( This is probably super elementary, but can someone help me make this work - please? Formula is in a Numeric field. ------------------------------ Denis Rochat ------------------------------ Re: Update Example Apps This particular app does not have Automations, just Actions. My ignorance on full display - I thought support for Actions had been discontinued. I should be able to proceed with what I want to do and get to work learning Pipelines. Thanks for the info Mark! ------------------------------ Denis Rochat ------------------------------ Update Example Apps I want to use an example app -ABC Invoices and Inventory Manager. Naturally the older Example Apps contain Actions and Automations. Are there alternatives to digging in and learning how to replace those with Pipelines. For example: Has someone already done that? Does the original author (if a Quickbase App) provide any information for replacing the no longer supported Actions/Automations? Thanks for any help on this? ------------------------------ Denis Rochat ------------------------------ Re: Realm Admin to get Switch User option.Thank you! I will provide User Feedback. ------------------------------ Denis Rochat ------------------------------