Other Questions

I want to do something like this Subtract more than one item from the same product Ask the community I am running a store that makes fabric bags. Each bag can be made from one or more products from the inventory, for example, two zippers, one strap, one tag, two hooks, etc. I need a formula that for each bag I sell it can subtract more than one item from each product in the inventory, this is kind of a cooking recipe. Please let me know if you need further information. Thank you! but in my case, there are sizes as well. So each fabric bag will be either small, medium or large and the components (zipper, strap etc) will also have the same size options. A small fabric bag will have small zippers and small straps. What kind of database structure should I have and how should those coordinate with each other?

I have a table in my base that I use to track “energy level” which is rated 1-10. Each record also has a timestamp on it. I’d like to create a table that charts energy levels on an average day. I’m thinking I need an average energy level for each one-hour increment. Any suggestions?

Hi all. Perhaps someone can help me. I need help from someone who understands the Telegram API. Below is the code of a script which should work under certain conditions in Automations and send a message to a Telegram user via bot in an open chat with some data from the table. At the moment the script sends an error error_code: 400 description: "Bad Request: message text is empty" The script works fine in the sandbox and sends messages. Not in Airtable. Perhaps the problem is related to Airtable and its specific variables? How do you think it is possible to solve this problem. On Stack Owerflow people occasionally write about this problem, but their solutions have not helped me. I would be grateful for an answer. const token = 'ххх'; let inputConfig = input.config(); let message = `${inputConfig.first_name}, документ готов по заказу №${inputConfig.order}.<br>Вы можете скачать его <a href = "${inputConfig.doc_link}"по ссылке</a>.<br>Ждем Вас снова.<br>Ваш, Rea

Hi Airtable community, Is there any way to: collect files via form attachment copy and upload the files to box.com delete the files in Airtable (Tried using Zapier, but unable to automate deleting the files in Airtable) Or are there any other ways that this can be achieved other than form attachent, as I know it is not ideal… Thanks in advance!

Hi, I’m putting together a base together with a list of therapeutic modalities on my y axis; and a multiple select field called ‘Presenting Issue’ on my x axis where I’m inputting the different presenting issues each therapy targets (e.g. CBT targets Phobias; Depression etc). I’ve a list of about 50 different therapies and would like to be have a view where I can look at the presenting issue and then see which therapy is ‘matched’ to the issue. I assume the best way to do this would be with a Kanban view, however Kanban doesn’t seem to work with a multiple select field. Any suggestions of how I can a Kanban to work, or perhaps a different method to achieve a similar outcome? Thanks in advance!

I have 2 fields: PrevDate and NextDate. When I change another field or add checkbox I need to increment NextDate by 1 month from PrevDate. I can use DATEADD({PrevDate}, 1, ‘month’) but then I need to change PrevDate so that I can use use it nest month,

Is there any capability for a remotely-hosted attachment, ie. images hosted on a different server but which can display as attachment thumbnails in Airtable? Let’s say, I have many images hosted on S3/Cloudinary… If I have a URL field containing the URL of an image, is there any way to make that image display as thumbnail content within Airtable? Or even to function at the same level as an attachment?

Hello, who can give an advice how to 22 to 2022 23 to 2023 etc… I guess I can just concat “20” & MyDigits maybe there is possible more elegant solution? UPD: I Found solution with DATETIME_FORMAT(‘01/01/’&MyDigits, ‘YYYY’)

Are there any IG/FB schedule posting apps that integrate with Airtable? I want to schedule our IG/FB posts but I also want data to come back to Airtable live. So if i have many scheduled posts in IG/FB I want to actively see this data in airtable.

I have always used CSV Import’s Apps. However, I have recently been experiencing errors with CSV Import. Even though I have not changed any columns, I am getting errors during Mapping and during import. Especially the import error is fatal for me! Does anyone know the cause of this? I pasted a video of the error. https://www.notion.so/Error-c5d3143cbdbc441788cab846fa8009c3

I have several records which I want to fill in the same field with the same value. Can I do it simultaneously?

I’m trying to list all the conferences our company might be interested in attending for the next year or so. I’d like to be able to estimate the total cost for each meeting. I’ll assume a daily rate for meals, but I’d love to have a way to look up airfare or median hotel price to include. Is that possible?

Hello! I’m trying to set up an automation where a birthday email goes out on the client’s birthday. I found the solution on changing their DOB to current year (thank you community!) however, I don’t want the emails to go out before 9 AM on the day of their birthday. So far I’m adding in the “time” of 9 AM manually in the birthday field but I can’t seem to figure it out from there. Thanks in advance for your help! Troy

I’m using Naver Whale which is a Chromium-based web browser. If I right-click on the table, the menu for the AirTable and the context menu for the web browser overlap. (The web browser menu covers the AirTable menu so that the AirTable menu is invisible.) It does not happen in other browsers such as Chrome, Microsoft Edge, or Firefox. If I want to use the AirTable menu, I should press the Esc key once to remove the web browser menu. Is there a fix for this problem?

Hello, I am new to Airtable. can someone inform how to insert data in cell or field in table with the help of code. Waiting for your response.

Is it possible to cast my bases to a large television screen with Airplay or Chromecast?

Hi everyone! Newbie to anything this technologically advanced and have no idea what I am doing LOL. I am using the Airtable “Create Scripts for Multiple Templates” script, but I don’t need the “Type” table. Is there anyone here who can educate me on how to edit the script so it doesn’t include any reference to the “Type” table and still runs through what I need it to? Thank you in advance!

Why emailed data only for Enterprise plan?

Hi, I’ve looked at the online tutorials and for some reason I’m doing something wrong! I need to link numerous sheets into one master sheet. The master sheet needs to link individuals by surname and email to avoid duplication. I run a non for profit and we have so much data and so much duplication and I just need everything on one sheet. I’m now getting really confused as its not linking things but is adding a link name to a form. Can someone explain how I do this in a really straightforward clear way?! Thanks!

If I currently am using the 5 free collaborators on the free plan and need to add a 6th collaborator how much will I be charged on the pro plan? (1 seat, with the 5 free collaborators still free or 6 seats for each of the 6 collaborators? )

Curious if there is a way or a work around to conditionally display two different buttons. Use case: Different roles/jobs (each is a record) that are open for applicants at different times. Want to gallery view all roles/jobs, and display a “learn more” button that would take user to a job description page, but would like that button to be an “apply now” button that takes user to the application form for jobs/roles on which we’re currently accepting applications. My first thought was create two button fields and then have a formula field that would pull apply now button in if applications open and pull learn more button in if applications are not open for that role/job/record. It pulls the URL but doesn’t pull the button. Any thoughts? I wasn’t sure if you could write a conditional in the Label field of the field settings for a Button or if you could even reference another field as the Label… Also wasn’t sure if there’s a better way to reference the data in the field of the record

I have created a two-question survey. One question asks the respondent to pick their top three options out of six and the other question asked them to select their top four out of 16 options. I’d love to limit to the three or four, but I’m pretty sure that capability isn’t there. MY PRIMARY CHALLENGE AND QUESTION IS: Some of the options to select are longer, and part of the sentence gets cut off when you view them on the survey instrument. Is there a way to change that???

Hello! I am working on a project that collects data from multiple areas (collect sequentially), and I am tracking the percent complete each area is. I want to make a pie chart that shows the percent complete of each area over the entire project. (For example, 10 Areas and each area varies between 0 and 100%). Thank you!

Hello! I have a submission table that lists dates of a submission and an associated “office” to each submission. I also have an Office tab that takes all the submission data with other rollups. There can be multiple submissions a day to the same or multiple offices. I want to use a rollup to gather the number of missing dates from a specified project start date (in this case 3/28/2022) as these would be weather or maintenance delays (and I’m trying to see if there is a formula that will automatically calculate this). Thank you!

I have a fetch that calls an API and adds all of the records to my table (Title, Date, Unique ID). That is good. Now when I make another call to the API I want to run thought the existing field, match the Unique ID and update the name and date (does not matter if they are different) and if there is no record with that Unique ID add the Title, Date and Unique ID to the end of the records. let response = await remoteFetchAsync("URL", requestOptions); let json = await response.json(); let table = base.getTable("Table"); let titleColumn = table.getField("Title") for (i=0; i < json.length; i++) { if(json[0].Title !== titleColumn){ let recordId = await table.createRecordAsync({ "Title": json[i].Title, "Date": json[i].Date, "Unique ID": json[i].uniqueID }) } }; Thanks!