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

Base Design Activity

Problem with Database Architecture

Hi there,I'm facing an architectural problem for which I haven't a solution as of yet. This problem is linked to the way I handle revenue and payment depending on the client type – small company or big company.Here's how I decided to structure my dat...

JBJ_1-1737133664274.png JBJ_2-1737133748416.png JBJ_0-1737135056271.png JBJ_4-1737134338766.png
  • 19 Views
  • 1 replies
  • 0 kudos
JBJ by 7 - App Architect

Incorrect data imported in date format

Hi, I'm facing an Issue with importing data into Airtable. I have date prepared in Google Sheets which I'm trying to import in 4 diffrent ways: just copying the range (data table) and pasting it, exporting the .csv file and trying to import it, expor...

Zrzut ekranu 2025-01-15 o 20.37.23.png
  • 94 Views
  • 2 replies
  • 0 kudos

Resolved! Summary View for Current Month

Noob here. Frankly don't know where to start, and my mind is whirling with the results in the community, so let me describe what I'm going for.I've created a form that allows my community to report data in four areas for a health challenge: calories ...

  • 91 Views
  • 3 replies
  • 0 kudos

Resolved! Linking records on import when the primary fields don't match...

I have a database for our retail stores. The main table's first column is a formula that combines the store's name and the store's number with a " – " in between. For example, "1234 – Joe's Discount Hardware".I need to import data from a report that ...

  • 164 Views
  • 7 replies
  • 0 kudos

Database setup in different view

Explore various ways to organize customer details, including grid view, calendar view, gallery view, and form view, giving you easy access to their information. Set up automation to send reminders to customers about upcoming events. Sort, group, and ...

  • 174 Views
  • 0 replies
  • 0 kudos

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...

  • 558 Views
  • 1 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...

  • 331 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
  • 162 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...

  • 114 Views
  • 1 replies
  • 0 kudos