Other Questions

how to conjugate two fields into a new field.I want to conjugate "first name field" and "last name field" into one field labelled first_last name

How can I populate a field based on a view. When I create a new view I want to put the same info into a field.

I am trying to create in make(integromat) a scenario where I can fetch data from a specific date to feed it to a google docs file. (Its my firts time with make)How did I generate the formula in make to accomplish this? I can't figure out how to match the date field of my table to any of the variables that make gives me.Thanks for your support

https://www.honeycode.aws/features Amazon just launched their No-Code app development platform. This is big news. Microsoft has their Power apps platform for quite some time now. But when AWS launches it, instantly the developer and creators community will love it. It’s also very very affordable compared to all other similar products. Airtable and HoneyCode do not compare head-on-head. Since Airtable is database first and an app maker second whereas HoneyCode is just the opposite. But AWS launching this is a huge move in the industry of no code apps. Please share your thoughts on this!!!

Hi,i would like to generate a document with data from 3 different tables.Let's say :InvoicesEventsServices1 invoice gather different events and each event have different services.For standard Invoice, i use the BATCH "WORD" MODULE on MAKE with success.But it does not accept LOOP of LOOP.I also tried to create a master json inside Airtable following the json model for the WORD module (exemple here) with LOOP of LOOP, with no success yet.Have you ever done this ? if yes, with which tools ? 

I'm running the latest App store version (10.1) on my iPhone Xs. I used to be able to rotate the phone (w/ system orientation lock disabled, of course) and have the base view (records list) in the app rotate to follow OS. Now it no longer does. Have they removed this feature?

Hi everyone, I have a bunch of records and have used the QR Code Generator extension to generate a QR Code and save it to an attachment field. The problem with this is that each QR code has the same filename (as there’s no option to rename the file), this makes it very confusing when downloading them all. I have come across a script here : Automate changing the file name of an attachment // Setup let config = input.config() let table = base.getTable(“ :amphora: CONSIGNED ITEMS”) let query = await table.selectRecordsAsync() let record = query.getRecord(config.recordID) // Collect record data let newPrefix = record.getCellValue(“AuctionLotNumber”) let files = record.getCellValue(“Bidsquare Cloud QR”) // Get the extension and add it to the new name let newFiles = for (let file of files) { let parts = file.filename.split(“.”) let ext = parts[parts.length - 1] let fileNumber = “0” + (files.indexOf(file) + 1) let newName = ${newPrefix}-${fileNumber}.${ext} newFiles.push({url: file.url, fi

Hiya - I have a script that moves records from one table to another but the comments that have been written within the record don't go with them.  Why? 

Hi all,I run a small publishing business that is considering using Airtable to manage our advertising database. We have a small handful of users — like around 5 or so — that really NEED Airtable access.I have security permissions concerns, and I know we will hit the record and attachment size limits quickly. Enterprise has a handful of other features we could possibly use.My question — is Enterprise worth it to get around those things? It's a lot of money, but is it worth it?Or should I hire someone to build something for me using Airtable APIs with SOFTR on Pro plans? And then pair it with Google Drive or Box? No matter what, I expect to bump up against record limits. Looking for feedback!

Is there a way to show a button/option of Accept or Deny within the email using automation? Currently, the email is sent with a link the reader clicks, that opens a form (duplicating the same info in the email) to make their selection.

Hi all,I'm looking into the possibilities of making Airtable part of our project management set-up. At this moment, employees log their hours in Excel timesheets (on a daily basis, per month) and get copied over and over to make simulations or analysis of our ongoing projects. We have some major drawbacks in our way of working:- Information is not up-to-date, as timesheets are being processed once a month.- We need to copy the time data more than once, as we have no database set-up or whatsoever. Airtable could make it easier to centralize all timesheet data and link it back to other fixed data like project information, invoice structuring, people management... (no planning)I have a few questions about this:- What could be a good timesheet tool that works well together with Airtable? I need something "as simple as possible" that exports data on a daily base to our Airtable timesheet database.- Is Airtable an interesting tool to use for more complex project management? I'm talking

Hello, with Airtable’s announcements today, I’m wondering if it now might be possible to do a two-way sync with a WordPress table. As I understand it, it hasn’t been possible to update a record in a WordPress table when the record is updated in Airtable. I tested Zapier and was able to ADD a new record in Airtable when a record is added in WordPress. But, ideally what I need is a true two-way sync between the two programs. I’m building an alumni site in WordPress, and would like the following functionality: When a user is added in WordPress, the user is added in Airtable When a user is updated in either WordPress or Airtable, the two records are synced so the update will happen in both databases Happy to hire a community expert to work on this functionality, but do we know if this is now possible with Airtable’s new updates announced today? Any/all thoughts appreciated, thank you!

I’d like to use AirTable as a backend for Wordpress. Is there a wordpress plugin to so ? (I already know AirPress) How would you organize your Post in a AirTable ? and more precisely how would you handle Markdown from AirtTable rich fields and images ? I give a try to AirPress it’s great but it doesn’t go very far It do not handle Markdown fields It seems there is a “timeout” on AirTable Images ? So the URL is quickly forbidden I need to do custom trick in order to handle from markdown field May be I should you an other FrontEnd than Wordpress ? (I chose Wordpress because it power half of the web ;-)) May be I should explicitly post and update Wordpress instead of using virtual fields ?

Hi there, i’m new here. My question in a nutshell is if anyone has had success building out the equivalent of a School Information System (SIS) using Airtable. Read on for more detail. My wife and i and a small team are founding a new school for children in our community. We’ll start K–2 this fall and—should our prayers be answers—we’ll add a grade level each year all the way to grade 12. To date, we’ve been building out and refining all of our core systems, and now we’re researching a significant decision that virtually all schools face: choosing a SIS. There’s a million of these systems out there and they all seem to take a kind of everything-you’ll-ever-need-in-one-place approach. Our workflow, however, is heavily dependent on SAAS. We use G Suite (email and productivity), Asana (tasks/project management), HubSpot (donor management), PieSync (keeping contacts in sync), Calendly (appointment scheduler), Eventbrite (fundraisers), Aplos (bookkeeping), Zapier (to tie everything together

Hello all, I would love some advice on a function I am experimenting with. I’m trying to build a system where I can generate student progress reports for a private high school by leveraging linked records and the “Pages” block. In my experiment I have three tables: Student List, Course List, Grades (see below). The Student List is linked to the Course List. I can “enroll” students in courses with the linked record, which allows me to display their courses on a “Page” block, which will generate progress reports (below). The tricky part comes in with GRADES. In my third table I have student grades, where a teacher could input grades using a form. The “Course List” field is linked to the course list table (so teachers can select the course), and the “Student Name” is linked to the Student table (so teachers can select the student). The grade is the catch. If I lookup grades in any other table, it displays grades for ALL linked records in the class. What I’d really like is a linked rec

In my existing base all images stay fine but when I made a copy of the base and started replacing images in the Page Designer using url from Copy Image Address menu (the images are residing in the same base) they get displayed but get broken in a short time. The new URLs look different from my old base although I am getting the link the same way.Old base (existing images in Page Designer):https://dl.airtable.com/.attachmentThumbnails/ef32cff2ffea90eb9be2932d18a0a21b/ddc5a116‘New base (copy of the old one)  https://v5.airtableusercontent.com/v1/15/15/1678831200000/_Wi_DAKuC8szr6BlzQnjyw/Km2nzwS4ZxXQIDNQTz_3ecuRdUAxDCjWl28ZCMtGHhvZyz7XOtqigDn35qsUiMG2z4BzrsHnrKvhaz9ZFqBkBA/DjivglXPEKVSxzri7OF3EJJ0krPjkte7b-sdv6nzQzsI also tried to get the URL in my old base (by Copy Image Address) just to see if it changed, and it did, it also looks like this nowhttps://v5.airtableusercontent.com/v1/15/15/1678831200000/bMDAjMewmnEgBLgGb28nGQ/s_7J9bG7vzklQjaHpFVKnNLtOrOyunk4R-c7UJu8GgsVwBCasRXLf

Hi!   So I am an agent who books talent for conventions.  I have a base that has like 75 sheets in it.  Each sheet is a convention and on those sheets it is marked which talent is going to that convention.  My question is, can I make another sheet for the front of the base that is basically a "Master Convention list" which would list each of the talent in column A and then in columns B-whatever, list what conventions they are invited to (which sheets they appear on) I can't seem to figure this one out. Any help would be appreciated

Hi!Recently a form I made had several of the fields overwritten when I added another form to it. The field went from a text response to a file upload, deleting all the text responses. I can see the deleted responses if I go to the individual row items and look through the version history. Is there anyway to undo the overwriting on the field level?

Hey guys. I’m trying to simplify a de-dupe routine. Scenario: I have a significant amount of records I’m importing. Many have identical IDs but have one multiple-select field that is different. I need to merge those into one record to combine the multiple selects. My manual process has been to do the following: Copy/paste new data in. Run De-Dupe App manually, checking every record. This works, but it’s super time-consuming. I need to automate the process. Is there any batch process to handle this? It’s always the same result. Needs to merge against the ID. All other fields remain the same, the only change is the multiple-select field. Ideas? Thanks.

Hi, we have a Table 1 with many fields. We want to use the same fields for Table 2, with different data. Often we want to change some of the fields, such as formulas. So, suppose I modify the formula for my "Average Cost" field in Table 1. Is there a way to make the formula change identically for my "Average Cost" field in Table 2?

I am in year 2 of using a pro license of my Airtable workspace. My organisation is based out of Mumbai, India and since the end of last year our central bank does not allow us to make payments that do not require a two factor authorisation.Luckily our payment went through the first time around last year as we made the payment prior to this rule being enforced. This year when we had to pay for the annual subscription renewal we used a colleagues American bank card to make the payment as to avoid any issues - this card was used by another team in the organisation to successfully make a payment for an Airtable pro license a couple of weeks ago. This was the second American card we'd tried to use. Both were declined and we can't figure out why. Airtable support hasn't been of too much help and we risk losing a lot of data. Any and all suggestions welcome.PS: We are trying to update an account with approx. 7 collaborators

We send emails with prefilled linked to forms to thousands of users. Some macOS users running Safari cannot open the forms. They click on the link in their email client, and Safari opens a window showing nothing but a white background.Since we lack the staff to troubleshoot individual technical issues, we tell them to try Chrome or Firefox. But some users don't have other browsers installed and lack the skills to install a new one. The call I took last week was from a user who clearly wouldn't have been able to install extensions that could have interfered, leaving us puzzled.Is there anything else we can do to make our form more compatible with macOS and Safari? We are prefilling several fields, which remain hidden, and display a thank you page after submission. The form is opened by clicking a link in an email; it is not embedded into a Web site.

i was asked by a client of mine -when i upload an image or any other file - is it beeing screened for viruses or malware by airtable ? 

Hi All. This posting from my side aims to seek solutions from you. When I went to ‘Update sync configuration’ in a synced table of my target/destination base (synced base), and I wanted to change the name of one of the two sources I used to sync its data to the target base’s synced table, I could not do it. This issue is because I named that relevant source a bit too long. As a result, I could not find the three-dot sign at the end of the source label, which can be used to edit synced fields or change/rename the source label. To sum up, the problem here is caused by the long name of the source mentioned; consequently, the three-dot button is not available for use. Would you please share your idea on how to resolve this problem? Thank you.

This doc states that when “you change cell values, … [etc.], the link will automatically update in real time to show the most up-to-date version of the view.” However, I’ve got a setup in which Typeform submissions trigger Zapier to find & update Airtable records, and I can’t get the Airtable iFrame (embedded on my site) to update in real time. Am I missing something?