Other Questions

I am working on automating a workflow that includes dates. I have a Task Specifications Table that defines the phase of work, the different tasks for that phase and associates estimated time frames for each task. For Example the first phase would be Onboarding and it would contain 4 tasks. So when a new person enters the system and I select the check box it adds four records to the Onboarding process table. From the creation date I wanted to be able to generate due dates referencing the estimated time frame from Task Spec Table. The tables are linked by the task name and subsequently looks up the estimated time frame. I have tried DATEDD({TaskName},+{TaskDuration},‘days’) and I get an error. If I type in the number from the Task Table associated with TaskDuration: DATEDD({TaskName},+3,‘days’) then it works. Any thoughts?

Hi Airtable Community, I’m trying to build a tool that will automate a complex schedule process. I run a music institute each summer, which runs for 5 weeks, with 35 musicians involved, all collaborating with one another. Musicians are assigned to small music groups, and are scheduled weekly for a certain amount of instruction, sometimes with their music groups, sometimes individually for lessons. They remain in the same music group for the entirety of the 5 weeks, but their coaching/instruction time varies week to week, in a pattern determined by our program director on a weekly basis. We’ve been utilizing macros in Excel to keep music groups together and alert when there are scheduling overlaps and coaching overlaps. But, I’m hoping that perhaps AirTable could help us automate some or more of the process. Can anyone help? Thanks in advance.

Is there a way to create a duplicate record button in a submission form? For instance, if a client is submitting a request and wants to create another request nearly identical, is there a way to set it up so they choose duplicate and it submits the form and creates another duplicate that can be changed with a new date for instance but rest of the previously entered information remaining? I hope that makes sense.

I don’t know if this is possible in Airtable, but I thought that I would ask anyways. In the screenshot below, you can see that we have a travel itinerary which is grouped by country name. The groups are sorted alphabetically by country name. However, we would actually like the groups to be sorted by a completely different field altogether. We would actually like the groups to be sorted by the “earliest start date” within each group. In other words, we want each group to appear in chronological date order (like an actual chronological travel itinerary), as opposed to alphabetical order of the country names. Is there any way to accomplish this in Airtable?

OK, with the risk of this being too big a question: I am working on porting a pretty massive scoring system of grant applications. Each application has let’s say 100 questions, each ranging from 2-15 possible answers (some multiple, some single select) and each answer is worth a certain number of points (integer). I’m thinking one transparent way to do it without massive scripting (which may be what we end up doing), is to have each answer in a linked table, and in that answer table, have a column that is the point value. Then use roll-up to calculate a score (except where the score has to choose the highest scoring component, which i can do with a formula). HOWEVER - I don’t want to have a different linked table for each question. SO - I can use the ‘Limit record selection to a view’ option to narrow the options for each question. HOWEVER, this would result in hundreds of views to cover every question in each of four program areas. Maybe I could break up

Hello guys. Can you help me with a question? We assume I have: Table 1 | Name | John Table 2 | Office | Deliveryman Now I’m going to create a link for [Name: João] into Table 2: Table 1 | Name | Link Cargo | João | Deliveryman Table 2 | Cargo | Link Name | Delivery man | John What I want at the moment is that only [Name João], be included in Table 2. This would solve the whole problem and not create a link in Table 1. But so far so good, because I can hide the Link Title of Table 1. My difficulty is that when I delete [Link Name] from Table 2, there are always scattered and old links that are not automatically deleted. In my example, [Link Cargo] in Table 1 will remain there, even though I already deleted [Link Name] in Table 2. Is there a way to delete links from other tables automatically, when I delete only 1 link? Or at least manage those links that no longer serve me? Thanks!

Hello all. So I have been using Airtable since Christmas and it is really the answer to most of what I need and I am already excited about the functionality of Airtable and how it is going to help us. Quick back story - I work for an advertising agency as a Video Editor and I am using Airtable to create a database to monitor a number of things, including the projects we are working on, which hard drive they are on and how big the projects are (amongst many other features I have found on Airtable). So far what I have is one database, which has a table which monitors the projects - location, size, external links, etc - and another table which monitors the hard drives we use - so this records the data capacity, how much is used/available etc. I found a really helpful article to help me calculate the data available on each drive here (Forumla to add Hard Drive sizes)

Airtable should really allow Owners and Creators to limit the possibility of Editors creating non-personal views and sharing content. If I create a table that has specific views, I would want editors to only be able to edit records and not create new views that will only confuse my team. Also, if I didn’t create a shared view of a table, I don’t want editors to able to do so. This is important to maintain the security of my information.

I’m trying to access a base created by a previous contributor but can’t access it. Is there a way to recover it if I have the link?

when using my Galaxy S20 Android device i cannot @mention my colleagues , can some one help me in relation to this please

Hey everyone! I need to enable to Scripting app but my Enterprise Admin says he can’t access the Enterprise Admin Panel. If I understand correctly, he needs to go to the “Enterprise Admin Panel”, then go to “Settings”, then switch off the “Disable development of custom code” off and then I’ll be able to install it. For some reason, when he tries to install the app it says he can’t, even though he’s the admin. Am I missing something?

I wrote a script to create a record, but I’m trying to link it to another record (Customers table) when I create it. I have the Customer Name and ID field value, but AirTable doesn’t seem to like the format I’m using for the ID. I’m getting the error message, “P: Can’t create records: invalid cell value for field ‘Link To Customers’. Cell value has invalid format: must be an array. Linked records field value must be an array of objects with property ‘id’ corresponding to linked record id.” I’m not sure what format AirTable wants to see for the value of field ‘Link to Customers’. Thanks.

I need to send an email every day at 4am to a list of tagged employees. Is there an automation or app extension that I can build into my airtable to pull their emails and send them an automated email each morning. Is this possible to build out?

Is it possible to automatically forward a list of all new records within a given week? I would like to send a weekly update showing only the records that are added in the past week. How can I do this?

Hi all, We are trying to transfer our profiles from our previous interns to our new ones. We don’t want to make new profiles because we like the accounts these profiles own. Does anyone know how to do this? Thank you.

How can I display other fields in a calendar View besides the Unique ID. Currently I only see the Unique ID on the calendar in a new calendar view. I do have a date field in the base that uses a date & Time. The Unique ID shows up in my cal view. In order for me to see any useful info in the calendar view I have to concatenate a few fields together for the unique ID field, only then do I get usable information in my calendar view. There must be a way to select a field to display in the calendar, but darned if I can find it. A simple explanation of what I am doing is…I have 20 people who can work a shift, and 3 shifts a day. One table with the shifts and one with the employees. shifts could use anything for the PK, employees I use Employee #. To assign a shift to a employee I simply select the employee # in the shifts table that links back to employees. But I can only see the unique ID or a concatenated vision of it in calendar view.

Has anyone gotten Vimeo video links to preview using the URL Preview App? They do not load for me. This comment (Media Field generating a duration in a new field - #6 by ScottWorld) mentions that Vimeo links from only paid Vimeo accounts can be previewed. I do have a paid Pro plan on Vimeo but my links still do not preview. Airtable support article about the URL Preview app talks about getting a “rewritten” URL from Vimeo. I wonder what that is? Here’s what it says: "Vimeo URLs Step 1: Generate share link in Vimeo Step 2: Use share link to copy rewritten URL" Thank you for your help!

Hello, is it possible to move/export a tab from one base into a different base within the same Workspace without having to download the CSS and losing all of the attachments, formatting, etc.? And if that’s not possible, is it possible to merge two bases? Apologies if this is basic or has been answered, I could not locate any previous discussion on it. Thanks!

Hello Airtable Community ! I have a very simple question but can’t find a solution. When i create a new line in a Table, i want my status colunm (single choice field) to be the “live” by default (the first choice in the single choice field)

Hello Everyone, We have a QR code tenants can scan which will redirect them to a form to fill out. We are not really fans of the fact the form is in a airtable.com/blabla website instead of one of ours. The QR code is already printed and scattered around the community and it leads to an airtable.com/blabla website. Can we redirect the users after they scan the QR code to a custom website which has the form held on the airtable.com/blabla website? Thanks

I am totally stumped as to how approach this and looking for advice! We have an Airtable form that members of the public submit to ask for help from our nonprofit. The form creates a record in the table where we keep track of requests and our responses/outcomes. We need a way to identify and “match” records from the same household so we can track duplicate entries and multiple requests from the same household over time. One complicating factor is that the name, street address, email, and phone number fields are all entered manually by the submitter, so they are rarely identical for all records submitted by the same person (e.g. email address may be capitalized in one instance and not in another). Also, not everyone shares a phone number or email address. I’m attaching a screenshot of the form below for context. I did configure a Household ID field that does a mediocre job of assigning the an ID to records from members of the same household, but it’s definitely n

Hi peeps I am new to Airtable and am starting to get the hang of counts, etc which I use to add up the number of items in a field. The fields are a form completed that will drop in a linked field from another table. I can add those up per row and get a sum per user like so: Each line is the completion of a form by a user with them adding their details each time. What I want to to now is either change the form to: A. add the same item to a user to create one line and one total B. subtract the sum of all the items the user added from a set total So if there are 50 items and they have gone in 3 times and chosen 15 over the 3 times, the total would reflect as 35 somewhere. This can be a single row or at the top of the sorted list, I dont mind. We just want to get all users to complete all tasks. Does anyone have any suggestions? Open to linkin

Hi all! I have a base of student information that needs to be updated every semester when new students enroll. I get an excel spreadsheet from our registrar with the student information on it, but I’d like to pare it down to just the unique records before I import, or have Airtable only import unique records. I just dumped everything and used the Dedupe app last semester and it took me several hours to tidy everything up, so I’m not doing that again. Is there a quick way to only import unique records into Airtable?

Hello everyone, I found a way to get a nice view for my attendance tracking for my workers. However the process to enter the data is tedious. In the end, I want to see a view groupe by dates, then by attended / absent, and then by type of workers (foreman, worker, project manager, sub contractor etc.) Here is the view I came up with: However, the way I came up with this view is to add a new field for every worker on a specific day and this is a lot of work if I have 100+ workers on site. Is there a way to make this easier? I have a second table where I can toggle a worker to be either active or layed-off. Is it possible to automate a daily copy / paste of the active workers and then I can just go through the list and specify if this worker is present

I’m a researcher and I deal with biospecimens. One of the major tasks is to process and store specimens. A standard arrangement is to place samples in a storage for long-term keeping. I’ve drawn out what that looks like. Both the samples and the storages have multiple hierarchies. How would one model this in Airtable?