Help

The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Base Design
cancel
Showing results for 
Search instead for 
Did you mean: 

Base Design Activity

Handle Yes/No Answers in a table

I have data from an outside program that essentially has 300 questions from form submissions as columns and the rows containing Yes, No or N/A answers. I need to organize this data in a way to be able to get totals for how many yes/no for each questi...

  • 22 Views
  • 0 replies
  • 0 kudos
122 by 4 - Data Explorer

Looking to build app from a spreadsheet

What I'm after *should* be easy. I have spreadsheets of information that I manage informally. The rows of each spreadsheet are records that would ought to filled & updated by outsiders. Obviously there's a limit to how much we can do via Google Sprea...

  • 73 Views
  • 3 replies
  • 0 kudos

How do I override a value on a fillout form update?

I am trying to create a way for people to subscribe to a newsletter. The first form allows them to put in their name and email address. It works fine. I set a field called "Status" to Unconfirmed (as Single select type).I will then have an automation...

JeffJohnVol_0-1736364505857.png
  • 84 Views
  • 2 replies
  • 0 kudos

Default Time Zone

I have a form that is submitted daily by members of our team, and due to how the AirTable base was initially set up, it defaulted to GMT when our company is in EST, so when we default to 'todays' date, after 6pm EST it will jump to the next day. Is t...

  • 57 Views
  • 1 replies
  • 0 kudos

Display Sum of values from different tabels without link

Hi Airtable Community, I have the following problem:I have a Projects table with columns Assigned Budget 25, Assigned Budget 26 etc.I also have a table “Orders” which is linked to the project table. This means that several purchase orders can be assi...

  • 109 Views
  • 3 replies
  • 0 kudos

Xero Build OR Integration

Hi allI currently use Xero for my accounting (invoicing, billing, credits etc).Airtable is my order management system.I want to be able to create the accounting pipeline (invoices etc) in Airtable and have this upload directly into Xero.If I make an ...

  • 129 Views
  • 5 replies
  • 0 kudos
FPX by 6 - Interface Innovator

How to create Users table connecting projects owned

I want to create a users table. This will be tied to the users who have access. I already have a projects table which i can easily assign owners via the people who have access to the base, similar with tasks connected to those projects (this works fi...

  • 65 Views
  • 2 replies
  • 0 kudos

Combine Table in Base with Table from Another Base

Hi all,I'm working on a project and I need to Combine Table A from Base 1 with Table B in Base 2 to create one table, Table C.I've already linked the two original tables to be in the one base, but I can't figure out how I can automatically combine th...

  • 105 Views
  • 2 replies
  • 0 kudos

Resolved! Date data mismatch error with link to another table

Im trying to use a field related to another table, the field is a date datatype which is in local format (DD/MM/YYYY) but the lookup tries to use another data forma (MM/DD/YYYY) so its not retrieving properly.Fecha de Facturación and Fecha (from anot...

rubenfarias_0-1736152882209.png rubenfarias_1-1736152926722.png rubenfarias_2-1736153016392.png
  • 105 Views
  • 2 replies
  • 0 kudos