Other Questions

Fields populate in grid format, but not in form format.

Hi, I’m fairly fresh out the box with Airtable. I am trying to fill an embedded Airtable Form with a Webflow CMS Item so that when the member uploads an image in the form Airtable also captures their member ID. Anyone else managed this? Thanks in advance!

I was given the free Creator plan when I signed up, which had everything I needed (I never got to see the difference between the regular free plan and the creator plan). I then invited my colleagues to join a workspace and they were given the creator plan individually. BUT when we started collaborating we got the PRO free trial. My question is: what happens after the trial? Do we all get the benefits of the creator plan, or will we go back to the regular free plan? What is the difference between the regular free and the creator plan? We are a small group, so I am not concerned about usage limits or even automations or apps. I am concerned about losing views or the ability to color fields or group by fields. Does that go away when PRO does (assuming we don’t go back to the creator plan, just the regular free plan)? I don’t want to lose functionality on everything I just built over the past couple of weeks.

I’m trying to obtain the difference between 2 dates (going out 2 decimal places). I did format the result as a decimal going out 2 places. However, I am only getting whole number results. My columns are: Lease End - set up as a date Today’s Date - set up as a formula: Today() Lease Remaining - set up as a formula: DATETIME_DIFF({Lease End},{Today’s Date}, ‘Years’) Any help appreciated!

Courier/delivery company. I set up a base with three tables - one for customers, one for drivers, and one for a dispatch log. We’re developing a form for the dispatcher to call up and enter info about a new pickup/delivery. We linked the customer field in the form to pull a current customer from the customer table and sync the new order info to the dispatch log table. However, is there a way to have the form Add a New customer (first time caller) and have it populate a new row in the Customer table? I guess that would mean creating a field in the form that sent info to the Customer table AND the Dispatch log? There are several fields in the Dispatch log that sync with fields in the Customer table. I’m not sure how to set this up to coordinate all tables with the form info. Thanks for any advice!

Hi ! I’m trying to rename a picture using the airtable python wrapper (API). A picture is represented by a list of dict : Example : {'Picture 1' : [{'id': '...', 'url': '...', 'filename': 'Picture_1.jpeg', 'size': 24150, 'type': 'image/jpeg', ...}] The problem here is that it’s a list of dict, so you can’t just modify filename. If you want to edit anything in Picture 1, you have to get all properties. So I obviously tried to airtable_update by copiying properties, then edit filename and airtable_update. The return updated record is the same, likewise on airtable. I don’t get any error message so I think I have the solution by downloading and rename locally then upload, but I don’t want to do that, not clean. If you have any ideas :confused:

Use Case: I have a base that enables teachers to log sessions with students. In the Sessions table, there’s a field for Session Date (date), Session Number (integer), and Student (one-to-one link to a record in the Students table). The goal is to automate the Session Number field with the following business logic: Each month, the first Session with a given Student should be assigned Session Number=1. The second session that month gets Session Number=2, etc. When the month rolls over, the Session Numbers start over again. So, first session in July for Student A would get Session Number=1, etc. Have gone down a rabbit hole with conditional formulas and am quite stumped. Any help much appreciated! :slightly_smiling_face:

I am looking to extract a specific word in a column and only return that word otherwise blank. For example if i have multiple words in rows like: Open Closed In progress I want to show in a new column just “open” I will then repeat to show “closed” Any help is appreciated Thanks

We had a record deleted and it’s been more than 7 days since that happened. We would like to recreate the record but would want the Record ID to match the original that was deleted. Is this possible?

I am using airtable to display a list of articles in gallery view. On the card, I have a button called “click to read article”. This currently opens to the standard airtable card which displays the details of the record. I am trying to use the page designer so that clicking the button opens the page designer view instead of the standard card. This should work on an embedded view on an external website. Would appreciate some help with this!

I have two columns in a sort of library system. One is a list of about 100 members, and the other a list of items. A third (junction) column forms a historical list of loans, combining an item, a member and a time stamp. I use rollup with max(values) to flag the latest loan of an item. In the items table, I need to find a way of looking up the latest loan of an item and return its current holder, without having to upgrade to use apps. Can this be done in Airtable?

Hi Does anyone know how to find the source table from a destination synced table?

Is it possible to sync tables without opening up the data to the web?

Hello, I want to show in a column very simply: Last modified: 25/11/2020 14:30 ‘Last modified’ is static text. The date is ‘last modified time’ that is automatically updated when we edit the Airtable record. Problem: I created a formula column but it makes something very weird of the dates “2020-11-18T11:50:33.000Z”. Any ideas how to make the date appear normal?

2 fields, both are integer A = 35000 B = 86400 Formula A/B giving result 0 where it should be 0.40 How can I achieve result ?

Hey there, I am faced with a seemingly simple problem that I’m loosing far too much hair over. Bein in my late 30s, that’s something i really cannot afford any more and I am turning to the community to help here. Basically, I need assistance with a script that generates product id’s for designs, based on the designer and a variant of that to regenerate those codes if necessary. Our setup is a base with a table with Designs and another table with Designers - the schema for the Product IDs is Designer ID-Design ID so if our Designer’s ID is 100 and the Designs in question has the ID 23 the Product Id would be 100-23 Our backend / shop software (magento, nightmare) requires these codes to be sequential and doesn’t like gaps, so if the designs 100-23 was removed during production, we’d need to regenerate all product id’s that follow the 23, as simply omitting the design is not an option. This is where the script comes in. The starting point is the code here Calculate record number in parti

I have imported a small project schedule prepared by Excel, which as PiC field. After I imported it to AirTable, the Collaborator Filed in AirTable could not detect the PiC Field. So I end up to add assign task one by one. Is there a faster way to do this? say copy and past even by column?

I have a table of Researchers and a table of Projects. In the Projects table, I assign researchers to projects by adding them as linked records. Often, multiple researchers are assigned to the same project. When multiple researchers are assigned to the same project (i.e. multiple records linked to the project), I’d like to automatically create new records in a separate table specifically for each researcher assigned to the project, so that I can send them emails and manage their assignments individually. For example, in the case of the records in this screenshot, I’d like to automatically create a new record for “Project 1_Tori Klein (test)” and “Project 1_Test Researcher.” Any ideas for how I can do this? Thank you for your help!

Hi All! I am struggling on how to create a cleaning checklist for a client in a very large home. It was suggested I try to use Page Design, which should work. But where I am struggling is how to decide which areas should go into which blocks. Anyone have any advice? I attached a photo of how my table looks now for reference.

Hi there! Recently, I logged into my database and all the apps I’d built for a particular table had disappeared. Instead of seeing the usual dashboard with my apps, I now see the “Install an App” option. Has anyone else had their apps disappear without a trace? Some details of this situation if it helps: I definitely tried logging out and back in. My colleagues logged in and they also don’t see the apps. I checked the trash and it doesn’t look like anyone deleted anything. My colleague was able to restore an older version that still had the apps. I’d like to either figure out where the apps went or copy over the apps from the older version. Is it possible to do either of those things? Thanks in advance for any ideas!

So I am new to airtable. I created a table with the fields I want. How do I create a form for people to fill out and then their info will be added to my table?

I’m putting images in an iFrame for use on an artist’s web site. We have large images here at Airtable for our own use. They’re not huge but I’d like to limit the files that visitors to can download. But visitors are looking at an iFrame into Airtable data. Is there way to prevent download of large images yet still have them here in airtable?

I add a the field Record URL to the body of an email (Automation task) The email is sent to a collaborator When the collaborator clicks on the link they get a blank page I have shared the workspace and base with the collaborator. How do I resolve this issue?

I created a team contact sheet and want to send each person their line to update. Is there a way to: 1. share info in just that one particular line with a non-air table user and have them be able to update the information via a form? 2. Email other the form within Airtable without having to copy a link and then embed it in an email?

Hey all, first time post here. I’m assembling an org chart from a template. I’m assembling a structure where some solo people report to the CEO and others to their department heads. Is there a way to move the solo people to the bottom level since they are not considered department leads, even though they report to the top level CEO?