Other Questions

Hello! I am wanting to create a field that will automatically add either “Week 1” “Week 2” “Week 3” Week 4" or “Week 5” depending on which week it is in the month, i.e. this week June 26th would be “Week 4”. Is there a formula I can use to create this? Thank you!

Hello everyone! I’m new to Airtable and I still have trouble using formulas, here is what I’m seeking to do: I would like to know if a row in a table let’s call it table1 repat itself in another table (table2). To do so if possible I want to have a detector in table3 and two other fields linked to table1 and table2 so it would be automated. I think the automation is too complex for me to do, so I would appreciate if someone has an idea on which formulas to use or even know if it’s possible to know if a row repeats itself in another table. Thank you for your help!

I am running Airtable on Windows 10. When I try to print to pdf, A4 size, the print to fit option appears not to work, i.e. fields are printed off the edge of the page. This happens with both the Foxit PDF printer and the PDFCreator printer. I ahve also tried Letter size, but same result. Any thoughts? Neil

Hello: I am trying to use Page Designer to generate reports from various records and tables, but for certain records with large amounts of data I need more than one page to display everything. Is there another app that would work better? I would also like to create a report with a static URL for each record so non-Airtable users could view their data without signing in.

I am incredibly new to Airtable. I have a family event that I’d like people to sign up for excursions and others can see what excursions others have signed up for. This is the current link: Airtable - Gallery Example: Bride and Groom are going on X excursion each day, in each port. Guests will be able to see what they are signed up for and also say they are going to X excursion as well. This does NOT need to actually tie into a payment system, just simply let everyone be aware of what others are doing and join in if they’d like. Problem: I don’t see how to allow others to sign up for each excursion. I can assign them on the back end, but the idea is for others to be able to see what everyone is doing and then assign themselves to that excursion as well. Is this possible via Airtable?

Hello- I am trying to run an automation to where when a linked record is selected from the field list, it updates the same linked record to another field automatically.

In a table of orders, each order is related to a client. Is there a way to look/roll-up data from other orders of the same client on the same date?

I, Community, I need your help. Shopify is connected to Airtable. I have all my product with stock quantity on Airtable. I sell plant, i have loss product and i want limit it. Is there a formula to know : since when do I have this plant in stock ? and more precisely, in my stock of plant “A” for example, I have 3 plants which date from July 12 and 7 plants which date from August 15. Is it possible to have a view by stock update? These different visibilities will allow me to limit my losses of plants. Thank’s for your help. Matthieu Thank’s a lot for your help.

Hi everyone, I’m Rosie, I have a issue which I need your help. I have a lot of time by link data from another sheet (attached a photo). Now, I want to calculate the period time (calculate the number of hours) by take the last day except the first day, which have on the column and the first row. Please help me if you have any ideas for the issue. Regards,

For a table with organizations I have a field {funded by} which lists all the organizations the organization is funded by. These organizations come in three types listed in {organization type}: government agencies, businesses or nonprofits. Now on the basis of the field ‘funded by’ and the fact that each of the linked records in that field have a feature that specifies whether they are government agencies, businesses or nonprofits, I want to use formulas to create three separate fields, ‘funded by government agencies’, ‘funded by businesses’ and ‘funded by nonprofits’. So I’d like to use a kind of formula like “for each item in {funded by}, if its value in {organization type} is ‘business’ then add to this field {funded by these businesses}.” How can I best do this? Am I missing something obvious?

Hi All. I found the following script code for sending a webhook from Airtable to Make but the input.config() in the first line demands an argument. anyone knows why? Jesper let inputConfig = input.config(); let recordID = inputConfig.inputRecord; console.log(recordID); let url=‘https://hook.eu1.make.com/7emn6wadgl4bn494kgibfvtop3lf4h6s’ console.log(url); let request= url.concat(‘?recordID=’,recordID) console.log(request); await fetch(request);

In one cell, I can select students located in another tab. If I select 1 student, I look up also the person ID which is a number : 123456. If I select 3 students, the lookup function will show 3 person ID as below: 123456, 432567, 5676328 I need to show those values without the comma. I use a formula: SUBSTITUTE({Person ID},‘,’,’ ') but it generates an error, I believe because the students ID are not a text string but an array When converting the array in string, using the formula SUBSTITUTE({Person ID}& “”,‘,’,’ ') I get this result: 1234564325675676328 How can I get 123456 432567 5676328 ?

I am curious to know what kind of impact the upcoming November 2022 update regarding attachments will have on my AirTable functionality. We have multiple columns which include URL links to Dropbox Folders where we store a specific asset depending on the link selected. I am having a hard time understanding if the future update will, or will not, have an effect on our AirTable continuing to function. Unfortunately, we will need to abandon AirTable if it does. Any insight is appreciated.

Hey all :wave: , I don’t find a solution for my stock tracking system. I have a database with all the products: Then I have a database with my orders to the suppliers linked to my product table. Each order has multiple products. Until this step is perfect. :ok_hand:t2: But I need to add quantity to each product :confused: 2 Items of X 3 Items of Y 1 Item of Z Do you know how I can add that? If I insert a general #number field is a quantity for the order and not for each product item. Thanks.

i have a list that i’d like to embed on my website, though do not want anyone to be able to copy or print it. i have turned off the ability to copy from the share settings and turned off the view controls. however the “view larger version” on the bottom right brings back the controls and the ability to print. alternate question: can i turn off the “view larger version” feature? i also do not like the fact that it exposes the direct URL of the list/ view. rant: it doesn’t make any sense why you’d have the setting to turn something off and then provide a way to users to override it. also, is there a way to turn off the airtable branding in the embedded view? i am a paid subscriber and believe i should have the option to truly embed something without having to expose the underlying tool. i see a thread asking about disabling print view from a couple of years ago, didn’t see it being addressed (

Hello, I am trying to create a prefilled form that automatically populates the current renewal date for a piece of software. I am running into an issue where the date that shows up in the form is exactly one day behind from what it should be and I can’t figure out why. As you can see in the above screenshots, the link generates with the date “2023-01-14” but shows up in the form as 2023-01-13. Any clues as to why this is occurring will be much appreciated! Thanks Doug

hello, i have table 1 with invoice nr, product, quantity i want to copy selected records to another table using automations i find the record, that meats the criteria (invoice nr) and want to “copy” those to another table so i make triger, find records (found 4) and now i want to copy those to the table 2 i try to use “create record” (in table 2), but i get 1 row with multiple products - i want to get 1row with 1 product from what i find - please can anybody tell me how to, or what am i doing wrong ?

Hello, Airtable community. I would like to know how I can automatically add the records in Table A to a single record in Table B. I already connected the tables and what I want is that every time a new record is added in Table A, the records are automatically added to the connected field in Table B. I tried Automations, but I couldn’t figure out the process. I appreciate any guidance in advance.

How to remove the calendar-view’s button tooltip?

Is there a way to Filter records within the Grid view based on a search within the table itself? In the same way that ‘Find Mode’ allows this in FileMaker with Command-F. Thank you!

I am trying to create a table that can represent an arbitrary depth hierarchy of objects, with a field that in each entry that rolls up corresponding values from its children. Here is a simplified version of what I want: Each entry has a “type” field that is a selection of “leaf” or “parent”, a numeric “enteredSize” field (used only for leaf nodes), a “children” field with links to other entries, a rollupSize field that is the sum of the size fields of the linked children, and a “size” field. I want the size to be a formula: IF(type=leaf, enteredSize, rollupSize). This is disallowed because of a circular reference. I understand that I could create a circular reference with this, but my data is a strictly a tree. Is there any way to support this? Basically, I want to check circularity between records, not between fields.

Hi, Is there any formula that can be used to find the best matching block from the table? please help! for example, I have an input that’s collective of words as a product name: YELLOW PRETTY WOMEN’S BAG in a meanwhile, my inventory data would have: PRETTY MEN’S SHIRT YELLO WORLD PRETTY MEN’S HAIR RED SALSA PRETTY WOMEN’S BAG …etc and output to be : RED SALSA PRETTY WOMEN’S BAG. because it has the largest number of words matching. *input string isn’t always 4 words combined. PRETTY MEN’S SHIRT (1word match) YELLO WORLD PRETTY MEN’S HAIR (2words match) RED SALSA PRETTY WOMEN’S BAG (3words match) Hope my explanation was good enough to understand. Thank you in advanced.

I need to open a record in a miniExtensions form prefilling values from Airtable fields - including a multi-select field. I’ve used an extension to build a formula. The resulting URL works fine with an Airtable form, which populates all fields, including the multi select. The miniExtension form won’t prefil the multi-select field using the same formula. I can see the cause. The Airtable formula retrieves an array of values for the mini select field. However, it inserts a space after each comma. Can anyone suggest how to adjust the formula to take out the spaces? “Story form” & “prefill_Idea%20Status=” & ENCODE_URL_COMPONENT({Idea Status} & “”) & “&” & “prefill_Story%20title=” & ENCODE_URL_COMPONENT({Story title} & “”) & “&” & “prefill_Magazine%20section=” & ENCODE_URL_COMPONENT({Magazine sectio

Hello again, cannot move over this problem :frowning: the situation: Airtable

Hello I wonder if you can help I am using a react.js form to collect customer data and would like to connect this information to Airetable. this is what I have so far: file 1 - data file import { useState } from “react”; import axios from “axios”; export default function useData() { const [data, setData] = useState(null); const getData = async () => { return axios.get(“/”).then((res) => { console.log(“res.data.records:”, res.data.records); setData(res.data.records); }); }; return { getData, data, }; } file 2 index.js import React from ‘react’; import ReactDOM from ‘react-dom/client’; import ‘./index.css’; import App from ‘./App’; import axios from “axios”; const BASE_ID = ‘xxx’; const API_KEY = ‘xxx’ axios.defaults.baseURL = https://api.airtable.com/v0/${BASE_ID}/Contact__form/; axios.defaults.headers.post[‘Conten