Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,702 Replies
10000 Topics
S
Sam_MilleaNew Participant
posted in Other Questions
Filter Linked Fields on Condition

I have been searching everywhere for a way to do this, but I have a table, named Categories. It is linked to a table named Bonuses. What I want to do is in my main form (and table) filter the bonuses available based on the Category selected. Is this possible?

103
M
A
Allison_YachtNew Participant
posted in Other Questions
Table or Dropdown

Hi, I apologize in advance, I am sure this is an easy question, but alas. I am new to airtable and have a very basic questions- How do I when to create a table and when to create a dropdown? I feel like if i am going to reuse the data I should do a table, but I seem to have a LOT of tables right now and that doesn’t feel quite right. Thank you in advance.

192
A
R
Richard_DobbinsNew Participant
posted in Other Questions
Getting month and year from other fields

Okay trying to do a bill manager and I have months listed and check marks for when a month is complete. I have put the day of the month in the date field. I would like to get the month off of the check marks and year as current year. Is this possible or am I asking for too much. Tia… Richard

3381
Kamille_Parks11
R
Robert_CroydonNew Participant
posted in Other Questions
Error message "On your billing plan, you may only email collaborators with verified emails. See more plans."

Hi - We have signed up to the Pro Plan but when I try and set up emails I get the message “On your billing plan, you may only email collaborators with verified emails. See more plans.” Is this because we are still on a Pro Plan Trial and it is waiting to switch over in 2 days to the full Pro Plan. Can it be forced to switch over now if this is the case?

71
kuovonne
Pascal_Vallet
Pascal_ValletInspiring
posted in Other Questions
Sync one database from 2 avoiding duplicates

I have three databases from which I need to set up the proper sync: Database Students 20-21: list of all the students from 2020-2021 school year (including field school year 20-21, unique student ID and photos (attachment) Database Students 21-22: list of all the students from 2021-2022 school year (including field school year 21-22, a unique student ID and a field Indicating if a student is new. (no photo yet) Database Students All Years: I would like to sync the Database 2020-21 and then the database 2021-22. This database is not syncing the field “New student” as this database is to collect information through the year. the field School year becomes “Last Year enrolled”. Problem : avoiding duplicates I would like to be able to sync the 2 first databases with the third one and avoid duplicates. For now if student ID xxxx is in database 2020-21, and he is re-enrolled so he is also in database 2021-22, then I have two occurrences in database All years. How can I sync the databa

10
Pascal_Vallet
A
Alexandre_PiarrNew Participant
posted in Other Questions
Help Vega-Lite line graph

Hi, I’m trying to create a line chart representing a cash flow with Vega Lite. In my main table I have record that are cash transactions with a date and an amount (either positive or negative). I want to display my bank balance for each month: in February I want to have January + February and not only February. Does anyone has an idea on how to do it ? Thanks Here is my vega code: { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Solde mois par mois", "width": "container", "height": "container", "mark": { "type": "line", "point": true, "tooltip": true }, "encoding": { "x": { "field": "TECH Cash flow date", "title": "Mois", "timeUnit": "month", "type": "nominal" }, "y": { "field": "Cash Flow (pondéré)", "aggregate": "sum", "title": "Solde bancaire (€)", "type": "quantitative" } } }

10
A
V
Vicki_WhincupNew Participant
posted in Other Questions
How to create a 2022 holiday view

I am new to using airtable and I need to create a new view. We use airtable to log annual leave and sickness requests. I need to set up for annual leave requests for 2022 - any tips greatly appreciated

00
V
J
Joanne_CooperNew Participant
posted in Other Questions
Help on "Use this data" and/or synching functionality with different users

I have an airtable base and a wordpress site. Playiit I want users to somehow be able to mark records in the database as their “favourites”. Ie each user will have a different set of “favourites” to any of the other users. I am not sure how I can achieve this. Can I use the “Use this data” functionality somehow to achieve this? If a user does use the “Use this data” functionality is there some way I can keep their base updated with changes in my base? Any help is much appreciated

80
J
T
Tom_RInspiring
posted in Other Questions
How much does it cost to create a new base?

I have a Pro plan with Airtable. I cannot seem to find anywhere what it costs to create a new base. We currently have 6 different bases linked to the account. Is there a limit to how many bases I can create? Thanks in advance.

184
J
K
Kailyn_NelsonParticipating Frequently
posted in Other Questions
How to recreate this nonprofit funding report in Airtable?

Hi, I have this PDF report (opens a Google Drive link to the PDF) that I need to recreate in Airtable. As you’ll see, I need to set up some sort of if statements to “count these records if its value for this column is this, this, or that” and then summarize those counts in various ways. I am going to try working with COUNT-IF formulas and grouping to show summaries, but I still need to allow users of this base to pull these reports only for certain time periods. I have looked at Page designer, Pivot table, and miniExtensions Form to summarize this data, and I have not been able to figure out what I’m looking to do. Can someone help? (I tried reaching out to the support team and all they did was send me basic intro walkthroughs to the product which were not what I was looking for at all).

20
K
A
alana_andersonNew Participant
posted in Other Questions
Script to add a new record

are there any examples of scripts that add a new record? i built a script that updates a field on a record when the email exists. now i want to modify it to add a new record if the email doesn’t exist yet. i don’t see any examples and not sure what the syntax is for adding records. thank you!

524
A
M
Muriel_VandermeNew Participant
posted in Other Questions
Formula to remove text after a comma

Hello, Do you know what is the formula to remove text after a coma? I tried to convert the Excel formula LEFT(A1,FIND(",",A1)-1) to something like LEFT({Name of field},FIND(",","{Name of field}")-1), but without success. Thank you for your help!

9810
K
D
Dave_Mackey1New Participant
posted in Other Questions
Way to Filter Items Shown in Linked Table Field?

I’m using AirTable for project management. I have a table that has all of my projects. One of the fields is a tasks field which shows the individual tasks (linked record from the tasks table) which are associated with that project. Is there a way for me to filter which tasks show up in this tasks list? (e.g. if I want to show the remaining open tasks)

112
M
J
Jason_FKnown Participant
posted in Other Questions
Conditions on Form Selections

I have a form that allows a User - selected first, to then select 8 items individually. I want to make sure the user never selects the same item twice by adding conditional logic, but I can’t seem to do that on a choice by choice basis per user. The perfect functionality would be to say if Form already selected X eliminate it from the choices on next selection and so on. The conditionals only seem to be on the entire table not the form directly. Any ideas?

11
ScottWorld
N
nutmixNew Participant
posted in Other Questions
Bug tracker changes bug number every time you enter a new one?

Using the built in bug tracker template, when ever you create a new row, e.g. by hitting the plus at the end of the table, it gives you a warning that “record moved” and re-orders all your existing bugs. This makes it unusable, as you cant track anything with other people, e.g. can you give me the status of bug number 2. To make it worse, the number of the new bug is random: sometimes it creates the new bug as number 1, and renumbers all your existing bugs, sometimes it creates the new bug with a random bug number somewhere between 1 and the total number you already have, for no apparent reason. a) is this normal. b) is there any way to fix this? New bugs should always have the number n+1, where n is the current number of bugs, and existing bugs should NEVER have the number changed. To make it worse, if you change the view (e.g. by priority or by “all bugs and issues”) tickets get different ids.

21
ScottWorld
S
Stephen_SullivaNew Participant
posted in Other Questions
Zapier Search Formula

I am trying to create a ‘Find Record’ Airtable Task in Zapier that finds a row based on the values in two columns, {USER ID} and {TAGGED RX}. The USER ID should match the value in a previous step and the TAGGED RX should equal 0. This is the formula I am using, but it is creating an error: {USER ID}="{{29838037__user__user_id}}"&"{Tagged Rx}=“0” Is there a mistake in my code? Thanks you!

12315
K
J
Justine_MurdyNew Participant
posted in Other Questions
Budgeting for touring performing arts group

I’m very new to Airtable and spreadsheets generally. I’m wondering if it’s possible to find a template that I can modify to my needs. I have a touring performing arts company and want to be able to budget more confidently. Our expenses are highest if we just do a “run-out” (one gig) versus a multi-week tour. Some expenses are regardless of how many weeks we are away. We have ongoing expenses (like office space) that we incur whether we tour or not. I’d like to be able to plug in number of days of a tour to figure out my expenses so I know what our weekly nut should be if it’s a one week tour or a 9 week tour with a one week pause in the middle (we’d fly the cast home but put the equipment in storage). Being able to look at a variety of scenarios like that would be so amazing, but I can’t find any templates that seem like easy to modify bases. Might you have some suggestions? I’ve used Airtable for other uses that take advantage of calendar, social media scheduling possibilities, etc. M

30
J
C
Clement_LapierrParticipating Frequently
posted in Other Questions
Creating a LinkedIn social media automation - with video

Hello everyone, I am trying to use Airtable as a way to automate corporate communication on various social media. The Twitter integration seems to be working fine, but I don’t see anything that would allow me to post to LinkedIn, which is the most important social media I am using. I tried using #zapier “company update” function to create my posts, but I am encountering several issues that I can’t find solutions to. The @mention someone doesn’t do anything. I’m guessing nothing can be done here, similar to Twitter, but it’s worth mentioning. Now to the core part: I would like to attach a video to my file, just like when I post a video on LinkedIn by uploading it. I can’t seem to find how to do that, as the Zapier “preview - image” field doesn’t seem to support video files. Even if I give up posting videos and focus on images, all I can get is for them to appear as “previews”, as mentioned by the field name. This leads to the image being cropped and generally not aesthetic. Is t

104
C
Paolo_Perrone
Paolo_PerroneInspiring
posted in Other Questions
Is it possible to save a webpage as a pdf?

Is it possible to save a webpage as a pdf? it doesn’t seem to be possible with the native web-clipper, any alternative solution?

122
ScottWorld
T
Terri_MartinParticipating Frequently
posted in Other Questions
Airtable Form - Would you like to add another entry?

Thanks in advance for the answers. I need your help, please. I work in HR and I have a Safer Recruitment table in Airtable and I have created the form to be sent to new recruits. It asks for a persons details, work history, and educational achievements. For the work history, once they have entered their latest job, it asks if the person needs to add another entry. (Company name, job title, your responsibilities, etc) Now without adding 20 fields for each entry if the person has had that many jobs, is there an easier way to do it. I know that 1 form populates the one row in the table but I am flummoxed how to obtain the multiple entries. Looking forward to your responses

00
T
O
Oskars_CNew Participant
posted in Other Questions
Color of Gantt view background

Hi! Is it possible to change the background color of Gantt view? It is set at Gray and i need a brighter color to separate working days and weekends (Yellow would do fine) Thank you

10
O
K
Kartik11Participating Frequently
posted in Other Questions
How to make an automation that sends a Slack message to particular member?

Hi there, I hope you are doing good! I have 15 members on Slack, and on a single-select field in my base. When I create a record, I have to select a staff member I want to assign a task to from that dropdown. The thing is, is it possible to create an automation that sends a Slack message to that particular member, that a task is allotted to him/her? Or should I add my staff members as base collaborators - will it be possible to send a message to that selected member on Slack? Any help is appreciated! Thanks! :grinning:

40
K
M
Marianne_HislopNew Participant
posted in Other Questions
Repeating, Recurring Records. Again :)

I keep coming back to Airtable hoping to be able to use it for our customer job booking and scheduling. The one thing that I keep hitting a wall with in any type of platform similar to Airtable is the lack of ability to have recurring records that can generate, in advance or at the time of entering the job, all events in a calendar view. Like how most major calendars do. We currently use CalendarWiz, then import into excel, change columns around, assign customer in a column to match the record etc. 90% of our job bookings are recurring. A mixture of daily, twice weekly, 1, 2, 3, 4… weekly, etc. Is there an easy work around in Airtable if it doesn’t have this option. The view of the jobs at least a month in advance is crucial to organise and plan our routes, workflows and employees in advance. The zap type things I have been reading I don’t think will work for us. Any ideas how to work with this. A template maybe for each type of job entry. One for once off jobs, one for recurrin

30
M
D
Daniel_DowNew Participant
posted in Other Questions
Query by modification date

Hello, I’m trying to figure out a way to use the API to get all records modified TODAY(). When I retrieve records with the API I can see the createdTime field, but no modifiedTime field though the documentation says it exists. Does anyone know of a formula that I can use to get all records modified TODAY()? Thanks!

20
D
D
Dr_MonicaRysavyNew Participant
posted in Other Questions
Could you please help me roll up this data?

I have a master student data that I want to roll up lessons created per student into (on a per-student level). It looks like this The curriculum (lessons) table has data like this: When I create a linked record and attempt to roll it up, only 1 lesson is returned per student (the one that was connected to the student name when I selected the student in the linked record field). Any ideas about how I could fix this, please? Thank you! -Monica

31
R

Badge winners

Show all badges
Terms & Conditions