Other Questions

I’m using a table that takes a text (email body) and returns various elements, such as date. So I have a date written in one column like this: November 14, 2020 December 10, 2020 I use several formulas to get this info, such as FIND, MID and LEN. The formula in this first column is: MID({Email text},{Find Start Cut Off Date},{Length Cutoff Date}) Then in another column, I use DATETIME_PARSE to convert this info into a date. And for whatever reason, it returns a day before the actual date that’s in the first column. The output is: 13 November, 2020 9 December, 2020 What am I doing wrong?

I have a table: team(text) - activity(text) - month(YYYY-MM) - allocation(float>0) team(text) + activity(text) + month(YYYY-MM) - is unique I need view where: I can edit allocation values every unique month seen as filed: team(text) - activity - month1 - month2, - month3… cells are allocations In excell/spreadsheed Icando it in pivot table. But it’s not editable view.

Hello I would like to tidy up entries which I get via Cognito Forms and via Zapier which end up in the page at http://nktop.org/communitymarket.asp and in the process dropping any CRLF’s entered by the user. Ideally I would like to manually edit the Description field table in Airtable by inserting new paras but so far have failed. Is there a simple way?

Hey all, I am new the forum. I have a question regarding the update of data in an excel sheet. Can I make some row content only to some collaborators and they can edit those they are viewing only?

I’m trying to design a base where I can see how many of my working hours each day are allocated to tasks, thus how much capacity I have remaining or if I am overbooked. So far I have a list of Projects which includes fields for start date, deadline, estimated hours the project will take. I can calculate the number of days the project spans, split the total estimated hours across those days, calculate % of total daily capacity. What I’m struggling with is a way to represent this on a per day basis, i.e a view in which I can see each working day of the week, how many hours I am booked for across all the projects I might have ongoing. I am assuming an even split across the project duration, so say Project 1 spans 3 days and will take me 3 hours, for planning purposes I would need to allocate 1 hour per day. Any tips? I have looked through several of the task/resource management bases out there and they all seem to go by task count rather than hours, and I can’t find anything spanning a da

Hi I am trying to create a breakdown of expenses using rollups but the result is not quite what I want. Can anyone offer a solution please? Screenshot of what I have so far

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.