Other Questions

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

How do I update Vega-Lite code to make what is Airtable match the bar graph below? I believe I need to use the “grouped bar chart”, but I’m not sure how to make it recognize the data fields

I’m trying to create an Integromat scenario, and failing. I’m essentially trying to keep two bases in sync. The first base (the "Production BOM Test below) is our production base and contains the active BOMs (bill of materials) for our finished goods. The second base is a base that contains all of our BOMs and where all of the BOMs will be managed. You can see that the BOM in the archive base has added part E to FG A, and removed part D. What I want integromat to do is see that I have selected FG A needs to send an update to the production base, delete all the existing records in the BOM table of the production base for FG A, then create new records that match the information in the archive base. I have been able to get integromat to delete any records in the production base that has a “name” that matches what is in the archive base. However, that means it’s not going to find the record with the name “FG A - Part D” to delete it (since that’s not a record in the archive). I really

Hi, I imported a database from Google Sheet - which has a date column. Now when its imported - its being taken as long text. Further, when I’m trying to convert it into date - its incorrect converting day as month and month as day - and some cells are even coming as blank. Can someone help me understand how I can fix this? Screen recording attached - Loom | Free Screen & Video Recording Software Sample table (editable) - Sign up - Airtable

Hi guys, I have two tables. Table 1 is called Contacts (contains contact and deal information), Table 2 is called Questionnaire (contains a series of long text questions) and is linked to table 1. I want to set it up so that when a contact completes my questionnaire through the link I provide them, the data they have provided in the questionnaire form will be automatically attributed to their record in the Contacts table. I’m hoping that by doing this I will then be able to view the contact and from within the contact, open up their questionnaire responses. I have considered having them in the same table however the contacts table already holds a large amount of fields. Through my research of this issue I have found and followed a Airtable guide called “Use case: update records via a form”. From what I understand, this method uses a field in the Questionnaire form that is prefilled and labled “please do not change this portion of the form”. Unfortunately I cannot use this method as it

The new interface is interesting, but it takes like four click to get to an interface. is there a way to customize a person’t first screen that they see?

Hello! Is there a way to have linked fields in a table display as a color identified by a field in another table? For example: I’m trying to set up a social media calendar. I’m color coding by platform in table 1. So Facebook, Twitter, Instagram are all different colors. In table 2, I have post topics I’m displaying all posts that are about a certain topic in the linked field. I’d like those linked posts to display as the colors set up in Table 1 for Facebook, Instagram, Twitter, etc. Please let me know if this doesn’t make sense. Thank you!

Why won’t this work? I feel like I’m following instructions to no avail. Tried every possible combo with the duration field, same too long result that I can’t calculate. Field 12 is where I’m trying to get the result of for example Date 5:30 pm, with run time of 120 minutes, would then result in same date 7:30pm. The fields are as follows Date and Start Time, Run Time, Duration, 60, Duration as seconds. 1/23/2020 5:30pm 1:42 102 60 6120 I’ve calculated run time as seconds, used that - I love airtable but some simple functions are tough. Here’s the formula (or one of them) I thought would work. DATEADD({Date and Start Time}, {Run time}, ‘seconds’)