Other Questions

Hi all, So today I wanted to get a “Mark Duplicate” script up and running on a base. Turns out its one of the featured examples. So I copied the code, adjusted it for my base and hit test and it didn’t work. The error reporting is rubbish - so I have no idea what went wrong and logging variables doesn’t work. This is the second time in 3 months I have tried to use the scripts block. I can’t say I am enjoying it, its slow and has no failure message (primitive stack trace) So my question is - how are others working with this productively. Because at the moment this absolutely sucks and I’d be better off using zaps.

Hello everybody. As the title says, I’m generating receipts with Airtable and I’m looking for a solution to generate a unique number for each one. I was looking at automation to maybe grab the last record and on the receipts # field do a +1, but I think this could be simpler with autonumber. Greatly appreciate your input.

User AISYAH_AMBOK asked the same thing some months ago, and even provided a great example. The third field in this table, with the issue pointed out with the ‘CROSS MONTH’: Can anyone here figure out how to make this work? And if possible make it work so it will list every month (and not just the first two) included in the range. e.g. if the range started 9 workdays before the end of January, and five workdays into april.: jan 2020, 9 - feb 2020, 21 - mar 2020, 22 - april 2020, 5 Obviously all the holidays of the year would have to be added to the formula to have a correct tally. This would make or break my use of Airtable on one project, so I really hope someone can figure this out.

Please assist me in Managing users with rights.

Hin Guys ! I’m using the Batch Update to sort the linked records but the are not sorting by date … any idea what could be the problem ? Thanks !!

Dear sirs, In our company we are considering to use Airtable pro. But a question emerged. We can have non payed users accessing via forms or kanban modes and giving inputs. Or will they be considered payed users? The use case is the following, we are onboarding partners and organisations and we will establish a simple CRM to schedule our work. Some users will engage with the forms to get assignments and progress the leads. But the cost will not scale if they are payed users. thanks in advance, Paulo

Hello! Im an airtable newbie with very light coding experience. Having several challenges setting up the bases for my team, but there’s one in particular that I cant seem to figure out. I’ve created an automation that triggers record B to be created on table B whenever a new record (record A) enters the view on table A. Table B’s purpose is to aggregate information from table A and table C and provide a top level view of many different scheduled communications. The problem that I have now, however, is that whenever there are updates to record A or C—like a date change, for example—the updates arent passed along to record B. I tried to create an automation triggered when record A is updated, but am unable to link it to record B. Are any of the below possible through a script or automation? 1- when record A is updated, the now outdated, record B is deleted and a new, updated, record B is created 2- when record A is updated a new record B is created, script runs to remove older record by

Hey there, We’re missing some records that we have created in airtable and exported as csv. These records had image attachments and those urls to the images still work but we cannot find the records anywhere on our tables. Any suggestion/recommendation? not sure what has happened here… We’ve looked in trash and history but no indication of removing those records.

Hello everyone, I have a base with information about individuals (i.e. Date of birth / death etc.) and I would like to configure a field that would let me know if any of these individuals were born or died or published something significant on a specific day I am logging on the base (“today”). Is there a way to configure this? Thank you in advance for any assistance!

Buenas tardes. Deseo hacer una aplicacion con airtable donde varios colaboradores lean informacion con sus dispositivos moviles pero cada vez que ellos ingresen informacion a la tabla en un campo quede identificado el celular desde donde se completo la informacion. Como se puede saber desde donde salio en forma automatica y sin necesidad de que el operador se identifique. Gracias

After sending a batch of emails through the SendGrid block, I can’t find a way to view the sent emails after the fact. There appears to be no record of the emails I sent. Even if I want to bcc myself so that I have a record, I cannot easily do that since the cc and bcc options only let you select fields in the table. How do you suggest I log the emails sent to contacts in my table?

Hi I am trying to add records to a new table by from another table of linked records. Will eventually automate when original table is updated with new but have tons to transfer over. I want the same record to be linked to each other in each table. Copy and paste will take too long. Any ideas welcome. Thank you, Maria

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: