Other Questions

Hello, New airtable user designing a way for employees at a small business to exchange non paid time off. We want to create a “time bank” style exchange, were employees can offer up shifts of different lengths, and other employees can claim them. When you claim an offered shift, you contribute to your balance in the time bank, and when you offer up a shift, you use your balance/credit. I am having trouble figuring out how to set up the formula, though I know it should be simple SUM (hours earned minus hours used). Do I need to put that formula in a specific view of the base? I’m able to set up a column to display that formula but I don’t know how to integrate that with other data I want to include, including the dates to be swapped, employee name, etc. Any advice would be very useful.

I have a table in which I track each time I contact a client. I also have a formula that uses the date contacted and cycle frequency to determine the next date to connect with the client. I also have a view that filters the view to only show future “next contact date.” I would like to create a way to show in this view only the clients I need to contact within the current 7 DAY week. I can’t come up with a formula, and the filter options for the view don’t provide a way to do this. I was thinking a separate column with a formula that would only populate if the “next contact date” column had a date for the current 7 DAY week. Maybe a checkmark and the view can be filtered if a record has a checkmark. I’m stumped and would love some thoughts.

I wrote a formula that converts options chosen from a multi-select list into a string and appends the responses when “other” is selected. I want to take the resulting comma separated string and convert them into links to connect to other records. Is there any way to do that without disrupting the formula? Or is there a way to continually copy the contents of column A into column B while being able to link column B to other records?

Hello! Im trying to build a question pool where people should answer with a value on a scale. Like the “opinion scale” in typeform or “linear scale” in google forms. I seem not to find a solution on this. The problem lies in the description of the extremes: What I tried is to build the extreme’s description into the question itself (in the format of “question? 1:low extreme answer 5: high extreme answer”), but with these they just seem to be too long for the cells to fit. I inserted them into a new base, converted them to become column headers (by importing a copypasted set from a sheet). So the looks like this: and then realized part of the text is trimmed. Here, in the header already. So obviously if i generate the form view, it will be trimmed too. Tried updating them manually in form, but changes done in the form view are not reflected in the grid view that i consider the “database”. Updating them manually without changes reflected in grid is no solution, I need a way to generate

Hi there. I have a work tracker and a table lifting all of my tasks. Next to the tasks I have a Single select column listing the status of teh task as ‘Completed’ ‘In progress’ or ‘Not started’. I would like to add an extra table purely for Completed tasks. and set it up in a way so that when I categorize a task as ‘Completed’ it automatically feeds through to the ‘Completed tasks’ table, and then hides it from the main ‘Tasks’ table. Please could someone explain how to do this? I’ve done this once before but can’t remember how. Thanks

Hi, New to AirTable. I’ve got tables that look like: Courses (links to Units) Units (links to Modules) Modules (have a field called Video) A Unit will have one or more Modules. I know how to show Videos for a given Unit via lookup of all the Modules for a Unit. A Course will have one or more Units. What’s the best way in AirTable to show the Videos for a Course? Thanks, Daniel

Hi! I created 2 tables - Table 1 - Input from a form I created - Including a tracking number and quantity actually received Table 2 - Download from a website with the tracking numbers and quantity shipped I wanted to link these two tables with the tracking number field to then be able to create an additional field that would calc how many items I had outstanding. When I go to link the tracking numbers between the tables - The data in BOTH tables for tracking number columns totally disappear? I feel like this is pretty simple… am I missing something basic? please help!

DTS-07232017 Hello, RE: Scroll Bars Not Functioning Scroll bars are not functioning on mobile desktop web browser mode. Whether in Chromium or FF neither scroll bars are functioning. The cannot be accessed. So there’s no way to scroll horizontal. In the Airtable mobile app, the mobile is entirely limited, dysfunctional making it useless. So obviously Airtable wasn’t developed with mobile coding and is restricted, to laptops. This is irritating, to be on mobile technologies, on the road working on a database build only to find out it needs a laptop! What pisses me off is at this point I might as well use MS Access. Can you fix this or not? Thank you, MFAS

I am creating an IF formula in the Primary field so I know which apartment my maintenance manager was in, doing what, on what date. I have a table that breaks it down by per suite so it is organized. I have this as my formula: Suite & “: " & Comments & " - " & IF({Date Completed}, " (” & DATETIME_FORMAT({Date Completed}, ‘ll’) & “)”) I copied and pasted it from a sample but it puts the date in brackets. I don’t want brackets around the date. I cannot figure out which parenthesis to eliminate. I have tried different ones but then I cannot save it due to errors in the formula. Is there a way to do this formula so the date is not in (bracketed)?

Is there any way to hide the view selector on the left to gain screen space?

Anyone have any suggestions as to why I am not receiving a notification email when a form is submitted to airtable? After a form is submitted, a record does get created, it’s only the notification I don’t get. Also: I do have the “email me at xx@xxx.com” selected on the form, and I have checked my spam folder, but nothing there. Any advice?

Hi all, I created a survey in the form version and send out the links for those to complete. As with other surveys I’ve made, I should see the responses coming in in the Grid version however this isn’t occurring. I am not sure what troubleshooting I could do to get these responses visible. I completed the form, as a test, and that response is also not appearing. Any support or direction is greatly appreciated. Thanks, Samantha

Hello! Is it possible to customize connections within cards on the same table? I have a link setup between two tables, but would like to customize those links to only match to certain views. For example, on one table - Jobs - I would like one card to connect to a specific view on another table, but on the same table, I’d like another card to connect to a separate view on the other table as well. Thank you in advance for any help you can provide!

Instead of a dropdown menu for my Views, I have a list that shows-up and stays open on the left side of my spreadsheet until I get fed up and I click on the column to close it. Is there a way to put it back as a dropdown arrow like it was before? I don’t even know how I got it to change in the first place. All my other colleagues have an arrow and I have a box that says Views

Hello community, I was wondering if it is possible to change the password for a shared base. Example: https://airtable.com/shrHqb9XeEZAPA17G. If not, is it possible to regenerate a new share link via API? Thanks, Mauro

Heya ! In Chrome, I managed to change first day of week in calendar views by setting English (UK) as chrome default language. That’s something :smiling_face_with_three_hearts: . But when using the Windows app (seems based on a clean light version of Chrome, perfect for my needs :kissing_heart: ), I’m stuck with Sunday as first day of the week. Limitation of the Windows app ? Or did I miss something ? Happy AirTabling !

Is it possible to view full PDFs (that are stored as attachments) in the browser (beyond “preview”)?

How do I link records through Zapier? If I get the ID of both records how do I link then together?

Hi! Is there a way to present content from 2 different views onto 1 page designer block? Either through linking or another method. If ANYONE knows how to do this, the next rounds on me!

I am trying to upload several jpgs to one record. I use ‘Gallery’ and drop files in bulk to the plus sign bottom right. They are pages from a book and therefore in a sequence. The files are numbered as jpgs in a numerical sequence. Why can I not have the viewed output remain in the correct sequence? Why is the output always reversed with the last item first? How can I fix this? Many thanks if anybody can help!

I’m developing a WordPress plugin that backs up your entire Airtable account (as JSON, CSV, and optionally downloading any attachments). I intend to release it as Open Source when it’s done. It’s not finished, and won’t be for a few months, but I’m interested in seeing how it works for others. Because it’s still in alpha stage, and I know there are security-related bugs, you’ll need to have a LOCAL web server with WordPress installed (i.e. one that’s not accessible on the internet). If that’s you, and you’d like to help, please get in touch.

Can anyone provide some input on how I would go about creating a rule between tables? In my situation, I am attempting to pair students to jobs available. I have the two tables linked, but would like to set a rule that once a student has been “assigned”/linked to a position on the other table, that the move from the “unassigned” column to the “completed” column. Another way that this may be able to work is if there is a way to limit the number of times each record can be linked. In this situation, we only want one student to be allowed to be linked to one job. Thank you in advance for any help you can provide!

I’m building a social media content calendar using Airtable’s Digital Content Calendar template. I created Sections for each social media platform, but I haven’t found a simple way to link the actual posts per platform. I’ve been logging the posts as Records and then linking them to the Section. When I want to share the same post across four platforms, but at different times on the calendar, I’ve had to create four Records - one per Section/social platform. My goal is to see when they’re all scheduled in the calendar view, but it seems redundant to make four Records of the same posts for it to cover all four Sections/social platforms. For example, I’m sharing the same post on Twitter and Facebook on two different days. I would like to only make one Record, but link it to both Twitter and Facebook and have it show up in my calendar view on two separate times. What’s the most efficient way to do this?

Hello, brand new user, here! :slightly_smiling_face: I see the ability to edit permissions of a field so that only specific users can edit a field; however, is there a way to set the permissions so that only specific users can see the field to begin with? We want to include some sensitive information in our database that can only be seen/accessed by certain employees. Thank you in advance for any help you can provide.

Is there a way to automate this system of numbering new records: Q-19001 - “19” is tells me it’s from 2010 and then it’s followed by a 3 digit autonumber. Q-20001 - that’s the first record for 2020 and the 3 digit sequence resets itself. I have two questions - Which formula command “extracts” the 2 digit year (YY) from a “date created” field for example? I can’t seem to figure that one out. I am sure it’s easy… How do I set the autonumber field as having to have 3 digits - and is there a way to have the auto-numbers reset every year? (Someone had suggested to manually adjust the formula at the beginning of each year by subtracting the highest number of last year - that’s certainly one way of doing it.) Thank you so much in advance.