Solved

I'm missing two fields plus two new ones (4 Total) I have created in PowerBI from Airtable Base's. I'm extracting data from many Bases's, and only have a problem with a certain one. That data isn't special, the fields are simple "Single Select" Fields.I get no error's in the PowerBI query, it just doesn't show the four fields.

Hi allI've just got into scripting, and have fallen at the first hurdle. I thought this would load an array of all my records as objects, with each field in the object with its value as a a key value pair. let table = base.getTable("Contacts");let query = await table.selectRecordsAsync({fields: table.fields});console.log(query.records); However, it only seems to load the record id and record name. All other fields do not seem to be within the object.I have tried specifying the exact fields in {fields: table.fields}, and then console.log(query.records[fieldname]), but this also returns undefined. I'm coming from Python to Javascript, and I'm not a proffessional. Am I doing something dumb? Thanks in advance.

Hi All! I have an automation set up so that when conditions are met (i.e I select a certain label from a single select menu), the an email is sent out the the attendees that were assigned to that meeting.The problem is that it is only grabbing the first email in the email field and not sending to all the attendees. Is there a quick fix for this?Table has a Row for each meeting with fields for:Meeting nametimeroomAttendees (pulls from the stakeholder table and contains multiple people)Email (pulls email from the stakeholder table based on the Attendees. Data looks like: name@email.com, anothername@email.com, thirdname@email.com)Automation:Action Type: Send an EmailConfiguration: TO= Look upfield: "Email"   Token="Value"In the Table the Email Field shows:  name@email.com, anothername@email.com, thirdname@email.comIn the automation preview it shows only: name@email.comEmail is sent to only name@email.com Open to any ideas- Am I just missing a toggle

Hi all,The data from the table below is from another table using Automation:Once the status of a request ID is updated, then the update time of each status will be automatically recorded in this table.Is there any way to calculate the time difference between each of the statuses and then update the field "Duration"?I've tried putting the update time of each status in different fields(Image 2), but still failed at getting the duration.(Image 1) (Image 2)   

Hello there,I have been using Airtable for a month and I absolutely love it.I am creating a basic HR system. I want to create a formula for the employees’ paid leaves.How do I automatically make it add up in Airtable, using the Hours off (8 hours/day)?Is there a formula for that?Thanks in advance.

I'm new with these and I think i'm having a big mistake but I cannot find it.I'm trying to extract the number of hours for an specific duration record.Obviously I use HOUR command but it doesn't work!As you can see in screenshots, the field Hours works in the following way:Hour({Time})But, it generates ERROR!What am I doing wrong?Thanks!  

I have a Payment Interface with a Form that creates a new record in my Payment table.  There is a field for Dues Amount and another for Donation Amount.  Both are define with a Currency data type, and with a Default Value of $0.00.  In most cases only one of these fields will be updated by the User.  The problem is that the default value is not being applied to the field the User fails to update.What am I missing?  It appears that the Default Value feature that is available when defining the field characteristics (e.g., name, data type, default value), doesn’t work properly.

Hello! Does anyone know how the default view for an Airtable Record URL? I would like my automation (Slack notification) to open the record URL with a specific view in the background, but I’m not sure how to to do that. Thank you!

Hi,I am needing help creating a formula.It would be if (15% referral says no then it would calculate the daily rate times 15%), if (15% referral says yes then it would be daily rate)

Does Airtable have a way to create several new records based on the number of entries in a field? For instance: We have a request table that people can fill out a form to request being added to articles. They can request being added to multiple articles via a link to our overall articles list. These requests go into a request log, and then go to an updates log that tracks the changes to each article. The request log has an automation that creates new update records when the request is approved - but I can't seem to figure out how to have it create multiple update records if multiple articles are selected on the form. Right now, it's only creating the first update record from the request. 

I've used Zapier on and off for the last couple of years for small purposes. This week I used it for something important, and I'm wondering if the approach I took is the best way to solve the problem.I have a list of people (about 120) that I needed to send and email to. The email contains a link to an Airtable form that I want them to fill out. I defined a date-time modified field in Airtable that I used to trigger the zap in Zapier. The zap then connected to my client's Google Workspace/Gmail account to send the emails out. I was a little worried about how well Zapier would perform, so I triggered smaller batches of records, about 30 at a time. In the end, it worked fine. We had to do a follow-up email, and I used the same process, just with a different body content for the message.I didn't ask Zapier to do anything other than connect (record by record) to my client's Gmail account and send each message. After each batch went out, I marked those records as "sent" by hand (easy in Air

I'm trying to build a formula that will look up a currency value from a record, determine whether it is between two ranges of currency, and then enters a percentage (the federal poverty level) in a new column. I'm getting errors in the formula below. Any ideas about what I'm doing wrong? IF(  {yearly income} < 22763,    "125%",    IF(AND(      {yearly income} > 22763, < 27315),        "150%",        IF(AND({yearly income} > 27315, < 36420),           "200",          IF({yearly income} > 36420,             "Over 200%,      &nbs

Hi All,Hope someone can help!In our base we have multiple Proposals (in one table) linked to each single Sales Opportunity (in another table).I would like the proposal's naming convention to be "{Sales Opportunity} - Proposal 1", with any further Proposals linked to the same Sales Opp named Proposal 2, 3, etc. (ie not using an Autonumber field that simply counts all records in a table). Ideally the number will not change if an earlier Proposal is deleted (but not the end of the world if so).Is anyone aware of a way to do this besides manually?Many thanks!

Hi,In our base we have multiple Proposals in one table against each linked Sales Opportunity in another table. One Proposal will be the Primary Proposal and any others will be Secondary. This is done by selecting Primary or Secondary as a single select.If a Secondary Proposal is changed to Primary, I'd like any other Proposals linked to this Opportunity to automatically be changed to Secondary, to avoid there being multiple Primaries.Is there a way to automate this?Many thanks

Hello, I'm following this tutorial RASA - Custom submit action to get a chatbot to create a new record in a table. But my 'submit' action returns the following error: Exception occurred in one of response middleware handlers Traceback (most recent call last): File "C:\Users\user\Documents\rasa-dev-tutorial\actions\actions.py", line 54, in create_newsletter_record response.raise_for_status() File "c:\users\user\documents\rasa-dev-tutorial\venv-rasa-devto\lib\site-packages\requests\models.py", line 943, in raise_for_status raise HTTPError(http_error_msg, response=self) requests.exceptions.HTTPError: 422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/<baseID>/<tableId> Could this be the cause?During handling of the above exception, another exception occurred: ... File "c:\users\user\documents\rasa-dev-tutorial\venv-rasa-devto\lib\site-packages\sanic_cors\core.py", line 250, in set_cors_headers if resp.headers

Hi,I have an airtable database that captures information from a tally form.One of the fields in the database is date created which is a formula and is the date when the form was filled in.Anyone can fill the form and I want to capture the time zone of who is filling in the form.Can airtable capture the time zone (of the person filling the form) together with the date and time of when the form was filled?I want to sent email reminders with automations based on the timezone of the specific user and creating different automations that work well with the different timezones will not work in my case.Thanks  

Hello there. I've hit a brick wall with an automation I'm trying to build. I was hoping to use an interface button to identify all records in a table with an unchecked box within a particular field and then check all of those boxes. I have created an automation where the trigger will be the button, and have then added the "Find Records" action where the condition is all records with an unchecked box. That part runs fine in testing. It all falls apart when I try to update records using the list of Airtable record IDs generated by the previous step and then ask the automation to check the relevant field box of all matching records. Can anyone assist please? 

I'm working with a fixed asset inventory base with close to 6000 records.  One of the issues that I'm having is the slow record fetching after scanning a barcode.  My primary field is a formula field that pulls from the barcode field.  I have a view that only shows a minimum of fields that I need to update the record as last seen at location on what date.  When I select the current date to show when I last saw this record it lags.  I find that if I push the record up with a finger gesture on my iPad it seems to update quicker, but not always.  I've tried creating different views by sorting the barcode field to see if that would help the indexing of the field for faster record fetching, it hasn't.Anything ideas on what to try next?  My attachments are already over 20g and I'm less than half way done with the annual inventory.All the Best!Pablo

I've built a task list table, and have some recurring tasks that comes with sub tasks in another table that are linked.I am hoping that when my Task is completed, airtable will create the exact same task, except to change the dead line based a formula field, and link up to a new set of sub tasks also created once this main task is done.I am doing this because I want to keep record of when the records were completed, using the last modified date field.Is this possible? 

Hi all...I'm sure this has been asked before so apologies for asking again. I have searched but any article I think might give me the guidance I need ends up getting confusing...possibly due to my lack of understanding but I think at this stage, my best option is to ask myself.I've created a purchase order system and it's all working fine except for one thing. For the purchase order number, I want it to be "Year-Cost Centre-Number" with the number component being a sequential count of previous orders for that same cost centre. That sequential count is where I'm running into bother - so far all I've managed to achieve is a sequential count of all purchase orders which works, but it's not my ideal set up. My base structure is:Purchase Requests table - this is the main table and is meant to manage the whole purchase order processCost Centres - table of all cost centres, linked back to the Purchase Requests tablePurchasers - table of anyone with permission to request purchases (not re

I have an email automation running every day at a specific time.Is it possible with airtable to match the time the email is send to different timezones?Eg. the same e-mail is send at 2pm CET and 2pm ACT, etc Thanks  

So I use airtable to organize content for my websites and it’s been great. I initially started using it to create a web archive for a artist syndicate that needed a place to put up all their media, which is where I first encountered this issue. When uploading to wordpress using WP All Import Pro I need to have a bare url, but airtable dumps context into the field when you query the url. I was able to get around this using a regular expression to search for the beginning of the actual url and exclude everything before and ignore special characters. That worked fine considering that I only needed 1 attachment per post. Well now, I’m doing something similar to my own photo/video site and have created a portfolio post type where I can upload multiple photos into a gallery for each post. Thus I have multiple attachments per record in airtable, which the regular expression does not work with since there are multiple urls. So my question is how can I get airtable to spit out a completely bare

I want to create a unique share(public) link for each record, so I will send created link to each user, so each user can be edited only one record.Is it possible?Thank you! 

I'm in a pickle and I can't figure out what to do even though I've read a lot of posts here and asked ChatGPT to help me over and over but nothing.I've got three fields that are formulas but they're formatted into integer type. 1. {Fecha limite de adeudo (dia)} and it's formula:IF(OR({Quincena 1}, {Quincena 2}),IF({Quincena 1},17,1)) 2. {Fecha limite de adeudo (mes)} and it's formula:IF({Quincena 1},MONTH(TODAY()),IF({Quincena 2},MONTH(DATEADD(TODAY(), 1, 'month')))) 3. {Fecha limite de adeudo (ano) (number)} and it's formula:VALUE({Fecha limite de adeudo (ano) (string)}) I tried combining them the following way but Airtable says "the result type is not a number or a date".IF(OR({Quincena 1}, {Quincena 2}),DATETIME_PARSE(CONCATENATE({Fecha limite de adeudo (dia)},'-',{Fecha limite de adeudo (mes)},'-',{Fecha limite de adeudo (ano) (string)}), 'DD-MM-YYYY'),"") I want this last field to be a date/object type and I don't know why it's not working because the thre

I am working on a field that pulls a result based on a number range.   I aim to convert the number of days from a person's hire date and an incident date to a set phrase such as "Less than 3 Months",  "4 Months to 1 Year", etc.   My first field converts the difference between their hire date and the incident date to the number of days.   My thought was to create a formula that says if the number of days is between 0-90, then the result is "less than three months," and so forth.   My fields are "Hire Date", "Incident Date", & "DateDiff".  The field I need to formulate is "Length of Service".   What is the best approach to get my outcome?