Other Questions

I am aware it's possible using Zapier/Make/n8n/BuildshipApp etc, but this is all external apps, too much work to configure. Google Gemini has a very generous free API plan and I would be keen on getting it to work but I have no programming experience. Wondering if anybody figured out a way.

I have 3 tables: plants, fertilizers, and schedule. In the schedule I set on a date certain fertilizers and plants. And also it has field "done" - planned or done.So I want a calendar view for each plant where I can see when and what fertilizer I have used.Could you please help, How can I do this? Thanks for any suggestions!

Is this possible? If so, how?

Hello - I am new here and trying to create a base for following cash flows in my various accounts, cash or petty cash.Thanks to sources I found here, I succeeded to create deposit and withdrawal through two tables, one for accounts and one for transactions, and a rollup structure to calculate the balances of each account under the deposit/withdrawal transactions. However my concern is related to "transfer" transactions between accounts. When it is a "transfer" transaction, I want the rollup to subtract the amount value from the transferring account and add the amount value to the receiving account. I mean, when the number of accounts and the rollup transactions becomes two, I cannot find a practical (or sophisticated! 🙂 ) solution for such purpose, so that;(a) I select the "transfer" as the transaction type;(b) I enter the amount of the transaction;(c) I select the From and To accounts separately;(d) The amount becomes withdrawal for first account and deposit for the second acc

Hello - I am trying to get a total count field if student's have passed multiple tests. There are six fields representing each test. Within each multi select field the contents contain: Drop downs for fields:  Pass 4/5/24, Pass 4/17/24, Fail 4/5/24, Fail 4/17/24.  I want to use a multi-select tool so if/when they retake the test, I can note which date they passed or failed. Fields:Test 1 Test 2 Test 3 Test 4 Test 5 Test 6 I would like another column to say, if the fields contain pass, then count it as one. If a student passes 4 out of 6 of the tests, I would like the column to have the total = 4. I am stuck combining the multiple fields. Airtable provides the following equation to count for one multi select field: IF({YOUR MULTIPLE-SELECT FIELD NAME},LEN({YOUR MULTIPLE-SELECT FIELD NAME})-LEN(SUBSTITUTE({YOUR MULTIPLE-SELECT FIELD NAME},",",""))+1)Is there a way to create a formula that will count from multiple field

To any formula ninjas, A column has multiple keywords/values. I need to add a pre-fix before each of the values. From: column: Colour values: White, Black, Blue To: add the prefix “Colour_” to each one of the values in the colour values: Colour_White, Colour_Black, Colour_Blue I created another column with the prefix Colour_, and then a basic concat, but the result is (of course): Colour_White, Black, Blue I don’t know how to add the prefix to each of the values individually, and if concat is the right formula. Detail: not all columns will have a value, so need to consider an empty cell. If anyone has a good idea… much appreciate it ! Christie

Hi, I’m looking for a way to collaborate with a partner on a specific view on my table - but I don’t want to give them access to the whole table/other views and my entire base. I know that there is a “share view” button but that doesn’t let my partner put their own notes in. Am I missing something?

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?

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!

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?

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: https://airtable.com/embed/shrNEroLw9LDd5Hlg?prefill_Company=Sixteen%20Grams%20Coffee&prefill_Position=Marketing%20Intern Any pointers on what may be causing this? Thanks!

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.

I'm trying to figure out the best way integrate my Airtable base with Sages brightpearl.Will this be possible using a script extension?Or should I use Make?Has anyone done this before and what will you recommend? 

I'm trying to find out how many fields in our database are empty or not being used. It's really tedious to check each tab one by one. Any siggestions?Thank you!

The following bit of code is intended for a Script block to pull data into airtable it was written by chatgpt I cant make this work for the life of me async function updateRDAPData() { let table = base.getTable('Wucy'); // Correct table name let query = await table.selectRecordsAsync({ fields: ['Value'] // This field contains the full RDAP URLs }); for (const record of query.records) { let url = record.getCellValue('Value'); // Get the RDAP URL from the record if (!url) { console.log(`Skipping record ${record.id} because no URL is present.`); continue; } console.log(`Fetching RDAP data from URL: ${url}`); try { let response = await fetch(url); if (!response.ok) { console.error(`HTTP Error: Failed to fetch RDAP data from URL ${url}: ${response.status} ${response.statusText}`); continue; } let data = await resp

I have published a form and used the helper text as a description for some fields. When I preview the form within my account, it looks great. When I try to use incognito mode or a different account to view the form, the helper text is missing. Can someone help?

Is it possible to edit the email notification that is sent out when you @ a specific user?For context;  as our purchase order moves through various stages, the access to those stages is dynamic.  When a user a elevated stage access comments at a user with a lower stage access, the lower access user receives an email notification with a link.  However, the link takes them to the interface that they do not have access to.  We would like to update the URL that is provided to send the user to an interface where they can see the record and interact with the comments field.Thanks!

I gave access to a couple of people who are actually my clients to a database I designed for them.I want to know what is the exact charge for those licenses / users so I can charge them for those expenses.

I have a payment tracking table. It has fields that are Original Cost, Variable Cost, and Fields for each month(Jan - Dec): Formula Field). The original cost is linked from another table. If the user does not provide any value to Variable cost, The original cost value will be split into 12 months in respective fields for each month. Otherwise Variable cost value will be split for each month. But my requirement is User can add the cost for each month manually if the client has paid a different amount for each month So that we can calculate the balance amount for the rest of the month.

I just found all my personal info including social security number on a public link on airtablewtf is this site? I reached out to airtable’s customer service support I’m freaking livid  

Hello, I'm fairly new to the paid version of Airtable and I've been able to figure out most of the features and automations I need. I'm specifically wondering (especially with the updates that have come out) if there's a way to validate entries and form conditions. Example: students input their e-mail address in a form. If it does not meet the condition of having their .edu e-mail address, there's no way to reset the form or put an error message up. I have tried putting a conditional field that it must include the .edu student address portion, and I made it a "check box" format with an error message. Students do not seem to read this and submit the form with incorrect data or the form not even being filled out. Is there a way to not allow the submission if certain things are incorrect?Also with attachments, is there a way to condition that attachment to only accept certain types of files? Thank you!

My table tracks publication start and end dates for various websites, and I need to determine the time between the previous record's end date with the next record's start date.Examples:  Site A's publication will be taken down on May 31, and the new one will go up on June 1.  Site B's publication will be taken down on May 31, and the new one will go up on June 6.These require different processes ("turn this one off, wait some days, then turn the next one on" vs. "replace this one with the next one"), and I need to indicate which process should be followed.Each publication has its own record in the tableSite A / Start Date: May 1 / End Date: May 31Site A / Start Date: June 1 / End Date: June 30Site B / Start Date: May 6 / End Date: May 31Site B / Start Date: June 6 / End Date: June 30How can I check to see if the Site's records are "back-to-back" dates? In this case, Site A records are back-to-back, while Site B has a five-day gap in between.(I'm assuming this is going to have

Hello!I am looking into creating a workspace where my team would manage information in tandem with our vendors. There will be sensitive information within our workspace - is it possible to give access for a workspace to a vendor, and restrict specific columns, tables, rows or custom fields?Any help would be greatly appreciated!Thanks,Harry