Other Questions

I am using airtable to track and manage activities in a plan. the relevant table has a baseline date field, a latest planned date field and an actual date field. Not every task has each date completed I want to plot cumulative progress (count the number of tasks due to be complete, or complete) over time. I am using Vega Lite to plot cumulative graphs. Within Vega-Lite I am using filters to remove the records with no dates, then use window and count operators to generate cumulative values. I can plot each graph independently, but if I try to layer, vconcat or hconcat the three graphs together than the filtering either cuts off the baseline fields or creates an incorrect jump at the start of the planned/actual dates as null dates are passed to Vega Lite as 01-01-1970. Looking for ideas please! transform and encoding script below: “transform”:[ { “filter”: { “field”: “Baseline Date”, “gt”: 0 } }, {

Hello! I’m running a database for my private education business. A single child can be enrolled for multiple classes (detailed in a field called “Classes Enrolled into”, and I want to be able to see each individual class when I group it by this field. Eg. If Student X is enrolled in Grade 1 Math and Grade 1 Science, and Student Y is enrolled in just Grade 1 Math, I wish to see this when I group: Grade 1 Math Student X Student Y Grade 1 Science Student X; and not: Grade 1 Math, Grade 1 Science Student X Grade 1 Math Student Y Any ideas? Appreciate your help guys! :slightly_smiling_face:

I work as a booking agent and I want to use airtable to email my runsheets for each of my clients. Currently I’m pasting my data into google sheets, which then formats it into a runsheet and I save a PDF of this and email the PDF, but its quite time consuming If I were to create a view for each client for their following weeks bookings, I’d like to have a way to email all records within that view to a select few email addresses automatically twice a week (or upon click of a button or something)

I’ve run into an issue with embedding an Airtable form into a website. The problem I have is the title of the form is not centered, and it is looking really weird with the centered elements I have on the page above the form. I have tried all manners of CSS inside and outside of the iframe tag but I cannot seem to affect this text at all. Does anyone have any suggestions?

Hello Airtable Community! I recently joined Airtable in hopes that it can solve my company’s scheduling dilemma. We offer high-quality IT training, so we need a solution that can schedule various classes for 7 instructors throughout the year. In addition, we need each course to display on the calendar per day it runs, on the calendar event, it should show: Course title, Instructor name, and start and end time. Then, we need to be able to track the instruction hours per instructor and per course. I do not have a programming background, so I think I am at a disadvantage setting up a complicated scheduler that is easy for others to use. Any recommendations? This is what I have so far: Sign up - Airtable I appreciate it!

Have a table I create records with using a form - since this morning after airtable was down I still haven’t been able to upload attachments. Have tried multiple browsers, iOS, have even tried uploading straight to airtable. Wheel just sits there and spins saying upload. Any ideas? Haven’t had any issues with my tables thus far until this morning. Thanks

Is there a way to sort by the count field after you’ve applied a grouping? I have items that are grouped by sales reps and the grouping header gives me a count and I want to sort the groups by count.

I work with a group that has multiple projects requiring voice actors. I am trying to set up one table where we list all our Voice Actors with contact information. Then we have separate tables for each of our projects that list the roles. Is there a way to use the column with our voice actors names as a drop down menu in our other tables? I would like to be able to just update the voice actors table and have it auto update the drop down menus in the other tables.

I’m new to Airtable and need to know if Read-only permissions include downloading photos that are attached in attachment field?

Hi All, Is anyone else unable to access Airtable at this time? I keep getting a “Service Unavailable” message when I attempt to go into www.airtable.com. Looks like the site is down. AS

Hello, Just started to use Airtable ansd want to connect it our Jira Cloud instance. I set up the Jira Cloud app, but seem only able to map standard Jira fields? Where I would especially like to map our custom Jira fields. Does someone know if this is possible, and if so: how? Cheers.

I’m building a base to track financial pledges, which will be paid over time, for our charity’s capital campaign. Have donors in one table, pledges (and payments) in another, and can use Rollup to calculate remaining balance for a pledge, but would also like to build a forecast that shows when pledge payments are expected. Some pledge payments are made monthly, some are quarterly, some are annual, and all (for the most part) have a specific end date. Anyone have a good example of how they’ve accomplished this, or ideas about how to create a forecast like that?

Hi everyone, I would like to setup a simple change tracker where I can add changes manually. On table should have all my website url for example url.xy/page1 url.xy/page2 url.xy/page3 In another table I want to track the changes for example Image added on url.xy/page2 How ca I connect those tables that it diplays the cahnges I made in the first table?

Hi guys, I need please help in how to insert a logo in the block Invoice generator. Can someone help? Thank you

i need to round up the following formula SUM({Screen Area:}/result) what i require is any value between 0 to 0.49 to be 0.5 and any value to be between 0.5 and 1 to be 1 and so on up . so were constantly rounding up by the nearest 0.5

Define the Snowflake Cluster?

I submitted an app on Jan 25th and have heard nothing. Just wanted to check if this is normal compared to other people’s experiences?

Hey everyone, So I have a table that runs off a daily manual .csv import from Jira. The primary ISSUES table is where I import the daily .csv into. There is a field on that table called “Log Work” where a string of time-tracking information is logged. The string looks like this: time-tracking;08/Feb/21 8:46 AM;addon_is.origo.jira.tempo-plugin;9000 I have this field set up as a linked field to the LOG WORK table. The behavior that I would like is as follows: Import .csv → populate Log Work field → this creates / updates LOG WORK table with entires The problem is, when the import takes place, instead of creating one record for the string, the Linked Field cuts up the string into several pieces, so it looks more like this (brackets indicate a separate record) [time-tracking] [08/Feb/21 6:29 AM] [addon_is.origo.jira.tempo-plugin] [3600] It creates these four records rather than one record. I believe this has to do with the semi

Hey there. I wrote a basic IF statement that checks content of some records. This was the IF Statement IF(A,A,IF(B,B,C)). Now I need something a little more complex, I need to check if variable A is an email address. I am thinking something along the lines of IF(FIND(’@’,A),“Hyperlink to A”,IF(B,B,C)). So I was wondering if this is getting to complex for the formulas of Airtable and I might just need to run a script that checks for the email if it is then sends the user to a place that creates and email for them to fill.

Hi, I need some help… i have this table… And this other table linked to the table 1 I filter the field “Tipo” whith “Does not contain DPN” , but it filtered all fields… I want that for example in the first register show me two “Auditorias” I hope I could explain mysel, and sorry in advanced for my english…

Using AirTable we have created a library of several hundred resources on a certain topic which we want to share on a website. The AirTable read-only link works perfectly on a computer, bringing up the whole library and then allowing viewers to search, sort, filter, download, and view a full record according to their needs. However on a mobile device, people can see all the library entries, and tapping each brings up each the full record, but I was not able to figure out how to activate the sort, filter and search functions. Can anyone help?

I am trying to use the Airtable software to organize files. I want to utilize the Status method in the category, along with location and automation. However, I don’t want to manually continue clicking just as I find another 300th file. Is there a way to automatically change the status of the categories without manually individually selecting it’s options?

Hi Airtable community! I am trying to collect ideas from people. Currently, I have a form embedded on a website and a gallery view of the responses embedded below. Some users said that instead of filling out a new form to add a new idea, they’d like to respond to an idea submitted by someone else that they can see in the gallery. What airtable features or apps might allow this functionality? Ideally, there would be a conversation thread. Thank you!

Shortcuts to switch between views/bases/tables is potentially a great productivity boost! When using a shortcut after successfully switching to the desired location, the keyboard does not automatically focus itself on any of the records. Is there any way to focus on any of the records using the keyboard? One way is to create a new record and then delete it using Keyboards shortcuts. However, this is cumbersome.

Hello Folks, The batch feature here works perfect and it creates 50 records in milliseconds and goes on till it finishes the total number of episodes ( EPS ), I have a tiny issue with the numerical calculation, it doesn’t work well with pattern adds to the date So if you run this batch script to add 7 days to each date the result is not accurate const importTable = base.getTable(“Titles”); const importQuery = await importTable.selectRecordsAsync(); const episodesscheduletable = base.getTable(‘Episodes Schedule’); const episodesScheduleQuery = await episodesscheduletable.selectRecordsAsync() const episodesScheduleNames = episodesScheduleQuery.records.map(x => x.name) let contactsToMake = ; for (let record of importQuery.records) { let myDate = new Date(); let RowsToCreate=0; RowsToCreate= record.getCellValue(‘EPS’) ; myDate = new Date(record.getCellValue(‘Release Date’)); ``` while (RowsToCreate>0) { myDate.setDate(myDate.getDate() + 7);