Other Questions

I have a table that I’m using to track instrument checkouts for a high school marching band. It pulls from two other tables (one with the student information and the other with the instrument information), but I also enter data directly into the form, namely the date the instrument was checked out. I want to automate the step of filling in the school year field when I enter the date that the instrument was checked out (see screen shot for what I want it to look like). The formula I used is this IF(IS_AFTER({Date Checked Out},6/3/2021), “21-22”) but it only gave me an error. How would I change the formula to get the result I’m looking for? Alternatively, because the school year will only be “21-22”, I could just have that field pre-populate with that value when I create a new record, but I haven’t been able to figure out how to do that either. I appreciate any help you can give me! Thanks

Hello everyone, I am facing an issue with airtable CSV export. Every time I export, I see the first column’s title to be a string (i.e. I see quotation marks in the column’s title). I don’t wish to add an empty first column or to edit manually every time I export. Any solutions you can suggest!? Thanks tons

Is it possible to create or copy a table by using api in the same base?

So I found this helpful article https://support.airtable.com/hc/en-us/articles/221104988-Conditional-formulas-with-emoji and used the IF({Completed} = 1, “ :white_check_mark: Done​:white_check_mark:”,IF(IS_BEFORE({Due date}, TODAY()), “ :alarm_clock: OVERDUE​:alarm_clock:”,“ :running_man: In-progress​:running_man:”)) AND IF(Completed = 1, “”,IF(IS_BEFORE({Due date}, TODAY()), “ :alarm_clock: OVERDUE​:alarm_clock:”,"")) Formulas. I am wondering how I could add a date range and have a DUE SOON stage. (instead of in progress, but conditional upon it being due within 3 days)

Is there way to have the button field empty if the record doesn’t have anything in the correlating source field? Ex: I have a “OPEN LINK” button for each record, from each’s social link field. But some records don’t have a social link - and they still have a button (even though it’s a different shade). I want no button for the records without a social link (or whatever source field/URL.)

Is there a way to create a chart based on a multi-select column, but display only certain tags from that column? The specific case - I have an x-axis that is based on a multi-select column “Territory Availability” with 245 possible tags representing global regions, I’d like to be able to create a chart that would show a smaller set of these tags - 25 specific regions. I’ve tried to create a separate column which the app could reference, but the original column is automatically updated by a data feed on daily basis which has complicated other attempts to isolate the 25 regions I want to represent.

I’m trying to use the web clipper app to get the company URL from the button “VISIT WEBSITE” on any LinkedIn company’s profile, and I just can’t seem to figure it out how… I already manage to get the “VISIT WEBSITE” text using the “Text content by CSS Selector” option, but when I try to use de “HTML attribute by CSS selector” option (using the ref attribute), I get nothing in return. If someone can show me what am I missing, or konws about a workaround to solve this, I’d really appreciate it. Here is a screenshot of what I’m doing (without success), de CSS Selector works to get the text “Visit website” though. And I also used the selector “#ember356” with the same results (works with “Text content by CSS Selector” but doesn’t with “HTML attribute by CSS selector”). Thanks in advanced!

I have a Tasks table, which has a Status field (Started, Done, etc) and a multipel link to projects table. In project table I have the lookup field, which shows me links to all tasks in that project. I can enter tasks here and also click to see task status, etc. This is perfect. But in the tasks table, when a task is marked as Done, I just want to hide it from both tables. I have tried multiple formulas and rollupfields, which does what I want but they are just a text list of tasks. I have also created a view hiding “Done” and then filtered that view in the lookup, but nothing happens. Example: This record has all tasks marked Done, which the rollup field sees. But the linked field does not:

We need to be able to build a calendar from multiple tables to track and manage our Brewery Schedule. We have tried with Zapier but the time delay is an issue and it’s not a true integration (when you update AirTable it won’t update the Google Calendar in real-time). I’m surprised there aren’t more people that require this feature- it’s a key limitation for us. Will the new Blocks feature help, or is there any other way to accomplish this?

im working on project having multipule bases. im facing an issue that i want get a data from table of one base and store it to a table with different base. i searched in metadata api ducumentation, i submited a new form Airtable Metadata API Request Form but didont found a taken. how to resolve this issue? how to do registration?

Need help on Webclipper since it is not working on Wayfair but works on other sites

Hello! I am trying to put together an email digest that shows start and end times that are synced to my base from Google Calendar. My Google Calendar is set to Alaska time, and the times show correctly within my base. However, when my email digest is sent, the times have been converted to UTC. I have seen the threads about dealing with this through formulas, but because my dates are synced in I can’t modify those fields. Does anyone know how to address this? Thank you!

Hi there, new to Airtable but familiar with relational databases. We want to import a CSV on a regular basis and then from the mapped data, have it fill data that is already in a lookup table. The specific problem we want to solve is this: We have a CSV file with a list of courses and instructors associated with the course. If the course in the CSV is SOWK 600 we want to import into our Fall 2021 table and have it link to the Courses table and the faculty table. Can that be done? The relational database side of me says it can but i cannot find the appropriate terminology for Airtable.

I am using Integromat to build some fairly complex summary reports. Things are going well - but Integromat cannot seem to serve up info from Linked Record fields - instead - shows some sort of alpha-numeric ID tag. A lot of my data is represented by linked records, and I’d like to not have to make duplicate fields that strip them down to string text. I have an Integromat ticket in, but curious if anyone here has run into that. Was excited to get Integromat approval from our IT dept, and was hoping it would be the silver bullet that it seemed, but this is a major issue… Thanks!

I’ve got a few records for a different project that are displaying in both Gallery view and in Page Designer exports. I made sure to filter only those for the correct project but they are still displaying. Is there something I’m missing?

We save a lot of documentation in Airtable, mostly spreadsheets and PDFs, using the Attachment field type. Oddly however, one document has no download link, and we just get an error message saying “Attachment download URL is unavailable”. Has anyone seen/resolved this before? Is this recoverable?

I need help applying conditional logic to a ‘send email’ button. I’d like for the button to only be active for records that indeed have an email assigned. But right now ALL the buttons are active even if there’s no email address on the record. See this screen shot: Anyhelp is greatly greatly appreciated. This is the formula I have currently in my button: “https://mail.google.com/mail/u/0/?view=cm&to=” & ENCODE_URL_COMPONENT({Email (Primary)})

Hello, I have a problem to deploy custom app. The problem is executing the block release command. Tried with block version 0.0.63 and 0.0.64. Also with node V12 and V14 ERROR: building copying package.json file copying package-lock.json file installing node modules [npm] [npm] > core-js@3.14.0 postinstall /private/var/folders/w6/sybzmyjs6j76k5hs07x3g2z40000gp/T/airtableBlocks/build/1623329449157/transpiled/user/node_modules/core-js [npm] > node -e “try{require(’./postinstall’)}catch(e){}” [npm] [npm] added 79 packages in 1.263s transpiling and building frontend bundle uploading build artifacts failed to upload build artifacts Error: read ECONNRESET at TLSWrap.onStreamRead (internal/stream_base_commons.js:209:20) { errno: ‘ECONNRESET’, code: ‘ECONNRESET’, syscall: ‘read’ } NOTE: The problem happen both when I try to deploy my own app as the default “hello word”. building :white_check_mark: copying package.json file :white_check_mark: copying package-lock.json file :white_ch

Current situation is as follows: user signs up through a (Airtable) form on our website and enters a table and gets a record ID. In the onboarding process that follows we would like to allow our users to change/add data to their specific records in our tables. Can anyone please help us figuring out how we can automate this process? Currently we have to manually add the asked information in the right table. Thank you!

I am trying to create a survey. And the survey has 4 options for each question A B C D. For A its 1, B is 2, C is 3, and D is 4. Each is summed for a total across all the fields in a record giving a total for each record. What I want to do now is count the number of As, Bs, Cs and Ds across the record and I can’t seem to do that ;-( Should be something like sum if Field 1 = 1 and Filed 2 = 1 and Field 3 =1 … And then another with Sum if Field 1 = 2 and Filed 2 = 2 and Field 3 =2 … And so on for each record so I get the total number of A, B, C and D. But I cant seem to do that does anyone have any idea how I can do this? Thanks in advance

Hello, i want to see only those strings which have collaborator’s comments in “Activity”. Another option is to restrict adding comments to “Activity” for collaborators. Is it possible to do using an airtable functional or any of apps?

Hey Everyone: I have a table that houses 260 records. Each record represents 1 Song. I have a rollup in that table that has every date I have practiced that song in my set lists. Set lists are individual records that track each show and adds the song in the position played. I want to take that list of songs and the date rollups and create a new table that has all the songs listed one by one by date played. I know moving forward I can do this by automation as the records are created, but how do I do it for everything in the past?

Hey, I want to export Airtable base in .xls or .xlsx format with images pasted inside the cells (like images, not links ) Is it possible? Please share if there is anyway. additional; I have Airtable Premium Thanks

I have some PDF files in an Attachment field. I need to generate URL links to the airtable preview of these attachments. I know it can be done (the URL links appear with as dl(dot)airtable(dot)com/.attachments/). How do I generate these URL’s

I would like to have a gantt on the report I run using Page designer. At the moment I am taking a screenshot of a gantt view and uploading the image as an attachment. Is there a better way? This seems unnecessarily cumbersome.