Other Questions

A button field is appended in a synced table. What I would like to do is that once a user clicks the synced record’s button field it will update the source record based on other appended fields in the synced table. Is this possible? Maybe a script attached to the button field can do it.

It sucks that every other CRM comes with a dialer/ chrome extension to hook up with the CRM to call numbers with Twilio / Plivo dialer except Airtable.

A while ago I posted a question How to do Partner field? “When I have a new network of eg 10 partners, and I put all 9 partner orgs of 1 of those orgs in that org’s Partners field, I want it to, for each of those 9 orgs, also fill their Partners field with all the other 9 orgs (the 10 orgs minus itself) rather than with just that one org in whose Partner field I put the 9 other orgs.” and @kuovonne posted the solution How to do Partner field? - #6 by kuovonne I thought I’d post how I’ve now implemented it an organization can be the name of a network of organizations, in which case it is not a member organization itself or an organization can be the head of a network of organizations of which it is also a member itself In the table, ‘Countering-Disinformation.com’ is the name of a network of organizations while ‘DOT Europe’ is the head of a network of which it is also a member itself. ‘Project Origin’ is name of a network but is itself also part of a different network (‘Countering-Disin

I need the summary total for each group, seems like this is not happening in airtable yet so my only workaround, in a hurry, is to print screen! come on guys!

Hi, I’m trying to send 17 records to an email of a collaborator - and to myself - but we’re both not receiving anything, and it’s not in junk mail. I’m highlighting records and right clicking and then ‘send all selected records’ From what I’m reading this should be possible on the free version as I’m sending to a colleague that is part of my team. Can anyone let me know where I’m going wrong?

Hello people! I am trying to setup a table which will contain reminders for when I want to connect with my clients. Basically, I want to setup weekly/fortnightly/monthly reminders based on day of the week. Like so - Weekly - Thursday, Monthly - 1st week Friday, Monthly - 3rd week Tuesday Now, the reminder should be mailed to me like this - Daily reminder - Based on the given day (weekly and monthly) Weekly reminder - All reminders in that week Monthly reminder - All reminders with Monthly frequency I’m feeling very confused as I’ve hit my brain on this for few hours wondering how to make it work. I have read lots of support posts and docs as well, and have given up now. Any help would be appreciated.

I would like the user to be able to schedule with the google calendar. I have created an automation on airtable so that every time an event is created on the google calendar, it creates a row in airtable. But this solution is not very good because it requires a lot of automation to manage the synchronization. Has anyone managed to do this differently? thx

I have a database of incoming groups with all the pertinent data such as group name, arrival/departure date, #rooms held, # rooms picked up, room rate, # guests, contract attachment. I need to present to my hotel managers a summary of specific information including attachments every two weeks so that they are prepared for incoming groups. What is your suggestion of an app or the best way to do this? Thank you. Emily

Hello, my dear friends! Has anyone found a friendly way to deal with having multiple tasks on the same day in Gantt view? The invalid dependencies are enough to drive anyone batty :stuck_out_tongue: , but I can live with that, what’s more difficult is sorting. We are trying to use the Gantt view to communicate tasks to team members on the build floor and coordinate hand-offs. However, the Gantt view can be incredibly confusing, becasue everything is all out of order. Is there a way to sort same-day tasks that are dependent on each other, so they are always in successive order? I did this in another base by creating 50 look up fields to look up the previous tasks task and so on, but that is a pain to recreate each time and will eventually break. Thank you!! p.s. same issue on timeline view

Any ideas how to write an IF code for hotel VAT? I have 50 hotel nights showing in column {Nights} multiplied by the {nightly rate} @ £200/night = £10,000 VAT is calculated @ 20% on top of the first 28 nights and then @ 5% from the 29th night onwards. I would love a formula that can calculate this.

My node api call keeps failing. My code is updating the same records several times, Is the Airtable servers slow that it can’t handle multiple calls concurrently ? There are several update calls being made from my API. I dont understand whats going on here ? var result = body.records.map(function (record) { ^ TypeError: Cannot read properties of undefined (reading ‘records’) at /fast-csv-js/node_modules/airtable/lib/table.js:116:35 at //node_modules/airtable/lib/run_action.js:70:17 at process.processTicksAndRejections (node:internal/process/task_queues:95:5) Node.js v18.2.0 FetchError: request to https://api.airtable.com/v0/appBtcEHoqEBYVB/IN/r? failed, reason: getaddrinfo ENOTFOUND api.airtable.com at ClientRequest. (/Users/node_modules/node-fetch/lib/index.js:1491:11) at ClientRequest.emit (node:events:527:28) at TLSSocket.socketErrorListener (node:_http_client:454:9) at TLSSocket.emit (node:events:527:28) at emitErrorNT (node:internal/stream

Hello, how are you? I wanted to ask you if there is a way to connect a Thinkific survey with the platform. We need to compare the results of an initial and a final survey and do a manual process. Thanks!

Hello everyone! I was wondering is there a way to make it so only creators can create views? From my snooping around I haven’t been able to find a way.

I’m not sure the best way to do this but I would love some direction if anyone can help. I have a base with all my upcoming events and their contacts and organizations putting them on (we have multiple each week). In one table are the Events and all their information. In another Contacts and the last is the Organization putting it on. I would love to keep track of which employees are working each event. What is the best way to have an Employee table and then add employees to each event and see it cleanily? (I have relationships across all 3 already) Would making an employee table, then link it to the events table and using a gallery view be the best way? The employee could potentially be scheduled to multiple upcoming events at the same time. Thank you in advance for any help!

I have a column named Day name which is a single select field containing names of day - Monday, Tuesday, etc. How can I create another column which gives the weekday number of this? I know I need to use Weekday() function, but how can I set it up such that it converts the string to work with Weekday() function? Thanks.

Hi fellow community members, In the Tool I am building to follow-up auctions, i created 2 tables: Table 1: “list of lots in auction” Table 2: “Price obs table” in which i made a link with Table 1 My target is, in table 1, to retrieve info from fields “Max Bid Price”, “Max Bid Calculation” and “No bid” fields from table 2 linked with the concerned record. Lookup field trial has failed. Any suggestions guys? Thanks for your help :winking_face:

I have 2 tables linked, one with job information (primary) and one with finance, when i delete one from the job information table the finance table still has its relevant data (information not linked to original). Is there a way of automatically deleting the one when the other is deleted? Thank you

Is it possible to do this? I’d like have an Airtable form with an attachment field, requiring someone to submit a CSV file (with info already filled out). The contents are then imported into an existing table with the contents mapped out accordingly? I’d have them fill out the contents with a form, but sometimes entries could be as much as 20+ … I checked MiniExtensions but didn’t find anything that would work for this use case. Help is appreciated.

Hi! I have a base with start date, end date and completion date. When setting the Gannt I have start date and end date that create “a line”. However, I wanted to see also something on the Gantt that gives me when that activity was completed. I was thinking about setting that as milestone but it is not posible. I know that I can color the category as eg. green to see that is completed but I want to see WHEN. Any suggestion is highly appreciated! Thanks!!

Hi, I’m looking to solve something that is probably very basic. I have a master table that I’d like to bring in add’l data (size) into from Table 2 using the first column as the key. In this example, here is size data from table 2 that will be going over to the Master Table. In the Master Table, I’d like multi select fields with the data from Table 2. Can anyone please help me figure this out? Thanks, Michael

We started using Airtable at work and I signed up, accepted all of the invites viewed them at work and at home I log into Airtable and I cannot find how to get to our database. Any help would be greatly appreciated

In some tables, I have a lot of columns & I move around things a lot, is it possible to update the order of columns in the view by one click or by script ?

Each year I screen every kinder student and determine whether they’re OK, need speech service, need a recheck in 1st grade, or a recheck in 2nd grade. I’ve created a table for the first year- but I cannot figure out how to automatically move students from the 19-20 table into the 20-21 or 21-22 tables if they have data in the recheck field. If they are OK or receive service and meet mastery, or are disenrolled, (unshown fields) they do not need to transfer to the new tables. I also only need certain fields of data to move from the current table into the other 2 tabels (Student name, DOB, sounds) as the grades/teacher names will all change as they shift from grade to grade. Thank you for any help

Hi, I need help getting the following to work: I have created date and status columns and I need to create a formula that calculates if the application is overdue and by how many days. 1. The first condition is 7 days since the creation date and the status is unassigned. The returned value should be "Overdue by one week". 2. The second condition is between 7-14 days since the creation date and the status is unassigned. The returned value should be "Overdue by more than a week". 3. The third condition is more than 15 days since the creation date and the status is unassigned. The returned value should be "Over due by more than two weeks". Can someone please help?

Hello, I have uploaded a column with text string within quotes so that Airtable would populate the color combo multi-select options. But the quotations still appear with the text string. Is there anyway to remove or hide the quotations in the color combo multi-select field?