Other Questions

Hi, I am looking into options or workarounds to check if a value of a record exists in database before submitting a form. Is there a third party software or tool that is compatible with Airtable to do this? or is there any workaround with an automation to submit the form and check if record exists. If it does not exist, open again the form and show an error message to fill out a correct email. I would appreciate any suggestions.Thank you.

Bonjour ma base de donnée est inaccessible code erreur Erreur : pglap8CuYfR3wcpGI Merci de m’aider.

Hi there, we’re new to Airtable and i have just helped one of our departments setup a workspace which is using a form to capture information via a shareable link. My question is around security, is there any sort of captcha so the form isn’t flooded with bots? Also, i don’t see where i can set an expiry to the form (say for a week or month), is that an option? Thank you

Hey everyoneThere use to be a feature for Groups in forms that seems to be missing now for new fields.When creating a form, you can create a group and add fields to that group.When you selected the Group, there was a permissions option for that Group where you can choose the fields to be editable or view-only.It appears that option is no longer available.This was incredibly useful for me. I was able to prefill fields in that group and it would prevent the end user from removing my prefilled option. This was really great when I didn't want to expose information in those fields to end user. I could prefill it and they could not edit it. But it was at least displayed there for them so they know what they were filling things out for. If this feature is gone, is there another way to prevent end users from changing prefilled fields in formsTIA!

When in data view I click a button that opens a URL, each time a new tab opens. To avoid that, I tried the trick of pressing the ⌥ button while clicking the button, but this time a .TXT file gets downloaded onto my computer on the clicking of the button.This is quite annoying, especially when you have to perform a button clicking multiple times. Do you have any solutions in store to circumvent this?I would appreciate your help on this.PS: I saw that this topic had already been covered in previous threads. But I thought that Airtable might have fixed this since the last time it was brought up.

I need to generate an image link that ends in .jpg or .png for the purpose of registering the product to GS1 (to assign a barcode). Is there a way to change the URL of my product image in Airtable so that it ends in .jpg? 

I need external parties to update existing records. I have successfully created a second base that serves as the receiver of the updated fields. I accomplished that by creating a form in the second base and using the URL from the form to create a formula field in the first base that will pass a record identifier to the second base. The URL works well and the record identifier from the first base shows up in the new record (RequestID) in the second base to match the record being updated from the first base. My problem seems to be with the automation. I am using when the form, from the second base, is submitted to trigger the automation. I then added update record to the automation. Based on a video covering the topic by Julian Post, I list the second table called New Update as the Table in the configuration. I list RequestID from the second table as the Record ID. For testing purposes, I add just one field in the Field section. I set it to dynamic and map the correspondin

I have a base called "All Owners."  How do I allow the individual records within that base to see and update their information ONLY?

Good day.I have a base that receives forms.  The form is a default for ALL events, and each event, via a formula, creates an unique form link that hides the event’s ID so that when someone submits a form, that ID is autofilled, and thus populated to the proper event.Now here’s the thing, I have another base where I have dropdown selections, but again this is tied differently, as the first one is tied to an unique even, so that won’t work. The dropdown selection allows us to see only those that meet certain criteria, however, in this case, for the event, it would be different for each event, maximum users if set, are met, then it would no longer show US their names.At least that’s the thought.So I was thinking in the attendees table, where the form is linked to, I could have a view that first is sorted by date created.  Then, there are lookup fields from the table with the event info(linked to the attendee table), of count of attendees, and

Hi everyone,I’m trying to set up an inspection workflow for electrical equipment on construction sites using Airtable as the main database.Each construction site has several inventory items assigned to it through a junction table.For every inspection visit, a technician should be able to:Start a new inspection report linked to one site. See all inventory items connected to that site automatically listed in a form. Record for each item: condition (OK / Defective / Needs repair), comment, and photo. Submit once → this should create: one “Inspection Report” record, and multiple “Inspection Entry” records (one per item). After submission, a PDF report should be automatically generated and attached to Airtable. I’m looking for suggestions on which tools or integration methods could handle:dynamic data loading from Airtable (linked items per site) crea

Hey, so my Airtable account got downgraded to a free plan, and I didn't get any warning.I had to pay extra to fix it. I emailed support over a week ago, and no response yet. I saw in other threads that my emails might not be going through because my email bounced once. I'm worried that's the problem, and I can't reach support, which means I'm missing important account updates.I guess I could change my email, but that's not ideal. Has anyone else had this happen, or can you help me get in touch with support quickly?

Colleagues, good afternoon!I work as a Staffing Manager for an outstaffing IT company. We use airtable to manage information on requests from our clients to IT specialists.We have created a table in the form of a dashboard in which we create request cards from clients with the name of the client, the name of the request (which specialist he is looking for), what rate the client offers for the work of this specialist and the status of the request itself (example in the photo).Now we want to connect analytics of our work with clients in the form of Charts and figures through the Interfaces functionality.It turned out to set up the calculation of the number of transactions for the period, the statuses of transactions for the period, and the average request rate for the period. However, we faced difficulties in building a conversion analysis report. Let's say what percentage of requests for each client reaches the status of 1st interview, what percentage of requ

Hi all,I know that in my organization, we have several bases that use integrations with other tools, including the Airtable → Slack integration. I don’t remember where I saw it, though. As an organization admin, is there a way for me to find out what integrations people are using, and in which bases/workspaces?Thanks, and happy Friday,Joe Montibello

I found something that talked about 216px, but it keeps doing this. 

Hey Airtable community - I’ve got a form we intend to use daily to catalog pictures of our daily jobs. The form I’ve made is linked to our “jobs in progress” page and the idea is then that we open the form “upload attachment”, “from camera”, and then snap a quick photo from someones, boss, employee, whoever’s phone. Then it should upload the pic and update the primary record. I’ve got it all working as intended, but the problem is the default picture size on everyones phone is 2 to 3 MB or more, and then we end up having to wait over a minute to upload different pics / angles of the job, when it should really be much faster. These pics are primarily just for liability, colour reference and potentially some social media so they don’t need to be high resolution. I was thinking maybe find a super old phone with smaller pics but seems like a wonky solution, wondering if there’s anything more elegant to speed it all up.

HiI am using Airtable with Fillout forms for a client project based in UK.  Apologies, this question is more about Fillout.I am happy that I can get request a DPA with Airtable in relation to GDPR.Fillout say that they are GDPR Ready but then state that only Enterprise customers can have data hosted in EU.Can we achieve GDPR compliance with Fillout on one of the lesser plans, with data hosted in US?Anyone in the UK in the same position who could maybe offer their thoughts?Thanks

I may be missing it, but is it possible to modify font/size of single/multi select fields in the page designer block? I can modify everything else, but I can’t seem to make these bigger or smaller or change the type of font they use.

I am trying to make a tutoring database and have it so when a tutor claims a students session as a record and add themselves onto the record via the fillout form it makes it so that when another student loads up the page a conditional tells them that someone has already taken the spot. The problem is this only happens if the person opens up the form page at a time after the tutor already submitted his or her form or if the person reloads the page. I was wondering if there was a way for the form to refresh instantly without the tutor having to click refresh to let them know that someone took the spot because if both tutors open the form at the same time and tutor A submits first and takes the spot. On Tutor B's end it still shows that he can still take the spot so when he submits it kicks tutor A off the spot and claims it as tutor B's.

This might have a simple answer that I'm just missing - my supervisor wants to stay logged in to her Airtable account instead of being prompted to sign in each time. I use Google Chrome and am able to stay logged in with my workspaces saved as favorites on my browser. She said she has hers saved in her favorites as well, but uses Microsoft Edge. I'm not exactly sure why mine lets me stay logged in, I've just never had any issue. Any tips on what she could try to get the same result? Thanks so much for your help!

Hemos creado recientemente una comunidad de usuarios de Airtable en el idioma español, con la idea de compartir conocimientos, soluciones y trabajos en plantillas (templates) en el idioma español para todos los hispanohablantes. Si quieres aportar a que existan más usuarios de habla hispana que conozcan esta maravillosa herramienta, por favor mándame tu correo y te agregaré al grupo de co-work que hemos creado. Necesitamos gente experta en Airtable con interés de compartir su conocimiento. Saludos

Hello,We are a large sales organization using the Airtable Page Designer to create PDFs in order visualize data from our commission tables. We have created the PDFs in the Airtable Page Designer, but do not know how to attach them back to the individual record within the table.For example: we have commission data generated from the table for the entire sales organization. We would like the PDF that was created for Bob Smith, to automatically pull back into Bob Smith’s record. We plan on emailing all of these PDFs to each individual rep through an automation.TLDR: How do we attach the PDF to the individual rep (record) from which the information was pulled.

I have been using AT for about a year now and love how I can incorporate it to my project management and our companies overall workflow. I am now starting to get the hang of forms but am wondering if I can take it a step further. Here is what I am trying to achieve: I understand that you can embed a form onto a website to get information shot back to your AT. I am wondering if you can do the opposite and share that exact form with another individual, with pre-fille information, a pre-attached file(s) without having to share the record with the person through email. When a record if shared from the original form, the information (record) just gets emailed to the person and that does me no good because I would like to have a “single select” field where someone can approve the form that is being sent to them. If this helps for visual/functional purposes: I want to send over a URL link (custom generated form) to individual customers so that they can approve or deny proofs

Hi everyone. I am able to get the following using Excel formulas but unable to find the equivalent in Airtable formula. Would appreciate any help here: [based on a given date e.g. 2020-11-25], show Number of days in a given month [30 days] Date of 1st day of this given month [1 Nov 2020] Days left in this given month [5] I tried workdays formula to no avail. Thank you. jamesquek

Is there a way to set the time zone for all tables in a base? I just noticed that my “where Ordered is today” filtered out all orders and it’s only 6:31pm – the day is not over yet. :neutral_face:

Hello! I run an auction house for a primarily text based MMORPG that’s PG-13 with the use of Airtable. Lately, we’ve received some submissions that are clearly meme/pranks. The problem is, that some of the material that have been submitted have involved nudity and acts that are lewd. Which breaks the rules of the auction house, as well as the MMORPG that the auction house is ran for (It’s the internet. Some players in the game are minors.). That being said, the staff for the game has asked that I grab the IP address of those that have submitted such images/content so that those users can be banned as appropriate by the game’s TOS. Is there a way for me to discover an IP address of the form submitter or figure out whom submitted what?