Other Questions

We own a company where we have a Done for you team member placement service and we want to track if they have filled in their End of the Day report every day. Right now I have: 1 sheet where we collect our team members names 1 sheet where we collect the EOD reports I would love to automate the manual work of finding out who DIDN’T filled in the EOD report by the end of the day (11:45PM) so I can follow up with them the day afterwards. I tried the automation, but I get a bit stuck here. Can someone help? :slightly_smiling_face:

Hello team. Once upon a time, I stumbled onto a report that shows me every shared view my base or table was using. I am looking for that type of report or list in my account dashboard, and in the specific base that I am trying to pull that list from. Any idea if there is something simple that displays this type of information? Thanks.

So I have a base with 2 tables - one containing the funding round details (FRD) which includes name of Startup, amount and investor And another table solely for investors - which I wish to import data from Investors column in FRD table. Now, the investor in FRD is input as a long text which is comma separated. I wanted the Investor table to automatically import this data from investor column - and import it into separate rows - with startup name on the side. I know something like linked record exists, but even there I have to manually select the investor - whereas I simply copy and paste data from the net, thats why I want the investor column data to automatically be imported in the other table. How can I make it happen? Sharing link for sample base for your reference, please guide. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious out

We have Enterprise account and I’m trying to do date ranges in Calendar/grid views - is that possible in Enterprise or only in Pro? I would think Enterprise account has all the features that Pro has, right?? Thanks!

I’m creating a field (with createFieldAsync) but it is defaulting to hidden. Does anyone know how to change that? Thanks.

I’m pretty sure I ain’t the only one that desperately needs this integration. I would like to have google maps with a navigation option because I’m using Airtable for managing my freight business, so I would like my driver to have google maps view based on my PU and DEL details. Also I would like to have a direct link, that will direct collaborators to google map if they click on that (maps view) or something like that. Or something like that already exists? lol

I have a table with many thousands of coordinates. I would like to search these data points by city or state or country but I only have the pairs. Does anyone know whether the Maps app can return such data? Alternatively, does anyone have any solutions other than the Maps app? Thank you!

I have written a payroll system in React.js. Using airtable as the database and netlify as hosting for my web app. When in development, I run in my localhost and I can update my records without any error 502. But when I deploy my production to netlify, it gave api update records error 502. Any helps will be greatly appreciated. Thank you.

I’m using the formula below to generate a date, where “Nights” is the number of nights a short term renter is staying, and “End Stay” is the date generated by the formula: DATEADD({Begin Stay}, Nights, ‘days’) When I try to use the formula generated (“End stay”) date in a Calendar (for “end date”), I get this error: The above fields cannot be displayed because “Begin Stay” and “End Stay” have configurations that are not compatible. I have formatted both fields have identically. I read in past messages that using DATEADD generated dates in calendars was possible, so I’m trying to locate my error. Is the fact that “Begin Stay” is in the formula for “End Stay” the issue? I’m a newbie – any help is greatly appreciated.

I am trying to create a mentoring application. So it has : Users Mentors adding their availability slots ( as Date/Time) Mentees seeking mentoring sessions (as Date/Time) Based on a match from step 3 above, send email with google meet link So far Ive been able to setup 1 as a table. Also 2 and 3 above as forms. For the 4 point above, how can I setup a table with Mentor, Mentee and the Date/Time where availability equals the requested time frame ?

I have a column in Airtable with multiple select field, I am trying to get Zapier to “FIND RECORD” from this multiple select field and return if it contains “Shopify”, the results will be “TRUE”. It should then update a google sheet with a checkbox “TRUE”. The multiple select field has value: Shopify, Woocommerce, Booqable I have been reading other posts and article, but couldn’t find the formula for “if contains”. Thank you in advanced for helping.

Hi there, I think I’m looking for a combination of VLOOKUP and CONTAINS, but I’m not quite sure. Basically I have two tables: Expenses: description - cost - category “papa johns 34532” - $34 “something from Facebook ads” - $54 “Hotel so and so” - $54 Rules: Lookup string - category “papa johns” - restaurant “Facebook” - advertising “hotel” - travel What I’d like to do is link the two tables, so that the expense table will have the category field automatically populated… IF the description contains a string found in the Rules table, then set the category to category of that table. I’m not quite sure how to go about achieving this though?

I have a form with the options of 1) firstname 2) surname 3) email. This goes into a table, let’s call it table1 I have another synced table (in the same base) from another base (let’s call it "table2). The primary field in table2 is a userID, not the email. I would like to look up the emails of the form submissions from table1 in table2. Ideally, if the email from table1 exists in table2, I would like the record from table2 to be linked to the appropriate one in table1. If this isn’t possible, I would like to adjust a property in table1 to “X” or “Y”. I haven’t found a way to get this to work, either with linking the tables or with automations. I would like the linking to happen automatically, and it doesn’t seem to work (I think) because the email isn’t the primary field. I thought it should be possible with an automation, i.e. “on form submission, look up email address in synced table. If exists, change status to X, if doesn’t exist, change status to Y”. But even when I try this I c

Here’s my code: IF(AND(Stage=“Closed Won”,(DATETIME_DIFF({Created Date / Time},{Opportunity Close Date},‘days’)-1)<=0),1,IF(AND(Stage=“Closed Won”,(DATETIME_DIFF({Created Date / Time},{Opportunity Close Date},‘days’)-1)>0),DATETIME_DIFF({Created Date / Time},{Opportunity Close Date},‘days’)*-1,"")) The output is a number but in a text format (I can’t sum, avg, etc) and it’s formatting to the left of the column. I put Value() around the whole thing and I’m getting errors in the records when doing that. Created date: Date the record was created Opportunity Close Date: Date the record was marked closed won I want to be able to sum and avg etc the column. Any help?

Hi, I’m looking for an app to build an Airtable Web App/Website, where the user can order directly from the application, with an add to cart button and thus a global cart. I’m currently using Softr and I’m new to it. There is the ability to add payment button but the user has to pay for each product separately. Maybe I should create an automattic table for the orders, so that I can calculate the global amount, instead of ordering each product, and thus create an paymetn button for the global amount. Is there a simpler way to do that ? I’m stucked

I am having a base with which user can add links to store them as resource directory. Now, the user has to manually add title and Link both on the form. So is there anyway that user just needs to enter the URL, and title can be retrieved and store directly in another field?

Hi, I am trying to build a text database that will allow me to work in modules, Often times the same text section appears over and over. My hope is to change only that section and it will update, wherever it’s being used. I am at the very beginning. Let’s say I have: MODULE 1 - Richt Text Field with a couple of lines and MODULE 2 - Richt Text Field with a couple of lines Somewhere else I want to combine M1 and M2 into one text. At the moment I am trying to do that with Record linking fields. I’m not sure if that’s the right approach. Firstly I can not control whether M1 should be first or M2. Secondly all Rich Text Formatting disappears in the process of merging the two with a formula. Do you have any ideas on how to best approach this? Thank you! Tobias

How to Share a single record from table with anyone (*without login needed), using a unique public URL?

Hey there! I have created a base for my Social Media Calendar in which I have a “master” table and then a separate table for Instagram, Facebook, etc. I duplicated the master table to create the others and selected to duplicate the records as well. On the master, I have a field where I select each of the platforms the post will go into. And then on each of the separate tables, I filtered that field to show only the posts that go in that platform. My issue is that, when I create a new record on the master, it’s not automatically filling them in on the separate tables. Is that not an option? I have it set up this way, so I can go on the separate tabs for each platform and indicate which time a post should be scheduled for since I post to Instagram at a different time than I post to Facebook, etc. I don’t want to have to create multiple lines, just to show the different post time. Any suggestions would be greatly appreciated! Thanks! Jenna

I have imported raw data from an evaluation form using linear values. Is there a way to auto search/sort/group/filter the data with <=2 and have a field where it then lists the names of the columns that return that value of <=2? This is kinda what I’m wanting from the data: John Smith (Client) needs training in Microsoft Word (2) and Microsoft Excel (1) but doesn’t need training in Microsoft PowerPoint (4).

Hello, how can i create a share link to each record in the table? Let´s say if i want to share a record on social media… Best regards KJ

Hi, I have an automation set to email an alert out three days prior to event. Can I set what time of day that sends out? Thank you

Hello All, I would like to create a conditional roll up from table 1 based on a column in table 2. For example, I would like to pull in the names of records into the rollup field in table 2 from table 1 only if their date listed in table 1 is after a date listed in table 2. Is this possible? In conditional roll up options I only can filter on criteria/columns from the original source table. Thanks, Sarah

Hi, I want to import a csv file as a table into my base but the looks is weird and hard to read for a human. I’d like to display it as a table. How to do that ? Cheers