Ask the Community

Hello all,I'm developing integrations with other third party providers where I can supply a URL and they ingest that information. However, I was told there were errors with the image.On investigation, the "type" provided by the API (image/jpeg). However, the HTTP Content type is actually binary (application/octet-stream) and the filename is inlined in the content-disposition. I understand this may have been used for file downloads, but this post seems to think this isn't necessary. This seems more like a bug, as really the "type" is provided by the API, so I'm not sure its not set b the content-type. Would this ask be possible? I've been running into this issue several times. My

I have attached below all the images.In number, it gives me 100.In percentage, it gives me 10000%but I want only 100%   

The Team plan is $20 per seat/month billed annually. Does the "per seat" mean users? So if we have 10 editors, it'll be $200 per month? But the plan also says it includes unlimited editors. It's very confusing...

Hi there! I have a table containing my product in airtable. Also, my products on my website that build on WordPress. How I can update my product status on WordPress based on availability in my airtable base using Integromat?

I often copy data from several fields at once, so I need to use a horizontal scroll to select all the data, which is not really user-friendly. That’s why I thought maybe it’s possible to create a button field that copies data from some fields of the same row and sends it to the clipboard. I did some research and figured out it can’t be made with built-in Airtable features. I guess custom scripting may help, but I’m not familiar with JS, so I have no idea where to start or if it’ll even work:sweat_smile: Any help would be greatly appreciated!

Hi Community, I am attempting to develop a QC DB for my international QC inspectors, in my dept we manage over 18,000 unique item id’s manufactured by over 400 factories, in 20 different countries . I keep a list of Item IDs and Factory IDs on a source of truth database which I have synced to my prototype inspection DB. For Simplicity Sake, these two tables, within source of truth DB, are as follow, Item IDs Table Primary Field( ITEM IDS) Secondary Field(Factory IDs-linked to Factory IDs table) Factory IDs Table Primary Field(Factory IDs) Secondary Field(Item IDs-linked to item IDs table) Within my inspection database, I’ve created 2 linked fields within the inspection table. Filed One(Factory ID-linked to factory IDs) Field two(Item IDs-Linked to item IDs) I would like the QC inspector to enter a factory ID in field one… after which I would like the QC inspector to select an item ID in field two… And alas we reach t

I'm trying to update a field name in a table using the script below, but getting this error: "Cannot update field name from scripting automation at main on line 22".  Has anyone else run into this problem?  let table = base.getTable("tblxxxxxx");let field1 = table.getField("fldrxxxxx");let today = new Date();let quarter = Math.floor((today.getMonth

hey there,how would i go about creating a formula column where if a timestamp from a column (let's call that column "timestamp") is older than 24 hrs, then the resulting value would be "follow up", otherwise the resulting value would be "do not follow up" Thanks!!

We run a charity vege farm. I'm building a crop planning tool. For planning, a couple of pieces of key information about a crop are:-Number of weeks from Sowing in the nursery to Transplant (Weeks to transplant - WtT)-Number of weeks from Transplant to Harvest (Weeks to Harvest - WtH)I use this info to predict how long a crop will be in a part of the farm for, and planning to ensure we have the right amount to harvest at different times of the year.In summer, a crop like lettuce may have a WtT of 3 weeks and WtH of 6 weeks. In the middle of winter, that may be more like WtT of 5 and WtH of 10.There is a whole spectrum in between those dates!How would one write a formula for WtT and WtH to be adjusted according to the date of the year? There are input fields for "sowing" and "transplant" which would act as the date to adjust WtT and WtH for.

My table has four fields: Total Price, Total Paid, Amount Owed, and Payment Status. When the value of Total Price and Total Paid are the same, the value in the Amount Owed field, predictably, shows "$0" – however when I use the value of {Amount Owned} in a custom formula for the Payment Status field, it shows up as "7.275957614183426e-12" i.e. a near-zero value, but not zero. This is causing my formula to break, although I can work around it by checking if the value is "< 0.01" instead of "== 0". This appears to be a bug in AirTable, Total price is a manually entered currency value.Total Paid is a rollup field, summed from a different table using SUM(values)Amount Owned is a simple formula subtracting Total Paid from Total PriceAnd Payment Status is a formula that looks like this:IF({Total Price} > 0,  IF

Thought it's worth flagging the localhost security issue in Chrome again:I've tried setting various flags in Chrome without any luck. Am developing in Safari on Mac for now.

I'm working on creating a .csv to upload time shift data into another management system. (I don't have control over it.) The datetime format it requires is YYYY-MM-DD, HH:MMa. Airtable is setup without the comma. I'm struggling to create a formula to add the comma in. 

Hello,I am very new to Airtable, and would love some advice or guidance bringing a few ideas to life. I am using Airtable for an applicant/candidate tracking system, interview scheduling, and job tracking for a recruitment firm.The current set-up is that we have a master database table that houses any and all candidates we've ever spoken to for any role, past or present, like a CRM. In the master database, I have a "Considered for" column, which shows which role(s) this individual has or is being considered for. Then we have a table for each active role.1. I want to create a formula/linked workflow so that if an applicant's "considered for" column is the same as the name of the open role of another table, they are automatically added to that table. Example: We are opening an Account Executive role and create a new table for it. If an applicant's "Considered for" column contains "sales" OR "account executive," or their skillset keywords include "sales," then they

I'm creating a database to track the donations of our organization members and their households. My goal is to be able to create an interactive Interface for our Board to see the percentage of giving households vs non-giving households in any particular month. For example, if 6 out of 10 households gave in October, I'd want to see 60%;  if 3 households gave in December, I'd want to see 30%.Here's how I have the base set up so far:Donations: Every donation we receive is marked with the date received, the amount donated, the Member who donated (linked), and the Household the member belongs to (linked)Members: We have 100 members, each listed in this table and each linked to their Donation (if they've donated) and a designated Household (below)Households: For simplicity of illustration, I'll just say that we have 50 households (two Members in each Household record). Because all the records are link

posting on Facebook date and time from my table doesnt get me the same format on the post (2020-12-17T06:00:00.00)this is the outputthis is my input 

Hi guys, I have created a "date field". 3:19 pm is my current time, but once I had it created, it showed the wrong time - 12:00am, I tried to click "use the same time zone for all collaborators> GMT/UTC", but the time was still wrong. I don't understand which step I had made wrong. 

Google calendars that are imported to Airtable - it looks like only 20 google calendars are allowed to be imported on a base. If we need more calendars on a base, then we need to create a new base? Is there a way to get more than 20 google calendars on a base? Please see screencast and pic attached

Hi everyone,I hope this message finds you well. I recently accomplished the successful synchronization of my Airtable base with my WordPress site using the Air WP Sync plugin. During this process, I also had to integrate Advanced Custom Fields (ACF).To map the content from my base, I utilized the custom field option within the plugin, and it worked seamlessly. However, when dealing with multiple selection type data from Airtable, I needed to convert it to checkboxes.Here's where I could use some assistance: I am unsure how to effectively utilize the selected options from these checkboxes. It seems that the plugin only compares labels, and I am unable to find any ID or value associated with the selections. I need to perform a verification of the received data but cannot rely solely on the label text.If anyone has experience or insights into working with the data received in WordPress through Air WP Sync, I would greatly appreciate your guidance.Than

Hi, I need help on the automation that I'm currently building. The section where it says "From name" on the Airtable Automations is not working. The email being sent is still the actual email address used, I want it to be the exact name of a person and I have linked the value on the section correctly, but still I'm having issues.. Hope you guys can help me figure out. Thanks in advance!

I would appreciate an option to limit the available times to schedule records to work hours (9 to 5). We can limit the dates shown to just weekdays, but available times are all over the date (2 am, 10 pm, etc.). This needs to be an option as someone may have events or projects outside of work hours or use the date field for something else. I have a manual entry date field for scheduling tasks on the calendar, and the UX is not optimized for selecting a time within work hours.

Hello, I need some help to find a solution for this task:I have two tables, on contain a columns called small, tall and month. The second table contains the columns small_december and tall_december.I need to write a script that looks for the record month of the first table and names of the columns if they contain the word, in this case December. if the condition matches the data will be copy from table 1 and bring it for table 2. 

Is there any way to change different versions of domains to its root domains? example: If we add Column 1 https://www.domain.com/ https://domain.com/ https://www.domain.com https://domain.com http://www.domain.com/ http://domain.com/ http://www.domain.com

Anyone found a way to control the font size on Print View?

Hi all -I have a table that acts as a timesheet for the same users to submit hours each week.I use the 'Hours Logged' from Fig. 1 (which is an entry for that week) and add it as a lookup value to my table with my people names (Fig. 2). There's multiple entries in the Hours Logged in Fig. 2 as it should, but when I go to my main table, it doesn't show the 'Hours Logged Sum' for that week. Instead, it shows it based on all entries. Is there a way so that I can get the 'Hours Logged Sum' to show what the sum would be for that week like a running sum for each individual? As an example, how would I show that the hours logged sum would be: Hours logged = 3.0; Hours Logged Sum = 3.0; Max Hours = 40; Hours available = 37Hours logged = 1.0; Hours Logged Sum = 4.0; Max Hours = 40; Hours available = 36Hours logged = 5.0; Hours Logged Sum = 9.0; Max Hours = 40; Hours available = 31Fig. 1

Hello!Currently I have a button column linked to a column with a webhook. When I press this button, the webhook is triggered and the row informations are exported to Make.I want to get in a column, the number of times the button has been triggered (+1 each time).Do you have an idea ?Cheers