Ask the Community

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 the issue, how the heck to I configure field 2(item IDs) to only popul

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() + 3) / 3); // Get the current quarterlet year = today.getFullYear();// Calculate the prior quarterlet priorQuarter = quarter - 1;let priorYear = year;if (priorQuarter === 0) {  priorQuarter = 4;  priorYear--;}// Calculate the date for the prior quarter's last daylet priorQuarterLastDay = new Date(priorYear, priorQuarter 

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({Amount Owed} > 0,    IF({Total Paid} > 0,     "Partially Paid",     "Unpaid"),   "Fully Paid" 

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 are automatically impor

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 linked above, each Household record shows the two linked Members and all the linked Do

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.Thank you so much for your time and assist

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 http://domain.com Column 2 Result in all rows of above 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 Fig. 2^ Shows the running sum here, but it adds them altogether for every entry that matches the

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

Hi everybody!I managed to sent emails from linked table. But now I ran into a problem. I have two linked tables, one for RMA requests from customers and another for a list of repairers with their emails. When I want to send a product to the selected repairer, I want it to be sent to an email that is entered in another table of repairers. This works, but many times it sends the same email to other emails that are in the same table (so it sends an email to the entire list of all emails in this table). When I was working on automation, I used lookup field of the email address of the srepairer from the second table and sent the email from the first table (customer requests, because it is related to a specific product and customer). In the automation for the "to" field, there is no way I can select anything other than a "list" of emails.. could this be the cause of my problem?I had sooo much trouble building the automation because in most cases it always gave me an error that "to"

I have two tables that are linked to each other: Candidate Table and Position TableEach candidate record has contact information (email) and is linked to a specific position record which also means that each position record may be linked to multiple candidate records. Each position record also has a status: Active, On Hold, Lost, etc.I would like to be able to send automated emails to all candidates linked to a position that has changed its status from Active to On Hold to update them on what's going on. What would be the best way to go about this automation?

Hi all,I am curious to learn more about what linked and un-linked data can be used in the 'Find Records' action in Automations. This happens frequently, and I am fairly sure that it is related to field data types. Linked record fields can only be used in certain instances, and lookup fields can only be used in others. Sometimes I have had to create 'String' fields through formulae to lookup other records. My ask: does anyone have any links to learning resources or documentation where i can learn what the limitations/benefits of certain field types are. We are managing the database through a front-end, and no fields are updated manually, so the vagaries of these data types and their capacity/limitations is quite a challenge!An example of my issue is included in the screenshots attached:For reference, I am working with 5 tables:UsersIn some cases linked to OrganisationsIn some cases linked to PropertiesPropertiesLinked to UsersIn some cases linked to LeasesUnitsLinked to Proper