Ask the Community

Is there any possible way to run Data Fetcher from the Interface?I have created a Button following this info https://help.datafetcher.com/advanced-options/run-request-from-button-field but this resides in the data which is not ideal. I want to be able to fetch the data on demand with the click of a button from the interface without ever opening the data. Is this possible

Hello wonderful AT folks,I'm trying to solve an issue in automations and am looking for help.I have a system where we need multiple users to review a document and then fill out a quick form to indicate their findings. The document record contains a multiselect field of all the users who need to perform this. I'm trying to create another multiselect user field of all the users who still need to complete it.What I have so far: an automation duplicates the users who "need to perform this" over to the "users who still need to do this" field.Next, when a review is entered in a linked table, a complex SUBSTITUTE formula removes that reviewer's name from the list of remaining reviewers. An automation then copies that formula result onto the "still needed" field in the Documents table. And that works!But, when the last reviewer is done, the automation refuses to copy the blank cell onto the multiselect field and errors out instead.So, I tried adding

Hi, this is a Voiceflow specific question, but I was hoping someone might have some ideas.I'm making an API call from Voiceflow using a multiple filterbyFormula to exclude words. This is what it looks like:https://api.airtable.com/v0/appname/tablename?fields%5B%5D=Title&fields%5B%5D=Link&filterByFormula=AND(FIND(%22Long%22,%20%7BHair%20(Style,Color)%7D)%20%3E%200,%20FIND(%22Very%22,%20%7BHair%20(Style,Color)%7D)%20%3D%200 )The above works without issue. The problem is that my filterbyFormula changes often and needs to be contained within a variable so my actual call from Voiceflow looks like this:https://api.airtable.com/v0/appname/tablename?fields%5B%5D=Title&fields%5B%5D=Link&filterByFormula=AND({filter1 })This is working fine when I'm looking for a Match, i.e when {filter1} = FIND("Long", {Hair (Style,Color)})>0But if try for No match, i.e. when {filter1} = FIND("Very", {H

I'm trying to use curly brackets to insert field content into a text box, but it shows up as "Course Name: {Course Name}" on the designed page instead of inserting information from the Course Name field. How can I make Page Designer recognize that that's a field name?

This is the image link I'm trying to use:<https://www.the-efa.org/wp-content/uploads/2018/04/Education-header.png>I can load it just fine in my web browser, but Page Designer says there's no image there. How do I fix this?

Hey guys,I am so excited about the updated Record Review layout, my team has been waiting for a way to filter and sort within the side record picker. I am trying to find a way to update my current record review layouts to use this new feature but can't seem to find a way. Is there a way to convert the old layouts? I don't want to have to rebuild my pages. Thanks!

Hi! I am using airtable to keep track of several types of info connected to individual clients. However, sometimes I need partners/spouses' names to be in the same column. Is there a way to write a formula that only runs when certain conditions are met?For example, as seen in the picture below, my current formula for IN PROGRESS: Client and Spouse column is {First Name (from Spouse/Partner)} & ' and ' & ({Full Name}) I would like that formula to run IF there is a spouse, and I would like the IN PROGRESS: Client and Spouse column to only populate info from the Full Name column if there is no spouse/partner.I tried writing IF statements, but I couldn't figure out.Thank you!

Hi everyone! I have an Airtable base for a virtual event my team is planning for Learning at Work Week. The base includes the following:An "Activities" table with all of the activities that learners can complete, each worth a certain point value. The people who have the most points at the end of the week win a prize! A form (linked here) where learners input their email address (their identifier) and can multi-select (via a lookup from the Activities table) the different activities they did during the week. The form can be submitted throughout the week as various activities are completed, or at the end of the week once all activities are done - it's the users' choice! A "Form Responses" table to store all form responses.A "Participants" table that is automated to create a record that links the users' e

I hope I put this question in the correct area.I am developing a base to use for a contracting business, and I have a column for Distance Driven to job (to calculate fuel used in a different column)when I create the job for the client, it auto inputs the job address into a column, is there a way to have it auto calculate the distance to drive (by inputting my business address as always being the starting address, and the job address being the ending address?)Currently when I am creating the job for the client in the base, I have to open Google maps in a separate page, and input my business address and job address by hand, and manually transfer the number of miles into the base.There has to be a better way, right?

Hello all, I have a table to document my driving activity within my business. It has 3 colummns: Start adress End adress Distance from start to end adress. My question is: Is it possible to autopopulate the third column with the distance between 1. and 2. based on some automation/calculation/script etc. ? Thanks in advance!

I was thinking If this is possible. what if we keep our email user the same but just change the billing? Like, we could have our user account email as user.account@gmail.com, and for billing, we could use billing.account@gmail.com. What do you think?

Hello! Use Case: New Employees start at our company and we input a load of default events/meetings into their calendarsI manually input Start Dateand I want an automation/formula to inputDay 1 Start Start Date (ADD TIME 9am)Day 1 End Start Date(ADD TIME 5pm)Day 2 Start Start Date + 1 (ADD TIME 9am)Day 2 End Start Date +1 (ADD TIME 5pm)Making sure that Day is ALWAYS a weekday. Hope that makes sense, thanks!

I have a student financial table named OTA Financial where the OTA number and other information is manually added. That is synced with the Financial workspace tab in the student table. Then the students are connected through the OTA number in the main student table to import information from the OTA Financial.  I have spent several hours setting this up and connecting the OTA's.  They were working. Then the next time I go into the table it is not updating the financial workspace tab with the information that is listed in the OTA financial.  It is not letting me just sync the tables and I can't keep going over this and resetting it up every time I add a new person.  What the heck is going on and why does it not work over a period of days?

Hi there,I tried to empty the data in a certain view however that deleted all the information from the original base also. I am unable to undo the action, and when I look in the trash the information is not there either. The base still recognises that are 87 applicants from my application form, however there is no information in the base. I have also created a snapshot from yesterday, however since then more people have submitted an application form and so there is some data missing stillThanks in advance for any helpThanks in advance

I have a pie chart with a lot of values but a large quantity of them are '0' in certain slices of the data. Is there a way to hide/remove the '0' values from the legend?

Hi! I'm having trouble with a formula where it brings back text and adds " " when it is done. Here is the layout:Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}Column 2: Linked to another table, displays {Client} names (Example: John)Column 3: {Total Volume} quantity (Example: 10)What I want to get from this formula is = John - 10What I'm getting from this formula is = “John“ - 10Is this because I am linking to another table? It does not happen with every value from the {Client} column! 

Hi… I’m looking for a scripting solution that lets me auto-populate a field with a parent and child relationship. Eg - Column 1 has the children Column 2 has the parent of the child I’m wondering if I can write a script that can populate a new column with the tree hierarchy like this - wco:WC Interface → wco:Area → wco:Block → wco:Image Card → wco:Hero Image Card I have looked at a solution posted by joao_melo which works. But i’m wondering if this is doable in a script?

I have seen the same question asked elsewhere (link below) but it didn't really deal with another implication of combining a table and separating items by a type record.My question is, what is the best practice for setting up a contacts table in Airtable where those contacts could be clients or suppliers etc. If I was designing this in a traditional database my practice would be to make 1 contacts table and distinguish these by a field that indicates what type they are. The advantage is I dont need to maintain all of the different fields needed for a contact across multiple tables. The issue with doing this in airtable seems to be that I cannot easily create forms to add a contact or add a supplier (where the default values are hidden from the user) and as a result I cannot seem to trigger any automations from these actions. I dont want to spend time working on work arounds to achieve what I would like to do.So what do most developers

Hi all,This seems pretty basic but I can't get it to work after a day of researching and patching together example code I've found. I have no Javascript experience.I simply want to run a script that entirely clears the contents of a column. Here's what I have:  let subsTable = base.getTable('Sub Assemblies'); let clearQuery = await subsTable.selectRecordsAsync({ fields: [] }); function myObj(rec){return {'id':rec.id,'fields':{'BOM CREATE':""}}}; let updates=clearQuery.records.map(myObj); console.log('updates: ',updates[0].fields) while (updates.length > 0) { await subsTable.updateRecordsAsync(updates.slice(0, 50)); updates = updates.slice(50); }  The error I'm getting is: j: Error: Failed schema validation: <root> must be an arrayline: 2nd from last Any help appreciated!

Hi friends! I am hoping this is easy, but I'm noob enough to not even know how to search up an answer in support/forums.My specific use is retreat registration. I have one table for Retreat Participants and a second for the possible Retreat Rooms.The "Retreat Rooms" table has a field for the rate for Solo Occupancy, and a field for the rate for Shared Occupancy.In my "Retreat Participants" table, I have a checkbox to indicate "solo occupancy". I would like there to be a field in the Participants table that then returns the correct room rate based on whether or not this checkbox is ticked.Let me know if you need further information or explanation, and if you have any tips! I don't know if this is an "If/Then" or "Switch" or what 😵‍💫 Thank you!

Hi!I am testing airtable to see if we can use it to accomplish our needs and have hit a snag with this Project Profiles interface. I created a spreadsheet that feeds the interface, each row is a "project" but I need to display associated data at the bottom of the interface in table format.There is a way to do this by linking to a separate table, but I don't see a way to set the tables as an intuitive 'child' to the given project so that the process is more automated. 

 Hello airtable community, I have this following formula but dateadd does not display the operation in the result thank you for your feedbackFranck IF({Date début package} != '', {Date début package},IF({Date début expl 23} != '', {Date début expl 23},DATEADD({Date début package},{Nombre jours d'Activité},'days'))) 

My Production Schedule is synced to an external calendar subscription informing our entire cast and crew WHAT we're shooting - WHEN - but even though the physical address of WHERE we're shooting (i.e.: where they all need to be) - or even zoom hyperlinks (with the passwords embedded for virtual production meetings) - are detailed ON the customized labels, that doesn't transfer to the calendar subscription.All they get is an Airtable URL - and even if they click that link - it doesn't reveal the address - which is selected as an option for the customized label. What's the point of the customized label when it doesn't sync the info you select?How/where can I add LOCATION to my calendar subscriptions? 

Hey guys, I am building a job board. I’ve written the following formula to prefill the application form for the candidate: "https://airtable.com/embed/shrNEroLw9LDd5Hlg?prefill_Company="&ENCODE_URL_COMPONENT({Company Name}) & "&prefill_Position="&ENCODE_URL_COMPONENT({Position}) The Position is plain text and always gets prefilled. The Company Name is a linked record and doesn’t always get prefilled. In cases where the company name is just one word, the prefilling doesn’t work. Eg: Company name: “Shunya”, link: https://airtable.com/embed/shrNEroLw9LDd5Hlg?prefill_Company=Shunya&prefill_Position=Android%20Engineer vs. Company Name: “Sixteen Grams Coffee” has a successful prefill:

Hi,Please share your ideas. I'm not sure if it is possible or not.I have three tables Project, Budget, and Products. The Budget table has multiple fields that are linked to Project and Products, and the view of the Budget table is grouped by Project Name field. The Product table has multiple fields and one of the fields name is called Status. Whenever I create a new Project in the Project table. By default, Budget table should be updated with the New Project Name and integrate with Product table records that are in Status Active.