Solved

Hello everyone, I am new to Airtable although not to databases. Thank you in advance for any advice you can give me. I am trying to embed a View of a grid table on a web page. The table gives information about traditional fiddle tunes (name, key, etc.). I had no problem following the instructions and getting the iFrame code. I modified the code slightly to change the width from the default 533 to 1200. My website is being built with RapidWeaver 8.8.3 using Stacks 4.2.2 and Foundation 6.8.4. Everything went well, and when I published the page the View was there and all the controls worked. However, when I looked at the web inspector (using Safari on a Mac running Big Sur), there were some error messages (details shortly). I tried embedding the View on other pages, decreasing third-party involvement until finally I just uploaded an index.html page created in a text editor. The result was always the same: the View functioned just fine but there were error messages, always about the same.

Does anyone know if it’s possible to run an if() formula for a keyword in a lookup field. (see screenshots below) Im looking to return a ‘true’ or ‘false’ if it contains the word “Floorplan” however i believe that the lookup fields are not considered searchable by the formula as it is returning ‘false’ even when the parameters are meet? Can anyone confirm if my suspicions are true and if so how can i go about making the lookup field compatible so it returns the correct answer in my if() formula Thanks in advance

Hi there, I’m read lots of topics here on updating single select fields in Airtable, but none through Airtable Automations. My input is a formula that generates a status (UPCOMING, IN PROGRESS, SENT) and the desired output is to copy this value in a single select field (UPCOMING, IN PROGRESS, SENT). I’ve tried to run this via Airtable Automations with different triggers (When a record matches condition, when a record is created and when a record is updated) but none seems to work effectively even though the run history tells me the run was successful. Seems fairly easy and yet do not understand what does not work in my automation. Anyone out there has already done this?

please help me. I have 2 tables, one for sales and the other for stock. The inventory table receives data (customer id and product) that is informed via a bot every time the customer goes through a certain flow. however, I need this product to be counted only if the sale is made. In the sales table you will find the customer’s id. and this table is only fed if the customer makes the purchase. So basically I need a column in the inventory table that asks the following question: if the sales table has an ID equal to the inventory table then 1 if not 0.

Hi, all. I have a field (Original PD…which stands for Original Plant Date) and I want to add or subtract the “Adjustment” field to arrive at the calculated “Actual PD”. In the Actual PD field, I used a formula: DateAdd(Original PD, Adjustments, ‘Days’) and I get the resulting “Actual PD” field. The problem is the math is not adding/subtracting right. For example in the first record “BR14A”. I have an Original PD of 12/12/2020, an “Adjustment” of 3…which should give me 12/15/2020. Yet the formula is kicking out 12/16/2020. Any thoughts on jaw to get this right? Thanks for any help. Paul

Good afternoon, I can generate a link to view the graphics generated by chart app?

Hi Community ! I would like ti send a record (exactly the same than when we are on the table and have a right click “Send the recard by email”. I’m okay with the condition and the email field. Just don’t find the action to send the record under this format. I looked to add a column with the record url but I can’t find it (function ?) Thank you so much in advance. Nathalie/ France

I have a contact list where one of the fields is “Referred to…” to show how I got into contact with someone. What I want is a two-way link for “Referred to/by”, like so: Name | Referred To | Referred By --------------------------------------- Jim | Amy | Amy | | Jim Bob | | For example, if we have three names in the table, eg. Jim Amy Bob Jim introduced me to Amy, so have it as Jim | Amy Amy Bob The problem is, when I link Jim to Amy, I want another column that shows that same relationship in reverse, a “referred by…” field. So it would look like: Name | Referred To | Referred By --------------------------------------- Jim | Amy | Amy | | Jim Bob | | So far, I’ve been unsuccessful at doing this. I’ve tried using Lookup but it only finds itself. Any ideas?

Hi community, I made an automation and the date is not the same/ Format in the table European. Should I make something special to avoid this ? Or did I miss something ? Thank you !

I have a scenario where i lookup a list of values for an item in a google sheet and want to add them as complementary values in one multiselect field for the item in airtable. in the shown example these are 12 category values coming from gsheet, which should all be added in a multiselect field for the user in airtable. The lookup in google sheets and the JSON creation and parsing work as expected - I get a JSON with the categories like the one in the screenshot below: The update in airtable works as well - as long as I have the JSON list elements mapped individually as single entries for the multiselect field, like indicated here: The problem with this approach is, that if my Gsheet Lookup and resulting JSON send less list elements to airtable than I have specified in the integromat flow, the extra fields will be sent as “null” and this causes an error in the Scenario. This is exactly the same problem as described in this post 10 months ago: Mapping Multi-Select Fields with Integrom

Hi! I am building some QA into my Base, and have x4 date columns that I want to check all equal each other. To ensure the first x3 dates equal each other I have used: IF(AND({Date 1}={Date 2},{Date 2}={Date 3}),“Match”,“Not match”) I think that is right and seems to work well. This all works fine, but the issue I have is that the {Date 4} column doesn’t always have a value (intentionally), and hence I want to ignore it in the date comparison if not populated. i.e. if {date 1}={date 2}={date 3} but {date 4} is empty, the formula should still return “Match” to signify that all dates match. I’m sure this is very simple, but I’ve tried multiple different IF statements and quite simply can’t get it to work! Any help would be greatly appreciated :slightly_smiling_face: Thanks.

Hello :slightly_smiling_face: I’m trying to create table with records based on two fields from another table. E.g. the combination of “Password” Object and its connection to “Write” and “Restore” Actions should create records with the fields “Write Password” and “Restore Password” in another table. Any suggestions on how to do this? Hope it makes sense :grinning_face_with_big_eyes:

I am trying that after updating a record in one table (Example: Table 1) this creates a new record in another table (Example: Table 2)

Hi, all. I have a table that has a “Planting Date” for a vegetable field. This record is linked to another table that contains the number of growing days (ex: 90 days). I’d like to use a formula that would take the planting date plus the number of growing days (90) and give me an anticipated harvest date. What’s the right formula? By the way, each week has a different “grow days” associated with it so hard coding 90 days into the formula won’t work. Thanks, Paul

Hi I would like to be able to create multiple linked records in one “run”. I do a lot of videos for lectures and have a base has with a “productions” table and a “projects” table. I want to be able to add a button in the “projects” table that runs a script the script should ask me how many new records to create in the “productions” table. and then create the records linked to the project This would help me when 1 projects has 30 productions. And because a higher demand for remote learning I get many request for many videoes - so time saved on place it time used in another:) Thanks!

I have a small hotel, and I wanted to calculate the number of stays each guest had with us. Is it possible that I can create a record like this and have the guest email and name as a variable for each column (see attached photo)?

Hi! I couldn’t find any informations about extending the existing Metadata API in a way, so there would be a possibility to update the structure of the bases, fields and so on through the metadata API. Let me describe myself better, what I mean by that. I had an occasion to work with Salesforce for some time. This is also a low-code platform, where instead of writing code whenever there is a repetetive task, you can do that by draging or clicking. Everyone knows the benefits of low-code platform, so I won’t be talking about that here. When using low-code tools like Airtable or Salesforce, everything is wonderful in developing stage, we can do that much faster, we have ready made API we can connect to other tools really fast, but when we finally go live with the MVP of the product and we have real users who uses the application we made, we would rather perform future developing and testing on some dev/test environments. Of course we can do that, but current way is just bad. When we fina

Hi Community, i’m extracting the date from the below string 27909270100235 = 1979-SEP-27 using a formula below DATETIME_FORMAT(RIGHT(LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),4),2)&"/"&RIGHT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)&"/"&IF(LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)>50,“19”&LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2),“20”&LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)),“DD-MMM-YYYY”) the result is ok, 27-sep-1979 but I’m trying to get the age by further calculations/formula but it seems it doesn’t recognise the date above to make further actions and I realised that the formatting tye in the field doesn’t recognise it too, and received below message Blockquote Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date. Blockquote any suggestions?

I have a table that tracks every donation made to our charity, which includes the title of the fundraiser to where the funds were donated. This is triggered by each new donation. What I need to do is find a way to AUTOSUM the donations by the fundraiser title. The stick in my widget is that this number will be constantly updating as more donations come in. Currently, I can group by single select and see the AUTOSUM for each fundraiser. As new donations come in, this number automatically updates. Gorgeous. Since I need that number to use in other places, I’ll need that value to inhabit a single record. What I’ve tried to do is create a NEW table to do a ROLLUP. My issue with this is that I need to manually add each new donation to get an accurate snapshot of the current SUM. Since this value will be used in client-facing data, it has to be up to the minute. So, if a new donation came in for Sam’s page in the first image, the sum of the grouping would increase. But the record in the li

Hello When building a simple base of entities (Let’s say Peter, Paul & Jack), i add a column to indicate there’s a link between two (or more) of them. Doing this, i use a Link to another Record in the same base. So when i’m linking Paul to Peter, i see Peter in the “link” column of Paul. But no link appears with Paul appearing in the Peter entry. Is there a way to link two entries in a simple bidirectional way ? It sounds so pretty simple, i can’t believe i have to do it twice for each link between entries. Or should i use a graph tool instead of Airtable maybe for this kind of analysis ? Regards, A

Hello, I am sending an email through an automation action. Within the body of the email, I want to include an email address, but I don’t want it to be clickable - it’s just there as an FYI. Is there something I can do in the markup so the email address isn’t clickable? Thanks all!

Hello all, Now, I want to count a single select quantity from a different table Table 1 like this Table 2 like this And I want to count Table 1’s status quantity I want the result in table 2 show todo 4 in progress 2 done 2 Does anyone know how to do that? Thank you all. David

Hi, I send the form results through a Webhook to Airtable Automations and somehow, I can’t see all the data in the Airtable variable. For example: choices. Can someone help? The original JSON is pretty long but less than 100kb. Attached part of the JSON: Headers User-Agent: Typeform Webhooks Content-Type: application/json Payload { "event_id": "01F2RCN9Q5F24TTF2MY2G4FAB8", "event_type": "form_response", "form_response": { "form_id": "gfSaLT", "token": "tc3nuwsqelb7q8a5m82tc3n7nkr9a5zc", "landed_at": "2021-04-08T09:21:44Z", "submitted_at": "2021-04-08T09:22:54Z", "hidden": { "interviewee_id": "123123", "interviewee_name": "My NAME" }, "definition": { "id": "gfSaLT", "title": "Pre-Interview Form", "fields": [ { "id": "e2Hswr4jWPs1", "title": "תמונת פרופיל", "type": "file_upload", "ref": "a1c008b2-7a9c-42bc-9a6c-6e9afcb935a4", "properties": {} }, {

Hey everyone, I have a Deadline column (date) and a “Urgency” column in a sheet. I want any row/item due in less than or equal to two days to be marked in other column as Urgent, and I want anything longer than that to be marked as Not Urgent. I’m guessing there’s a good formula for this, but I’ve poked around for a bit and haven’t been able to find one/do it myself. Any help is much appreciated!!!

Hello, I’m using WEEKDAY() to show me which day of the week (Jour (#)) an order came through. For some reason, the formula shows me this : Orders with different dates 15/04 and 14/04 shouldn’t show the same Day Number in Jour (#) which is where WEEKDAY() is applied. I know it’s related to the fact that these orders came between 00:00 and 02:00 am, tho I don’t know how to resolve this. Any idea ? Thanks