# Data Sources - [Intro to Data & Tables](https://guides.noloco.io/data/data-overview.md): Data is the foundation on which your Noloco app is built. - [What are Tables?](https://guides.noloco.io/data/data-overview/what-are-tables.md) - [Database Examples for Beginners](https://guides.noloco.io/data/data-overview/database-examples-for-beginners.md) - [Setting a Table's Primary Field](https://guides.noloco.io/data/data-overview/setting-a-collections-primary-field.md): Learn how to control what field you see in your app when a record is linked to another record - [Syncing](https://guides.noloco.io/data/data-overview/syncing.md): Syncing data from external data sources to your custom Noloco applications - [Noloco Tables](https://guides.noloco.io/data/collections.md): A table contains a list of items of the same type, like users, companies or tasks. Your portal will come with several tables by default, such as Users and Companies. - [Field Types](https://guides.noloco.io/data/collections/field-types.md): Understand the different field types that are supported on Noloco tables, or any external data source - [Text Fields](https://guides.noloco.io/data/collections/field-types/text.md): Learn about Text fields in Noloco tables - [Date Fields](https://guides.noloco.io/data/collections/field-types/date.md): Learn about Date fields in Noloco tables - [Number (Integer) Fields](https://guides.noloco.io/data/collections/field-types/number-integer.md): Learn about Integer Number fields in Noloco tables - [Number (Decimal) Fields](https://guides.noloco.io/data/collections/field-types/number-decimal.md): Learn about Decimal Number fields in Noloco tables - [Boolean (Yes/No) Fields](https://guides.noloco.io/data/collections/field-types/boolean.md): Learn about Boolean (Yes/No) fields in Noloco tables - [Single Option Select](https://guides.noloco.io/data/collections/field-types/single-option-select.md): Learn about Single Option Select fields in Noloco tables - [Multiple Option Select](https://guides.noloco.io/data/collections/field-types/multiple-option-select.md): Learn about Multiple Option Select fields in Noloco tables - [Duration Fields](https://guides.noloco.io/data/collections/field-types/duration.md): Learn about Duration fields in Noloco tables - [Street Address Fields](https://guides.noloco.io/data/collections/field-types/street-address.md): Learn about Street Address fields in Noloco tables - [Map Coordinates](https://guides.noloco.io/data/collections/field-types/map-coordinates.md): Learn about Map Coordinates fields in Noloco tables - [Date Range Fields](https://guides.noloco.io/data/collections/field-types/date-range.md): Learn about Date Range fields in Noloco tables - [Full Name Fields](https://guides.noloco.io/data/collections/field-types/full-name.md): Learn about Full Name fields in Noloco tables - [Phone Number Fields](https://guides.noloco.io/data/collections/field-types/phone-number.md): Learn about Phone Number fields in Noloco tables - [File/Upload Fields](https://guides.noloco.io/data/collections/field-types/file-upload.md): Learn about File/Upload fields in Noloco tables - [Created By](https://guides.noloco.io/data/collections/field-types/created-by.md): Learn about the Created By field in Noloco tables - [Last Updated By](https://guides.noloco.io/data/collections/field-types/last-updated-by.md): Learn about the Last Updated By field in Noloco tables - [Assignee](https://guides.noloco.io/data/collections/field-types/assignee.md): Learn about the Assignee field in Noloco tables - [Relationships](https://guides.noloco.io/data/collections/relationships.md): Learn more about how relationship lets you link one record to another - [Automatic Links](https://guides.noloco.io/data/collections/automatic-links.md): Learn how to add an automatic link to any non-Noloco data source - [Rollup Fields](https://guides.noloco.io/data/collections/rollups.md): Learn more about Rollups - [Lookup Fields](https://guides.noloco.io/data/collections/lookup-fields.md): Lookups in Noloco allow you to fetch and display related information from other data tables, enhancing your data relationships and insights without duplicating data. - [Formulas](https://guides.noloco.io/data/collections/formulas.md): Overview of formula fields in Noloco — what they are, when they recalculate, and what types of values they output. - [Creating a formula field](https://guides.noloco.io/data/collections/formulas/creating-formula-fields.md): Step-by-step guide to creating a formula field on a Noloco table. - [Examples](https://guides.noloco.io/data/collections/formulas/examples.md): Common formula recipes for Noloco — joining text, replacing parts of strings, adding days to dates, and basic calculations. - [Troubleshooting](https://guides.noloco.io/data/collections/formulas/troubleshooting.md): How to diagnose and fix formula fields that aren't returning the expected value in Noloco. Common pitfalls include comparing Single/Multiple Option fields against bare identifiers instead of quoted op - [Operators](https://guides.noloco.io/data/collections/formulas/operators.md): Complete cheat sheet of every operator supported in Noloco formula fields, grouped by category. Use this page to scan or search all operators at once; follow the category links for full details and ex - [Date & time operators](https://guides.noloco.io/data/collections/formulas/operators/date-and-time.md): Reference for all date and time operators supported in Noloco formula fields, including TODATE, DATE, DAY, DAYS, WORKDAY, EDATE, EOMONTH, HOUR, MINUTE, SECOND, MONTH, YEAR, WEEKNUM, ISOWEEKNUM, YEARFR - [Logic operators](https://guides.noloco.io/data/collections/formulas/operators/logic.md): Reference for all logic and comparison operators supported in Noloco formula fields, including IF, AND, OR, NOT, TRUE, FALSE, NULL, ISNUMBER, and the comparison operators <, >, =. NULL, TRUE, and FALS - [Math operators](https://guides.noloco.io/data/collections/formulas/operators/math.md): Reference for all math and numeric operators supported in Noloco formula fields, including +, -, \*, /, ABS, CEILING, FLOOR, ROUND, ROUNDUP, ROUNDDOWN, INT, EVEN, ODD, MOD, POWER, SQRT, LOG, FACT, SIGN - [Text operators](https://guides.noloco.io/data/collections/formulas/operators/text.md): Reference for all text and string operators supported in Noloco formula fields, including &, CONCATENATE, LEFT, RIGHT, MID, LEN, UPPER, LOWER, PROPER, TRIM, CLEAN, FIND, SEARCH, REPLACE, SUBSTITUTE, R - [Noloco AI](https://guides.noloco.io/data/collections/noloco-ai.md): AI-powered columns that bring intelligence to your tables by using AI to perform tasks like classification, summarization, sentiment analysis, grammar correction and more - [Import a file](https://guides.noloco.io/data/collections/import-a-file.md): Create a Noloco table from a file - [Airtable](https://guides.noloco.io/data/airtable.md): Learn how to build an app in Noloco around your Airtable base - [Google Sheets](https://guides.noloco.io/data/google-sheets.md): Learn how to plug your Google Sheets into your Noloco app - [SmartSuite](https://guides.noloco.io/data/smartsuite.md): Learn how to build an app in Noloco around your SmartSuite solution - [MySQL](https://guides.noloco.io/data/mysql.md): Learn how to build an app in Noloco around your MySQL database - [PostgreSQL](https://guides.noloco.io/data/postgresql.md): Learn how to build an app in Noloco around your PostgreSQL database - [Supabase](https://guides.noloco.io/data/supabase.md): Learn how to build an app in Noloco around your Supabase database that runs PostgreSQL under the hood. - [REST APIs](https://guides.noloco.io/data/rest-apis.md): Connect any REST API to Noloco as a read-only table - [HubSpot](https://guides.noloco.io/data/hubspot.md): Learn how to build customer portals, internal tools and partner apps from your HubSpot CRM - [Stripe](https://guides.noloco.io/data/stripe.md): Seamlessly bring your Stripe data—like Customers, Invoices, Subscriptions, Products, and Prices—into your Noloco app. - [Xano](https://guides.noloco.io/data/xano.md): Learn how to build an app in Noloco around your Xano api --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://guides.noloco.io/data.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.