Other Questions

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 de

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?

We are experimenting with using AirTable to create a marketing editorial calendar, but are stuck because of the inability to see enough information on a per-record basis in the calendar view. Is there a way to expand the record size to show 2 lines? Or have it display a custom field rather than the ID field for the record?

Hi all, I recently started some using Formnano forms to update records in my table, but found this morning that the entire Formnano site seems to be down, with form links not working and I can’t find a way to contact them. (Getting a proxy/firewall error message on all) Does anyone know anything about this or how to get in touch with Formnano?

Hi everybody! So I’ve created a simple donor database. The first tab lists monetary donations. The second one details individual donors. I want to set up a simple form for my employees to enter contributions but since the “individual donor” field in the the “monetary donation” tab links to the second “individual donor” tab, it doesn’t let my employees enter new donors in the form (they can only select from existing donors). Maybe it’s something simple I’m missing but can anybody help me set it up so new donors can also be entered through the “monetary donations” form? Thanks in advance! Bethany