Other Questions

Hey all, can anyone say if it is possible to export to excel sheet and have the links for the photos made clickable inside the excel sheet. For now, I understand that the links comes as a text and if you take more than one photos for each line item it comes as a single text. Can I make this split into two columns or at least make it clickable? Thanks in advance.

I’m looking to write a formula that notifies me if there are duplicates of a certain field. There are other unique values in the spreadsheet, so I’m not looking to merge or delete them, but I want to be notified if a certain cell is not unique. I do this in Excel with: =COUNTIF($B$2:$B2, B2)>1 Is there any manner to do this in AirTable? From what I’m seeing, lookup and rollup options that have been suggested in the community require an additional table and I’m looking to do this from the same table. Thanks

The Situation: I want to have a single form with multiple task options and the questions to change in the form accordingly. For ex- If X chooses task Y then the questions in the form should be related to task Y. Similarly if X chooses task A, then questions should change based on the task picked. Having multiple forms/tabs for these tasks is not helping much. I know I can have different task options when I choose “multiple select” but the changing of questions is my need.

Hello, is it possible to create a script that automates an application I already have? Essentially I have an application that will convert a URL to an attachment, but would like to have it run on a script instead of having to click the button multiple times a day to get it to run. Code for the application currently is: let settings = input.config({ title: "Convert URLs to attachments", description: `This script will download all attachments from a URL into an attachment field. The source field can be a URL field or any text field containing a URL. Each cell should only contain a single URL.`, items: [ input.config.table("table", { label: "Table" }), input.config.field("urlField", { parentTable: "table", label: "URL field", }), input.config.field("attachmentField", { parentTable: "table", label: "Attachment field", description: "URLs will be downloaded into

Hello there, Thanks in advance for your time reading this. We do have a database where we integrated the app Kuovonne which provides a formula for a pre-filled feedback form. We can use a specific link/URL that we send to the person who should provide their feedback related to a specific record. Unfortunately the feedbacks show up in the same database, so we have lot of duplicates. Do you have an idea how we can collect them in a different sheet in the same database? Thanks a lot for your help! Reg. Sabine

I want to use AirTable for Workflow (Quotation > Process > Archive) + to get Product list from same base. Because of Record limitation per Base (we use ~ 4000 records per year) - the only way is Pro Plan (50.000 per base)? Or I can go with Plus Plan (5000 records per base) using multiple Bases for collecting data from many years? In example one Base could be for Processing, other Bases for Archive (each for specific year). And for each product type - own Base. Is there any way to automatically extract just records with product type “Book” to Base “Book”?

I feel like this question has been asked by multiple users, but I still find myself confused. Here’s what I’m trying to accomplish: A content calendar where the first table is sort of an “overview” with status, series, episode number, etc. linked to multiple other tables which include different types of content. I say multiple tables because different types of content have different fields. For example, a blog post in classic list format is going to have an intro, list items, and conclusion. Whereas a detailed case study blog post will have vastly different fields. So - I have multiple different tables, each containing a unique set of fields for that type of content. I would like to be able to pick records from any of those tables for my linked record on the overview table (which is the table where I order episodes and update the status of content).

Hi Airtable community, formula specialists! How can I use: A fixed start date (e.g. 07/15/2019) A #-of-days to execute estimate (e.g. 7) WORKDAYS_DIFF()… to generate an “Est. Delivery Date” that adds a number of days to the start date, treating weekends as “unavailable”? The acceptance criteria here would be that the forumla returns “07/23/2019” or “07/23/2019 12:00” is fine. Bonus if the formula can take a decimal rather than an integer for “# Days” for the purpose of supporting half-days. (I’d never get more granular than half-days.) I’m going to be trying to create this formula myself, but thought the community may want a crack at it, too. Thanks!

Hello everybody. I’ve been working with the API and I need the formula result to be type string only. I tried CONCATENATE, &, T(value) All return number or string. I would really appreciate your help. Thanks.

Hello I’m trying to use air table to keep track of the production of limited edition objects. For instance, my table is a limited edition of 30, numbered from 1 to 30. When I have a new order, I would like to be able to affect one of the remaining numbers to that order. For instance, if I have already sold 5 tables, numbers 1/30 to 5/30 cannot be selected anymore, and I should be able to pick the next remaining available value, in this case 6/30. Or even better the table could auto fill it for me. How could I achieve this? Thanks

Hi all, I’d like to know if there is a way in a Scripting app to check if the script was called from the click of a button in a column or via the Run button on the Script app itself. My use case is that we ideally want one script that can be used either for a single record (the button column scenario) or an array of records (which we would fetch & manage in the script itself). Basically the first if statement in the script would check this, and then the code would branch accordingly. Sample code to demonstrate the idea: let table = base.getTable('Orders'); if ('button was clicked') { // <-- How to make this check?? //process that row only let record = await input.recordAsync('Pick record',table ); } else { // process records from a table or view etc. let records = await table.selectRecordsAsync(); } Thanks in advance for any suggestions!

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