Other Questions

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

I have a list of people linked to projects in my Airtable base and I’m attempting to have the slack messages from my automation tag the user associated with the record matching the conditions when the automation runs. I’ve tried inputting the slack id as a look-up from the roster table, I’ve made a formula that concatenates it into a string, I’ve tried it both as id (with <@ and > added in message text) and <@id> in the methods above, but none of this results in a proper tag. The only tag I’ve been able to make work is when I hard-code one into the automation message, but that obviously isn’t dynamic. Has anybody had success here? FWIW; whenever I try to include the field with the Slack id into the message, it doesn’t show up in Slack at all, so I know at some point it’s getting filtered out.

Why does a table that takes 2 seconds to load for me in N.America take upwards of 2 minutes to load for my colleague in Malaysia. Is this normal for whatever reasons related to Airtable infrastructure? or is there something on his side that might be a cause?  

Hey all! I’m a bit stuck here and hope that somebody might have an idea to share. Context: I have a table that lists a bunch of SaaS products that I use (such as Airtable!). Many of them have monthly recurring costs on the same date each month. What I’m ultimately trying to do is create an automation that reminds me the day before each subscription is renewed every month, but for the life of me can’t quite work it out. I think I need a date/time column that indicates the day of the month that each subscription gets renewed, and then I guess a formula that will trigger the automation 1 day prior to the renewal? Hopefully that makes sense… thanks in advance for anybody that can assist! :pray:

Hello,As projects come to a close, I want to review how successful my team was on staying on task and completing tasks by the deadline. My base is set up to flag overdue tasks, so I know in the moment when something is overdue and needs to get done ASAP. But I'd like to take a look at the project retroactively after all tasks in the project have been marked as complete and see how many of them were finished late.I can then investigate if I have projects that need adjustments or support (unrealistic deadlines, bandwidth issues, employee struggling, etc.).Any suggestions on how to do this quickly?

I’m working with a group that has users shared at the Workspace level but now what’s to remove them from the Workspace level and share them on individual bases. I was surprised to find that users who are shared at the Workspace level can’t be shared as the Base level. Trying to do so creates an alert message that says “this user is already shared on this base.” Is it possible to shift users from Workspace to Base level access without first removing them from the Workspace and then adding them to the Base?