Other Questions

I am building a big trivia game for Alexa. I have a User table that keeps all of my relevant data about my users. This includes rollups from other tables. I have another UserQuestion table that holds a record for each time that a user attempts to answer a question. They are timestamped, and marked with a checkbox as “Correct” or “Incorrect.” I would like to be able to roll-up a user’s current streak of correct answers. So, for example, if they have gotten their last 4 questions right, my rollup field would show the number 4. If they get their next question wrong, I would want this counter to reset to zero. I can do this in my application logic, but that requires querying this base every time, and doing the calculation on the fly. I’m trying to get Airtable to do the heavy lifting for me. Any recommendations?

I have purchase Order:- numbers in my table and i have scanned up Purchase orders saved on my pc to the same number can I automate the up loading of these images to the same record with the coirrect number example Field number 101 I require a attachment from my pc to be added ( attachment is named 101 also )

hello everyone, sorry if my english is not very good, i will try to explain my problem to you. I would like to retrieve the longitude and latitude through a script on airtable using an api but i dont know how to do it, can you help me please i am really stuck. thank you

I am very early stage in developing a business to business tool/template (evaluating into an app ideally) starting from a logical dataset that i want to set up in airtable. I have been doing this work for companies for over 20 years, know where i need to take this, but don’t know how to work the tools. I am looking for a logics expert to work on this with me, be a sparring partner or even point me in the right direction with Airtable and prevent re-inventing wheels in any way. Looking forward to hearing from you and talking through the project that I am very excited about. thank you - Leoni

Hi, Firstly … sorry for such a basic question but I’ve been through pretty much all the options a few times and still a blank look on my face! I’m planning to migrate over from Knack.com, here it’s easy to set a url column of data and change it to a hyperlink so it shows another field’s data as the hyperlink text. So for example you have a column of Product Titles and when clicked they go to the url in a new window. Simples! Also their formula field accepts html so you can create <a href … code with the other field variables. But … how do you do this in AirTable. I’m hoping there is a way as I was under the impression AirTables is an upgrade and more developed. Fingers crossed! Here is what I’ve tried: Formula field: doesn’t seem to like html so I can’s put … <@ href="{Product Link}" target="_blank">{Product Name}</@> … (I’ve put @ instead of a so you can see the code) Button: I can select the url field but there no way to add a field variable to the hyperlink/button t

Hello, Currently I have a Pro Plan with only 1 billable collaborator and I need to transfer the ownership to another user. But my concern is to follow these FAQ instructions (How can I transfer ownership of a base or workspace to another user? – Airtable Support) and being charged for adding a new billable collaborator. Is there a way of replacing the owner without being charged for a second one, since I have to add the new owner before I remove the other?

Hi everyone! I m making a custom Time Tracker Tool for our company. We have separated tables for people, project and time entries. In the last table, we record how many ours our people work in each project , each day. So we want to summarize how many hours each one has work. I can make the group by view, but I need to take the summarize of hours. Can you help me? Thanks!!

Hey there, I have a question: When I open a record through clicking on it in a linked record field, what determines the order and visibility of fields that I see on the record? I often see fields that aren’t helpful for me, and I wonder: what do I have to do to make sure that certain fields are visible and appear at the top of the record? Thank you!

Hello Airtable community ! :grinning: I am once again asking for your advice. My problem is that want to remove a month on my date formula which is : UPPER((DATETIME_FORMAT({Date}), “MMMM”)) So my result looks like this “FEBRUARY” but i want my result to be -1 month so if the date is FEBRUARY, i want it to be JANUARY. I don’t know how to do that can somebody help me ? :thinking:

I have the following situation: a column of type multiple select some possible values amongst which a value with a comma in it When exporting to CSV, in the CSV file itself, that value appears wrapped by three double quotes, like this: “”“this, that”"" which according to the CSV RFC, means that the value in that field is “this, that” (including the surrounding double quotes), as double double quote is the escape of the actual double quote. What I want is the value this, that (without surrounding double quotes). I have read "Unwanted Quotes" in CSV , but there seems to be a special issue with the multiple select column where the double quotes are added twice, it behaves differently than for a simple regular text column.

Hi, I’m creating a table to track playlists and their curators. To stop me from adding duplicate records by mistake is it possible to set a requirement/validation on a field that all data must be unique. To be more specific, I’m currently using Knack.com where I can set a field to ‘Must be unique’ and I am using this on the ‘Playlist Link’ url field. This means when I’m adding a new record it would tell me if I’ve already created it - thus avoiding duplicates. I understand the Primary Field (the first column) is automatically set like this. But having the url as the primary field is not ideal as I’m assuming it will show up in the various views as the main field. Or I may need more than one field to be unique. Is this possible in AirTable … my fingers are crossed. Many thanks for reading my post. Best wishes Nick

Hi, I have a database with a lot of books in it, along things like Imprint and Author there is also a lot of text explaining what the book is about. When I export it, the text gets all messed up, because there is a lot of commas in the text-column that has nothing to do with the delimiter. If i could export with other delimiters this shouldn’t be an issue. If I could wrap all cell content in quotes, this shouldn’t be a problem. But right now it is. Does anyone know a workaround? Thanks,

Hi, I really want to use Airtable for Data Entry but have the following problem. I’m not very technical so any replies should reply to me like I’m 5. Airtable exports CSV with comma separated values. The third party database I’m importing into only accepts semi colon separators. How do I transform the comma separators into semi-colon separators? Related Notes: I have access to both a PC and a Mac. I live in Australia where we use commas as currency decimal separators in our system settings. I tried just find/replace of the commas with semi-colons but of course this replaces all my non-separator commas in paragraphs into semi-colons. :slightly_smiling_face: I thought maybe I could put my paragraphs in Airtable between quotation marks and then somehow use something to say “whenever there’s a comma inside a quotation mark, don’t replace it with a semi-colon.” But I don’t know how to do this. Anyone have any suggestions?

The problem am facing with my base Many repeated questions or similar (%40 similar to other question) I want to label every record/question (old or new records ) Any new record > it look for any similar record and link to it , and link relevant data like year , month (like 6 similar records) +its link + state date example Jun 2020 , July 2020 , feb 2019 Also label each question with either two options 1-Unique 2-Repeated (some question are similar to this question or exact duplicate)

I am a volunteer that built a base for Grants Tracking for a nonprofit, using my gmail account. I am the Owner, with 3-read only shares to the nonprofit staff, while I created the base and am loading it for their Grants Team. The nonprofit is approved for discount rate. How do we upgrade plan? If I do it from my gmail Account Ownership, then it is full price. Should steps be: Transfer ownership of base to nonprofit rep who is approved for pricing. How do you transfer ownership of a base? She upgrades with nonprofit credit card to Pro plan Nonprofit has to pay for two - Base Owner and me as the volunteer collaborator Am I missing something? Thank you for helping us use AirTable on a shoe-string! It’s a fabulous tool

Dear Airtable community, We are proud to announce that we have launched Pro Backup for Airtable, the first dedicated backup for Airtable that backs up all of your precious Airtable data. Discover Pro Backup for Airtable In short, Pro Backup is a safe & simple backup app that offers the following features: Quick and user friendly onboarding process - setting up your Airtable backup only takes 1 minute! Daily, automated backup that captures all of your Airtable data including tables, views, comments, files, formulas and automations. Daily sync of your Airtables to Google Sheets so that you can access & download your Airtable backup at any time Snapshot export to CSV to retrieve data from a specific date Recovery export to retrieve tables that were permanently deleted in Airtable. More advanced restore capabilities will be added very soon! If you want to protect your company against human mistakes or disgruntled employees, or any other worst case scenario then this backup app

Hi everyone i need help on a form View. I’m trying to build a form with field conditionned by read only field. But the form don’t (White page) when i put the following condition (when i delete the condition, it appears !) ! 1|700x374 Have you seen something like this before ? Thx !! Polo

This is probably a bug? But copy pasting a value into a linked record is not working for me. It used to work before… It says “Pasting…” but then doesn’t do anything… HELP!

How do I format currency with commas/decimal points in a formula, if the output is a currency and a word? If it was just currency I could use the built in formatter but since I have a word in there it isn’t an option. What I’m currently getting: “$” & {Amount} & " - " & {Vendor} $1000 - Utility Bill What I want: $1,000.00 - Utility Bill

Trying to understand why records that are filtered out still show up in Kanban View. Do I need to go in & collapse or delete each item if I don’t want it to show up at all? Also curious if trying to print from this View is even desirable. Haven’t been successful with printing multiple records in the Gallery View or the Page Designer app.

Printing multiple records in Gallery View seems to present the same issues that the Page Designer app does. I can only get 3 records to a page in Portrait, 4 in Landscape, but the outlines (& then text) are either cut off in Landscape or spill over onto the next page in Landscape. If I try changing the scale, it gets worse b/c it readjusts by record, not by page so everything starts to get cut-off, spillover haphazardly. Is there just no solution other than exporting this to another program if I want to print???

I’d like to find an Airtable expert/master that I can work with to build my databases as I scale my startup. -Add complex, logic formulas to fields -Suggest databases that will improve efficiency -Review overall setup, and work to Improve Flow Let me know if you are interested, and your level of expertise with the Airtable platform. Email me at: manuel@wokoloco.com

Hello All, We use an application developed on the airtable platform. However, we dont have an option to use a mailing system with in the application rather we manually copy the content and paste within the application to be able to maintain the transactions. Does Airtable platform support emailing where i could send and receive emails using my work emails domain with in the application itself ? Would appreciate your suggestion. Thanks Sma

I am looking to make a living (the dates can move forward, but not backwards) availability matrix that can live on my website. Its for a boutique hotel property that has different room themes. I would like to display the rooms (there are 11) and their availability as a price when it is available and an X when its not available. I would like the availability to show starting today for 14 days, where the user can skip forward via picking a date on a calendar. Ideally the rooms are as rows and the dates are as the columns. I get the check in and check out dates as well as the trailers added to a spreadsheet when someone books, and I would like for that info to be update on the availability matrix grid. Thank you in advance for your help! Rebecca

Hi, I am looking for a way to get lead data by creating a form with specific fields like profession, industry, etc. After filling in the form, the user gets access to a unique download link e.g a pdf document, either by presenting the download link directly in the thank you page or through an email with a unique link to the digital file. What are the possibilities here with airtable? I was thinking of creating a base with the lead data and one with the digital downloads. The type of digital download dictates which form fields should be filled in, so they can differ per download. I am new to Airtable so maybe I am missing some pieces to the puzzle, or airtable might not be the right solution for this. Greetz , WJ