Other Questions

Hello everybody. I’m getting the Max value from a field which links to some records, then I’m adding to the link to increment it for the next time I need the MAX. Is there a limit on how many records I can link from 1 field? Thanks.

I created a test account to explore airtable functionality. We might need to publish our own application on airtable marketplace. But I cannot install any application from the marketplace. I click “Install” button on an app (e.g. - this one https://airtable.com/marketplace/blkt8D4LiDFZ1SCop/sendgrid) and nothing happens why is this?

Hi! I have table: integer - text - date I want view with group by text+date and average(integer) In grid view I see count(records) In Martix app and Pivot app - summarization by one field only. In excel/spreadsheet I can do it easily in pivot report. Could you advise way to create such view here?

Hey guys. I have an integration between Typeform and Airtable, I’m using Zapier to do that. BUT whenever a new record is created in Airtable, this record appears duplicated but without the field that I named as “Interaction ID” and with a different Record ID. PS: If I run a test in Zapier, the record appears with no duplication. Any ideas?

Hello everyone, I was wondeing if there was anything like a heatmap app where i can see what time of the day/week is the most popular order times, please see my screenshot for extra clarification (this was taken from google analytics). Many thanks! Matt

Hi Airtable Community! I have a problem I’m sure some of you have already solved. I’m collecting monthly data for specific metrics (example: Revenue) I’m capturing three data elements in one record - Actual, Budget, and Previous Year. When I try to create visualizations for this in the Chart app, because of the way I’m capturing the data I can’t get the visualization I’m looking for. I would like to see three vertical (or horizontal bars) for for each of the data points in the record (Actual, Budget, Previous Year). I’m thinking Veg-Lite might be the answer but have never used it. Really appreciate any feedback and ideas. I’m also open to other ideas on how to better capture this data from end users, there may be a better way to capture these elements that would lend to better visualizations. I added all three data fields to one record to make it easier for the end users to submit updates. Thank you all. Travis

Hi—I’m new to Airtable, and have a free account for now. I’m working with a cowriter on a detailed outline for a musical. My cowriter has a Pro Plan. If I also get a Pro Plan, can we collaborate on the same base without either of us being charged a collaboration fee beyond the $20/month standard fee? If not, is there any plan that would allow us to both make changes to the same base without being charged a base-specific collaboration fee? Thanks—Peter

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