Other Questions

Hi, I’m trying to implement a very simple scripting block to send a single text message (as opposed to the “Send SMS” block, which we use for batches). Here’s my code, as suggested by Twilio’s API - const phone_number = await input.textAsync('Who are we texting today? (Phone #)'); const message_body = await input.textAsync('What do you wish to say to them?'); const accountSid = <<My Account SID>>; const authToken = <<My Auth Token>>; const client = require('twilio')(accountSid, authToken); client.messages .create({ body: message_body, from: <<My Twilio Number>>, to: phone_number }) .then(message => console.log(message.sid)); But then I get this error - ReferenceError: require is not defined at main on line 6 Any suggestion? Thanks!

Hello; I was testing out the maps block but it doesn’t seem show the map in the block on the dashboard, but instead says, “Please make this block bigger or full screen”. It works when fullscreened, but the screenshots / video example in the Map block article show it as being visible straight in the dashboard. Airtable - Support Map block The map block is part of Airtable Blocks, a Pro plan feature. Blocks let you extend the functionality of your bases: you can use blocks to bring new information into Airtable, visualize and summari... Has this changed, or is there something I’m missing somewhere to configure this?

Hi all! I am looking to automatically calculate a sub tasks draft date based on identifying the entire project’s DUE DATE. Let’s say that x project is due on 6/06/20 - I want to then automatically populate a calendar based on that date: ie. Task 1 is (-10) work days from 6/6/20 Task 2 is (-5) work days from 6/6/20 Task 3 is (- 3) work days from 6/6/20 …and so on What would be the best way to do this? Thank you all!

Is there a way to automatically save(/see) who entered data into a base via the web clipper?

Hi there! I have a list of students in my ‘home’ table but I need a separate table for some of these students that have extra requirements (I’m aware I could have it all in the same table and just filter/group/sort but I’m looking to share this separate table with people who only need access to the extra students and not the others. How can I link the records (first column is Names of the students) between the two tables so I can add Lookup columns for the relevant info I do want to share in the separate table? Been trying to figure this out for a while and couldn’t because it’s not a relationship between two different records but the same one, just in another location. Any help is appreciated!! Thank you :slightly_smiling_face:

How can you show one record on multiple dates if I have those dates inside one column? I would like to have a calendar view that shows me “1/tbsp - 0% cottage cheese” on the 19th May and 23rd May Is it possible?

Hi I’m using Typeform with stripe integration to sell tickets for an event i’m organising. In my form, customers choose differents options trough multiple select questions. I’m adding price of the different options they choosed with the typeform calculator and make the paiement in the typeform by stripe. The informations then get into my Airtable by Zapier, and i’d like to send the customers an invoice from that. I was planning to make a zap from a new record in a view, and send the informations to QuickBooks to create an invoice, but the integration of Airtable -> Zapier -> QuickBooks -> Invoice -> Happyme only works trough line items. I found a topic about creating line items in Airtable, but i can’t figure out how to send them to QuickBooks : Create an invoice with multiple items and various quantities Thanks if you can help :slightly_smiling_face:

Hi there - I’m trying to create a Zap that creates a notification whenever a new record is added in an Airtable table. The basic setup works fine and took all of 2 minutes to setup. But the problem is that there are a few important fields in our records that are Lookups from other tables. When we view them in Airtable, the field shows the required data. However when Zapier creates the notification - these Lookup fields show up as BLANK as it doesn’t appear to be gathering the value from the lookup table. Does anyone know some ways around this so we can get the values of Lookups to show in Notifications created via Zapier? Many thanks in advance :nerd_face: (or alternatively any other way to get a simple notification in something like Teams (or worst case Email) whenever a new record is added)

Hi everyone, I’m just settling into using airtable but I’ve been using zapier for quite a long time, so I’m very familiar with zaps. I have two things I’m trying to achieve - I want to setup calendar notifications (it seems that this strangely isn’t an offered feature by Airtable yet?) To do that I noted that someone said it can be done using zapier but I can’t see the zap that would make it happen. Really appreciate suggestions for this. I want to automate a specific email to be sent to a client when a date and time is set in my calendar for a meeting. I’d like the email to take the data from the date and time and add it to the email and I’d also like it to take a date from a different airtable cell and add it into another part of the email. I don’t use a zapier approved email system at the moment (I have my own domain and feed it through thunderbird), but I can use gmail for this (I guess) if I have to (#HateGmail). Any suggestions gratefully received. Thanks a million in advan

Several of the community examples in the Script Showcase are just broken links, all pointing to https://community.airtable.com/t/weekend-scripting-block-challenge-and-1-000-prize/28074/5?u=kasra which doesn’t exist. Does anyone know where I can find them? Showcase is here: Airtable Example Script Showcase - Airtable Universe There are tons of ways to use the scripting app, so the Airtable team has collected some of our favorite examples, both internally and from the community, to... thanks, Rory

How can i share base and use with out sign in ??

I have a meal plan database. On the first table, I have the meals associated with dates and ingredients for each meal and on the second table, I have the ingredients with a lookup date; which show me a list of ingredients and the date I need them. How can I have this lookup date (sometimes more than one) display in Kanban where each day is a column?

I’m using Airtable as an Applicant Tracking System (far more advanced than the template they give us to start out with) and as part of that I have to send Rejection emails or next step emails. I want to create a sendgird block for each email type so I don’t have to keep changing the subject and content over and over again and I was wondering if I could use the same SendGrid API key to do that or am I supposed to request another API key, one for each block.

I am new to Airtable, and my trad spreadsheet skills are average, so please stick with me. I have checked and can’t see how to complete my base, but I am sure it can be updated to suit my conditions! I am creating a base to track an individuals career/job search activity that will also act as a personal CRM of the hiring process of each opportunity as it moves into engagement with an opportunity provider (Company). The base has four tables: Opportunity Long-List Listing fields related to sourcing suitable target companies and or jobs found Opportunity Outreach Listing only those filtered as appropriate from the Long-list table when a specific condition is met and adding new fields relevant to tracking the hiring/engagement process workflow events to be recorded. Company Containing fields relative to core company information such as address web links, core service or products description. Stakeholder Records individuals identified as relevant to a specific opportunity or possible infl

I’m a new user and I’ve been very much enjoying setting up my bases for CRM and project management for the past few weeks. It’s working really well for me. I’ve had a sudden realisation though, if airtable has downtime or crashes my entire project management system and ability to have a clue about anything related to my clients and jobs would be gone! #MajorRisk I would like to find out how stable long-term users have found the platform and if anyone has any methodology for mitigating this risk please? Thank you.

Hello, I’m currently trying to take my primary field in a table and concatenate based on what applies. The table itself is pretty basic - using it for client information; i.e. First Name, Middle Initial, Last Name, Spouse First Name, Spouse Last Name, and other basic information. We have some clients where we want the spouses other last name for whatever reasons. What I’m wanting to do is have the primary field concatenate certain information when 1 IF applies, OR concatenate different information if the OTHER IF applies. For Example: IF({Spouse Last Name}!=Blank(), Concatenate({Last Name}, ", ", {First Name}, " & ", {Spouse First Name})) -OR- IF({Spouse Last Name}, Concatenate({Last Name}, ", ", {First Name}, " & ", {Spouse Last Name}, ", ", {Spouse First Name}) My problem is combining those IF statements so that both would apply, so IF it meets criteria of 1, it applies that concatenated formula, or if it meets the criteria of the other 1, it applies that concatenated formula

I am just getting familiar with Airtable, doing some test driving, so sorry if this has been answered elsewhere and I just couldn’t find it. I would say a vast majority of the Projects we do all use the same tasks over and over. Is there a way to create like a “preset” when you add a Project it just pre-populates a set of all the common tasks? I’d considered just using 1 task that is attached to multiple projects but we’ll track time on those tasks and although they are all the same task they may take a different amount of time to complete. Not to mention, different employees may be completing them so they’d need to be assigned to different people.

Is there a way to view all of the field permissions that I have set in my base or do I have to click on each field individually and check there?

I’m rather new to Airtable but I’ve been playing around with it this week and I’m not finding it easy to do what I want to do. I’ve searched the net and all roads point to using Zapier to copy data from one table to another. Here is my situation: I have a table called Scheduled Orders that has the same data every day. Quantities/Prices might increase over time but the idea is to have one master schedule and every day at said time, it will create these order in the Order Board table. I have not found a way to do this and my Zapier “zap” is not working. I need some help from users who may have done this or something similar before. Summary: Select all scheduled orders from the scheduler table. For each scheduled order, populate on the Orders Table. I need to create a new order each time. Any help greatly appreciated. Jason

Hi community ! I have ann issue with a zap (by zapier) I use to send a mail to each new users (in a record). I would like to display in a view records that follow certain criteria. The fact is that a record can appear in this view, disappear few minutes later, and appear again. I would like to send an email each time this record appear in this view, but it doesn’t work, it seems like the record is save in zapier memory … Do u know if i have to wait a certain time till the record id is forget ? Thanks by advance !

Is there a way to copy and paste a whole row or column? I would already have the column name and type set up -i just want to copy the information in the rows and columns. It doesn’t seem to let you copy and paste more than one cell. I’ve tried dragging to select and holding control while selecting but that doesn’t seem to work.

I am trying to setup a client portal with an external plugin. In my table, each record represent a client case. Considering to setup a simple login mechanism. Is it safe to use the RECORD_ID() as the password of the particular record? Or any workaround to generate a random password for each record (case)?

I have a business that deals with a single recurring service, typically occurring every 1-3 years. My intent in using Airtable is to manage all of my Contacts, Services Performed, and the ability to identify when a Contact is due for a recurring service. I currently have a Contacts table, as well as a Services Performed table (I have Zapier add the performed service, pulling from my Google Calendar). I link the two tables via phone number. I would like to have all the dates that the service has been performed for a contact displayed in the Contacts table in a single cell, with the ability to roll it up to most recent service (or just add another cell to do so). Additionally, I would like all corresponding fields updated (or added if different). Also, if possible, I would like a new contact added if there is no match in Services Performed (though this may only be possible through Zapier). Thank you in advance for any help, and please ask me for any clarification

greeting - airtable noob here with my first post :slightly_smiling_face: i need to take a text string from a field called NAME - make it lower case - and then do search and replace for a number of characters . I have it working for one condition - replacing spaces with dashes. SUBSTITUTE(LOWER(NAME), " ", “-”) now i need to find special characters like ( ) " etc and eliminate from the string. is there a way to nest multiple commands…? or…? thanks!

Hello, I have a question. I have a table Product that has a Product name and Barcode, and I have a Sales table then I want to scan the barcode and I want it to fill the product name based on barcode connected to the Product field. I am trying to create an inventory tracking system.