Other Questions

Hello, I would like to send an SMS or Email as notification when I click on button in Certain Records. But unfortunately buttons are not supported in the Android APP, I wanted to run a script when I press this button in my Android APP. What do you suggest as alternative? Best Regards, Amro

I have created a base that has a list of all my customers. I am looking to embed each individual record e.g. my customer data into another website so my staff can view it. I can’t seem to work out how to embed individual records. Is this possible? If not does anyone have any work around?

I have a great base setup that is then grouped by ‘Month’ and shows all of billing records through the month/year. Month being a single select column. Billing records being a different currency column. On the desktop app and through the browser, I am able to easily see the monthly and full annual total at the top of each ‘group’. On my mobile device, I am only able to see the count at the top of each group. The number of invoices I’ve billed out a month is not my top concern, instead I’d like to see how much I’ve billed that month total. How can I create this on mobile? Is there a separate setting, view, or do I need to create a new base altogether that pulls this data? I have created a pivot table through the app, but again cannot figure out how to show this on mobile.

We have the paid version of Airtable that allows private views to be hidden from others. I am creating views for multiple people and would like to hide each one from those they are not for. For instance, “Jeff’s view” would be available to him and me and hidden to everyone else. From what I’ve seen, a contributor has to create their own personal view in order to hide it from others? One of the biggest complaints from our team in implementing Airtable is that there is too much visually, so I’m creating separate views for each team member and would like to hide the others. Thanks!

I seem to remember this option used to be available but maybe that was only on desktop? It would save a lot of time!

Hi, i amusing private Wi-Fi network but yesterday evening i am not able to open website, app or other app which using airtabel database. if i connect using mobile data its all working very good please help to solve this. Thanks

I’m having a hard time. When I duplicate a table and put a specific filter like “where - your class - is - 1”, it was suppose to appear only the records where the fiel “class is 1” appear. However, when I fill out the form created to feed this database, and put it in the field “class 1”, it just goes to the original database, and it doesn’t go to the other duplicate base but with the filter. I remember this working normally when I had a PRO plan, and now I have a free plan and it is no longer working. Does this problem have to do with the plan?

I select Duplicate Table and toggle on Duplicate Records, but the records are not duplicated. Anyone else have this issue?

Hi Everyone, Does anyone know if there’s a way to format a long-text column to have all the same formatting? I have rich-text enabled and would like all the text to be italicized. I’m hoping I don’t have to manually configure each cell to be italic but can’t figure out a way to do it. Thanks!

Hi, In a base, I have a column called {Launch Date}. I would like create a new column that contains the date X work days before {Launch Date}. I do not know this date in advance and want this new column to generate it! Thanks!

I use the Typeform integration with AirTable but when sending multi-select data where the user has chosen the “other” option and entered a custom value it doesn’t get added to my AirTable. Can anyone help me here?

Hey AT Users. Has anyone come across a good solution for either timestamping an updated element in a field or generating a timestamp for when a computed field contains a value vs when it is empty? For context: In our base there is a rich text field which includes a check list of about 10 items (done to eliminate the need of 10 separate fields, as there is already a LOT of data to process in this base). Using the following formula I can only return a timestamp for when the entire field was modified, not the particular element in that field: IF(FIND(" Milestone “,{Milestones Checklist}),DATETIME_FORMAT(SET_TIMEZONE(LAST_MODIFIED_TIME(), ‘America/Toronto’), ‘M/D/YYYY LT’,”")) If anyone has a work around for either timestamping when each of the 10 elements is marked with an x OR knows a workaround for timestamping a computed field - then I could add an IF(FIND(" Milestone",{Milestones Checklist}),“Yes”,"") field and then timestamp WHEN that yes appears. Any thoughts???

Hi all. New user and still finding my way around. Just signed up for the 3 day mini-extension trial as I want to have a go with the Client Portal Mini-Extension. I’m not techy and have extensively Googled a ‘how to install’ the above but can’t find out how to do it anywhere. If I’m not careful my 3 days will be up before I’ve figured out how to install it. Any help would be greatly appreciated. Thought it would be obvious but can’t see how to add this or any other mini-extension. Many thanks

Hey Guys, I have used a formula that I copied from an answer here to create an end of month field. I have transaction dates for sales and i want to get the end of month date for each transaction date. It works for all months except when a transaction takes place in any december for some reason, in any year. For any other months, it works fine. This is the formula that I am using: DATEADD( DATETIME_PARSE( DATETIME_FORMAT( {TX DATE}, ‘YYYY’ ) & ‘-’ & (VALUE( DATETIME_FORMAT( {TX DATE}, ‘MM’ ) ) + 1) & ‘-01’, ‘YYYY-MM-DD’ ) , -1, ‘day’ ) Can anyone try to pinpoint what’s wrong with it please? Thank you Hady

Is there any way to simplify this: https://airtable.com/shr4JpyGCNxWTqt7S? If I could put the amount of resources by type and quantity in one column it would make this much easier (for the overview table that is).

Hi! Trying to create a menu item that has options that need to be selected at the time of placing the order. The options do not affect the price of the item, but are an indication of which flavors to include. I can’t figure out how to add checkboxes within an item.

I’m fairly new to AirTable and I’m trying to get a peak of all the possibility this tool has to offer. I’m thinking about migrating an app, which is currently configured using a JSON format, to AirTable. The goal is to allow my teammates to see/update the data. Also, I saw there are tons of possibilities with AirTable and I’m also looking for creating forms and user interfaces eventually. Basically, AirTable may replace the backoffice I’m supposed to build. But I have a few questions about how I should proceed, and I hope I can get some advices here! :slightly_smiling_face: JSON to AirTable AirTable doesn’t support JSON format. Therefore, I’ll convert JSON to CSV and then import the CSV into AirTable. But I wonder how I should convert those data to be efficient in AirTable and allow proper usage using JavaScript when fetching the records later on, through the API. Here is my data structure: [ { "state": "active", "name": "name", "label": "Label", "logo": { "ur

Hi Need help with my directory build. Users join my site via Memberstack and name + email is zapped to Airtable (“Memberstack” table) Members are re-directed to dashboard to complete their profile (Airtable form/table “Profile”) I want to automatically push the “Memberstack” table data (name + email) to the “Profile” table and prefill the “Profile” form. The resulting “Profile” table will then get zapped to Webflow CMS Can someone tell me if this is possible and how to do it? I can’t find the right solution as I’m a nocode newb. Thanks

Is there any type of app or script I can do to create the ability to bulk select the options in a link to another record field? Also open to other suggestions on ways to do this! What I am trying to accomplish: Create a form view employees can use to build custom order forms for clients. We have around ~50 products that can go on this field Create a printable order form that includes only the products they selected The problem is currently can only pick one at a time, so it’s click, pick, click, pick. Takes way too long to make this worth it. At the least I’d like to set this field to automatically include all possible products, and that way they can remove the ones they don’t need.

I have a Zapier firing when a certain label is added in Evernote. I am able to get the record added correctly into Airtable. Inside the text of my Evernote, I have encoded who the note is about. Example below: <NAME: First Person, Second Person, Third Person> I have a formula that can find “<NAME:” and I can pull the correct list of names, comma separated string. However, I also have a contacts table with peoples first name. How can I get a column that has to be a formula (in order to pull the text) and get it linked to a Contact. The ultimate goal is to be able to have a view of my contacts and see what Evernotes were tagged to their name. Thanks!

We run a small medical practice with multiple therapists. We need to schedule each therapist a full days work. How can this be visualised in the calendar view? Ie, see more than one therapist diary at one time with his own work, that is not in conflict with other appointments? We would prefer to use Airtable functionalities instead of API’s or other integrations. Any help and suggestions will be greatly appreciated :blush: TIA

In my App (made with thunkable) I store all the used data in airtable tables. Concrete example: The main-table is the “tb.ITteam”. In this table I have a couple of usual fields like firstname, lastname, shortcut, etc. And I have some linked fields like function and group. Function is linked to table “tb.function”, group is linked to table “tb.group”. I use this method to ensure, that values in the fields function and group (in table tb.ITteam) are crosschecked for validity in tb.function and tb.group. Everything worked fine for about two weeks. Here is the block-snip where you can see how I read those fields: You can see (No. 1 & 2): these are the linked fields, all others are unlinked fields. Without me changing anything (neither in the app, nor in the tables) suddenly, my app hangs when reading 1 & 2. I am sure about this point, because a ran a test where I deactivated only the blocks 1 & 2 and everything ran fine (of course - without the values function and group). This

Hey All! I have 3x tables (W, X and Y) and each table has the same formula entered into a formula field called ‘Alias’. This ‘Alias’ field aggregates data from 3x other fields within the same table – where generally only 1x field will have data actually present. Let’s say the ‘Alias’ field in tables W, X and Y have data equal to ‘John Doe Ltd’. (It is possible that ‘John Doe Ltd’ will appear in some/all of the ‘Alias’ fields, in any/all of the 3x tables of W, X or Y). – In another table (Z), I have aggregated the ‘Alias’ fields (via an aggregator array) from tables W, X and Y to give a list of unique aliases in Z, from all 3x tables (W, X and Y). Next to each unique ‘Alias’ in Z, e.g., ‘John Doe Ltd’, I have a ‘Linked Field’ to retrieve an existing ‘Account Number’, from yet another table, call it table A. So let’s say the ‘Alias’ of ‘John Doe Ltd’ (in Z) is assigned the existing ‘Account Number’ of ‘JOHNDO’, what I THEN want to do, is enter this ‘Account Number’ [of ‘JOHNDO’] into a N

I have one base with multiple tables. Some of the tables have identical fields. How do I synchronize these fields across tables so that if I change the info in one field, it automatically updates it in the other table in the same named field? thanks.

Thanks in advance for this basic question. I could not find the answer thus the post. Imagine I have 2 tables (in the same base). Table 1 has 3 columns. col #1 has some key Col #2 is date col #3 has sale amount There would be multiple sales on same date. Table 2 has two column: Col #1 is the date Col #2 >>> I would like this to be the sum of all the sales in from Table 1. How do I link the two tables to get the sales summary. Thanks.