Скачать с ютуб Oh So Fantastic Formula Query Functions in Quickbase в хорошем качестве

Oh So Fantastic Formula Query Functions in Quickbase

Get the Query Formula Playbook: https://www.quickbasejunkie.com/query Formula Queries will forever change the way Quickbase builders build apps. Since the dawn of Quickbase time, table-to-table relationships have been required to aggregate data from one table into another – unless you invested in fancy custom code. Consider that a thing of the past! Now, with the 5 functions below and some query writing skills, you can forgo the complicated relationships when listing, counting, and summing data across tables. Just a few possible uses: 🔥 Ranking or numbering records 🔥 Grouping and ordering records, such as "2 of 10" 🔥 Showing top 10 records with remainder grouped as 'other' 🔥 Adding running totals to table reports 🔥 Identifying duplicate or similar entries 🔥 Lookup values on another table (without a relationship) 🔥 Lookup values from the same table for a prior time period 🔥 Aggregating data from multiple tables onto one table Check 'em out and be sure to watch the demos! GetRecord() Returns a single record for use with other functions to Size( ), SumValues( ), or GetFieldValues( ). Requires the target record's Record ID# (rid) and the Table DBID (dbid) if the record is not on the same table as the Query Formula. GetRecords() Returns a list of records for use with other functions to Size(), SumValues(), or GetFieldValues(). Requires a query (query) string and the Table DBID (dbid) if the record is not on the same table as the Query Formula. Size() - Numeric Formula Returns the count of items in a list. Used with GetRecords() when counting the items/records in a record list. Tip: Size can also be used on Multi-select Text and User List fields to return a count of items. SumValues() - Numeric Formula Sums the values in a specified field within a record list. Used with GetRecords(). GetFieldValues() - Text Formula Returns a list of field values for a specified field in a text format. Used with GetRecord() or GetRecords(). Requires a Record or Record List and a field ID (fid) to return. RESOURCES: Formats, Examples, FAQs etc from the video ⇨ https://quickbasejunkie.com/blog/form... Query Writing 101 ⇨ https://quickbasejunkie.com/blog/quer... Demos in Quickbase ⇨ Rank Records: https://quickbasejunkie.com/blog/how-... ⇨ Running Total: https://quickbasejunkie.com/blog/how-... ⇨ Metrics Table: https://quickbasejunkie.com/blog/how-... Quickbase Formula Queries Documentation ⇨ https://help.quickbase.com/user-assis... 👍 If you find this helpful, please like & subscribe! #Quickbase #QuickBaseJunkie #QuickbaseFormulaQueries #QuickbaseFormulas #Database #NoCode #LowCode 🔥🔥🔥 FREE TOOLBOX🔥🔥🔥 Get The Action Button – 50+ Actions & URL Components EXPLAINED! https://quickbasejunkie.com/toolbox Feeling like a Junkie? Subscribe Now! https://www.quickbasejunkie.com/sign-up LET'S CONNECT! LinkedIn ➤   / quickbasejunkie   Instagram ➤   / quickbasejunkie   Facebook ➤ https://fb.me/quickbasejunkie Quick Base Junkie ➤ https://quickbasejunkie.com Learn More About Quickbase @ https://quickbase.com © Quick Base Junkie COPYRIGHT NOTICE: The content, title, description, and specific ways in which the information in this video is organized, documented, and presented are the creative property of Quick Base Junkie. For use in any medium attribution is required, for questions or use permission, contact me @ https:/quickbasejunkie.com/contact. Quick Base Junkie is unofficial and not affiliated with Quickbase Inc.