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

Forum Posts

Connecting multiple fields between two bases

I'm a new enough user that I don't really know if this is a Base Design, Automation, Sync, or Formula question - apologies.I use Airtable to manage a golf travel business and I have one Base that is a client list with 2 Tables (Names and Past Trips)....

BetsyA by 4 - Data Explorer
  • 109 Views
  • 6 replies
  • 1 kudos

Sort in Rollup field results

Hey amazing people I have a rollup field puling in unique values, and I really would like it sorted (in this case by ascending date) but I can't figure out how to do that? Community Search didn't bring much up for me.Here are my settings:And here is...

Shannon_Bradley_0-1692677780365.png Shannon_Bradley_1-1692677816434.png

Monthly Totals Table

Hello - I'm trying to create a table with my KPIs that combines 'campaigns' and 'clients' into a monthly view that sums up the total of all the campaign KPIs for that month separated by clients.I've recorded a Loom that hopefully gives the needed con...

Multiple issues from one form? Linking out of a form?

Hey,I've started using Airtable recently and have now run into two issues, that stopp me from really using it fully. One of them is:I use Airtable to track deliveries. We get orders which usually contain a series of Deliveries, 99% of the time contai...

Luka by 4 - Data Explorer
  • 166 Views
  • 1 replies
  • 0 kudos

Create a monthly summary of sales

SpoilerHi.I am new to this so sorry if this is the wrong place to post.I have tried to searched for it, but could not find it, so if anybody have a thread about it, please guide me in the right direction We have just started using airtable for our sm...

Manolith by 4 - Data Explorer
  • 139 Views
  • 2 replies
  • 0 kudos

Resolved! Create a field that is 6 months after the last date entry in that row

Hi Everyone,I am sure this is a common question, but I can't seem to find it... When staff join they have a 3 month/6month and 9 month review. They then have their Annual review (which is always 1 year after their 3 month review). They then have a mi...

Screenshot 2024-02-28 at 15.41.10.png
Nikiska by 6 - Interface Innovator
Solved
  • 208 Views
  • 3 replies
  • 1 kudos

Creating Junction Table

Hi Everyone, Thanks for your help in advance and ill try articulate this as best i can.Im trying to create a junction table from 2 tables.One being a table that contains "new leads" exported from a CRM. It contains a persons name, contact details  pr...

alconnor by 4 - Data Explorer
  • 133 Views
  • 1 replies
  • 0 kudos

Resolved! Is there a way to create complex multiselect field?

I wanted my user records to have a field determining skills and proficiency for each skillsSay for exampleFull Name | Language ProficienciesElsa | English - Beginner, Dutch - Mid-Level, Japanese - FluentHow do I achieve that?  

rjcristy by 4 - Data Explorer
Solved
  • 232 Views
  • 2 replies
  • 2 kudos

auto scoring test results

Hoping someone can help figure out the best way to set this up.We have students taking various assessments that range in length from apron 20 - 100 questions. The assessments feed into a table with the submission ID as the primary record field, and t...

hhspiel by 5 - Automation Enthusiast
  • 152 Views
  • 0 replies
  • 0 kudos

Timeline Summary Variable Values

Is there a way to make a timeline's summary bar display different values over a given object's duration? I'm trying to make a map of the effort levels for various projects to forecast my team's workload at a given time (not using utilization because ...

paul-morrill by 5 - Automation Enthusiast
  • 142 Views
  • 0 replies
  • 0 kudos

Syncing updated publish dates back to source table

I’m currently facing a challenge with syncing publish dates across different Airtable tables and bases and am looking for some guidance or a potential workaround.Here's a breakdown of my workflow:- I have two Airtable bases: "Marketing Campaigns" and...

Bundle Sales Calculation

We have SKU's that are bundles and comprise of a combination of other SKU's.So an SKU can be sold individually and also be sold in a bundle.Example -SKU-1 is a bundle comprising of SKU-2 X 1 unit, SKU-3 x 1 unit and SKU-4 x 2 units.We will be pushing...

hkj by 4 - Data Explorer
  • 166 Views
  • 0 replies
  • 0 kudos

Autonumber from number sequence

Hello, I have a primary field that is a number field that contains sequential invoice numbers. I would like to know if that number field can be converted to an autonumber field that starts at and continues the sequential numbers. It seems silly to ha...

Auto fill field based on cliend id

I have a 2 tables Events and clientsI have a form based on events table that clients submit their event requestsi want to when they open the form to have an id field based on clients table  that once they type (or choose from a drop down list) All th...

laks by 4 - Data Explorer
  • 217 Views
  • 1 replies
  • 2 kudos