Other Questions

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?

Is there a way to use Google Analytics to track table views?

This is not a new topic and I’ve read through all other topics on adding images to email automations using the <img> I use Airtable formula: IF(Attachments, REGEX_EXTRACT(Attachments, "(?:[^(]*\\()([^)]*)"))to create the url. The image file name has no underscores in it. I’ve done the img src=”formula url”/ and doesn’t work.I’ve done the Expiring Download trick and doesn’t work.I’ve created a long text field and added the whole image tag in it then pointed to the long text field in the email body and still didn’t work.I get the broken images. Results all attempts I’ve made below in image. Any insights where something is going wrong, I feel I’m almost there.

Just curious if anyone here uses a form on a website as a contact submission form. Do you have a problem with spam entries? I’m thinking of replacing my contact form with an embedded Airtable form.

I have a fairly simple database containing 5 or 6 tables. All of these tables are joined one way or another. I am trying to create a word document using Formstack and to run it via the manual integration which I intend to automate through the use of a button in an Interface when I get this working. I have built my first document and mapped all of the field tokens from my Airbase table into my Formstack document and it works a treat. I have now gone to build my second document which uses some fields from the table which I am in when I select the record in Airtable from the integration but it also references so fields from another table albeit in the same base. These fields do not pull through. I have recreated a link field and chosen to show the “add look ups” fields from the other table in the table where I am running the document form, re-written the placeholder references for Formstack and hey presto, it works! Is there any other way to do it wit

Hi there! I’m just curious how I enforce unique values in a column or a group of columns – that is, how to enforce a unique constraint. So that I don’t, for example, accidentally enter the same person (combination First Name + Last Name) twice.

I can't find the base and the table I created when I want to link it to Tally. 

Hi there — I suspect the answer is ‘you can’t’, but is there any way to restrict a user to only be allowed to upload a single attachment to an attachment field in a Form view?

HelloI can’t access Data/automation/Interface as I got this message. I tried a chrome icognito window to re signing but same issue. Is this widespread or only impacting my account? An error has occurredRefresh the pageIf you continue to experience this error, please contact us.Error: pgl44daDCB1bvrY3S

Today I noticed that the images I add are not showing up in the grid, kanban, Gallery, and Interface view. Some of the pictures will show once you click on them but they wont show as a thumbnail. and when I click to view other images they don't show the thumbnail nor the image, they only show an error message. I started to troubleshoot by trying to attach different image types and sizes but to no avail. I also tried attaching the same exact images from records I made last week but they too are now showing this error image:“Previews for this filetype are not available”File: dsc_6285(2).webp - 10.8 KBThe 3rd image will show when I click on it but it wont show as a thumbnail. The images I attached last week are showing up still, as a thumbnail. look at where the red arrow is pointing.  To clarify, yes, I am only clicking the “Add Attachment” button to upload my images. No automation.  I’d be very grateful if anyone can help. Please let me know

Hello! Anyone know how to set or change your name in this new community platform?I signed in with SSO, it just assigned me this name (jon21), and I don’t seem to have any way to change it 🙄. I also never received the ‘Welcome’ badge, in case that impacts how I initialise in the platform.

How do I change my community display name.When I established my community profile a few years ago, I inadvertently picked -airtable- as my display name.I need to change this because community members think I am AirTable when, in fact, I am just a customer. I am getting tagged on all sorts of discussions, and you guys are NOT getting tagged.How can I change this.

Hey there, so I’m all of a sudden, getting this error when trying to submit this form.  Any ideas what might have happened?

i have a form linked to my website for registration purposes. is there a way to prevent users from using the form after they have already used it for registration?

Is there a way to prevent duplicate entries in a particular column? Thank you!

My organization seeks ability to create Airtable based apps with a proper user portal for external users to create/register and log into their profiles.  Unfortunately, Airtable portals doesn’t fit our budget for the number of external users we might expect. (Approx 400).  (we have business plan by the way) Even Softr is pretty pricey, but it seems like a halfway decent option.  I have looked into many different options from Pory.io, Zite, Stacker, Noloco, Glide, WeWeb, Bubble.io, Jet admin, etc  even thought of possibly seeing if I could linked Airtable to a supabase and build portal in Bolt.  I am not very technical, but I want to learn how to do this myself and help build a solution or find the right one.   there are so many options, and let’s say the budget is $2000 per year for approx 400 external users.  This is on top of the existing seats paid for the business plan for internal user

I am experiencing an issue duplicating one of my bases. The details are: Base ID: appMbMonUXRj3FMXX Base name: QUAN LY TNC Issue: When I attempt to duplicate the base (both with data and with structure-only), the process never completes. The dialog shows “Duplicating your app is taking a bit longer than expected,” but even after more than 12 hours, the duplication does not finish. Troubleshooting attempted: Tried duplicating with full data → stuck. Tried duplicating structure-only (no records/attachments) → stuck. Tried in multiple browsers and workspaces. Waited over 12 hours without completion. Already tried to create a new base from a snapshot → still unsuccessful. Anyone have experiences in this matter?

I need to manage multiple deadlines for multiple projects & clients more efficiently. I don’t want to update deadlines in multiple places, but that’s where I am. This isn’t efficient and will not work for the long term. Here is the current setup:I have a Primary Base I use to manage grant research, tasks, and profiles for all of my Clients. This includes 2 key tables: a Research Table and a Task Table. The Research Table is filtered into views that are specific to each client. Each of those views are synced to a Table within a Separate Client Base. That Separate Client Base also includes a second Submissions Table that is manually updated with specific due dates and other requirements that are unique to that Client (although some research may be relevant to multiple Clients, specific details will be unique to each client). This Separate Client Base is shared with each Client. The Task Table

Is it possible to add simple text blocks within a form to break the form into multiple named sections?

I’m syncing records from a source base into a separate working table. New records from the source base are showing up on the sync’d base, but updates to the record (e.g. selecting a different single source field entry) are NOT syncing. The base is set up for automatic sync. Is this a bug, normal (i.e. updates to records don’t sync), or is there something I’m missing in setup?

Hi everyone, I’m teaching a course which requires students to label and recognize certain kinds of sentences. I have a list of sentences for them to practice on in a table and the answers in the next column. I’d like to set up a kind of self-study tool for students. The Flashcard App would work really well for that, can I somehow share that with my students? It’d be even better if I could randomize it. The ideal use scenario would be a multiple choice test that would grab, say, 10 examples and then reveal the correct answers to students when they submit. But I’ll take what I can get! Thanks!

Hello! I wonder if you might give a way of offsetting the “Q1”, “Q2”, etc markers on the Gantt timeline, to support a fiscal year that does not match the calendar year. Or, if not that, to hide the markers altogether. I realize there’s a way to use formulas to have fields reflect an offset fiscal year based on dates, but I don’t believe it’s possible to change this header and it’s very confusing for viewers. Thanks!

How do you reinstate a deleted record? It’s been 24 hours since we've noticed - is there a way to revert to a previous version?