Other Questions

I have created a marketplace using Softr and Airtable.I am trying to figure out two issues:1. I have lots of records and want to create a field for signup, with the URL pointing to the sign-up in in Softr. Is there a way to input the URL into one row of a record and then copy that into every sign-up record?2. Going forward whenever I create a record, I would like that the sign-up field will be automatically populated with the URL. How do I do that?Ideally, I would like to have the Signup in the Softr record (card) directly point to the appropriate URL but it seems it will allow me to map only through Airtable. 😞Thanks a lot in advance.

I have been playing around with @Justin_Barrett’s excellent script “Parent Child tree hierarchy” (Parent Child tree hierarchy). The output of this is a text field with any separator you like, for example: World > UK > London > Hammersmith > Elspeth Avenue > Joe’s Cafe World > France > Paris > La Defence > BNP Paribas World > USA > New York > Manhattan > Central Park Question - is there any way to extract the #3 item (or the #2 or #4 for that matter) from these text strings? In this case, to pick out “London”, “Paris” or “New York”. I assume this should involve counting 2 instances of the separator (“>”), and then selecting the text from there up to the next separator.

This may be an issue more with our organization's strict IT rules but here is the situation:We have a type 2 email account that hosts all of our events on its calendar.When we initially started with Airtable, we used the outlook integration and was able to access that type 2 by using one of our work emails that subscribes to that type 2 calendar as the sync configuration source.ex. connected accounts>raethgu's outlook>events calendarOne day the sync was broken and in an attempt to re-establish the integration, a coworker updated the sync configuration source through their outlook accountex. connected accounts>coworker's outlook>events calendarIt looked fine until we noticed all the tasks and subtasks and comments were gone. We believe using that different source erased all the existing records and replaced them with the same records (since it was the same calendar).Our goal is to make the integration independent of any person's outlook account but here are the caveats:When

Hello,We have a table that syncs with our outlook calendar that we have been using for a few months now. Our organization adds events every week, for some reason when they were added to the outlook calendar today, Airtable made dupes of each one. I can confirm there are no duplicate events on the outlook calendar itself, but I do notice that Event 1 and Dupe 1 have different outlook IDs. Has anyone experienced this or have a solution to remove the dupes? Thanks.

How can you export all the PDFs/images/etc in attachment fields?

Hi. Has anyone managed to integrate Airtable with Canva using Zapier? I have only seen the option to integrate with onlizer so far....we've been trying with Zapier but the designs aren't appearing anywhere on Canva. 

 Hi folks, I am going out of my mind! Everything was working perfectly until I deleted some data in my table and now BAM it's all gone to total rubbish! If anyone can help I would be hugely grateful. Quick summary - I have one base with two tables; ID and Conversations. I want to connect a unique numeric number to a user email so when information is zapped in it connects the numeric number with the correct email. ID table houses the unique number and email.  It was all working fine but, as mentioned, I deleted about 20 rows and it has stopped. I have reset the link/look up and it worked on the existing rows but not on anything new coming in. The screenshot below shows (with the face stickers - sorry, it has confidential data that I can't share), Columns Project ID, Email Lookup and Link to ID Record and as you can see (if the stickers were not there!) it was working perfectly and then at the end you can just see the last one worked and then the further two rows did not p

Hey Airtable Community! 👋As @GCheung, @MaddieJ, and the incredible Airtable team gear up for the exciting re-launch of our community, you’ve probably noticed we’re heading into some “read-only” days (Feb 21 - Feb 28). Whilst we wait for the migration to take place (and eventually the big reveal 🎉), I wanted to make myself available if you need any help, have burning Airtable questions, or just want to chat about automations and solutions in the meantime.Feel free to reach out to me directly via Private Message (if they will still work?), or most probably via email at mike@automaticnation.com — happy to be a resource while the community gets its well-deserved glow-up! ✨Looking forward to it all!Mike, Consultant @ Automatic Nation

Hello Community,I want to sync all Airtable data into Power BI to create a dashboard. Is there any other way to fetch data from Airtable to Power BI besides this method?https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-queryThanks.

Upon pasting the data, I keep getting this error. Please suggest how to resolve it.

HelloSorry about the title. Actually, I don't really know how to ask it correctly.Basically, I want the circled value to be the sum of the above 'Max' values. In this case, I expect 500 + 100 = 600.Is there any alternative to achieve that since I cannot switch the function to SUM; otherwise, the MAX would be lost...I goal is to show that sum "600" somewhere. Thanks

I have created an airtable base to see what steps different organizations need to take. I have a list of all of the steps in one table. And a list of all organizations in another. I have a linked column connecting the two to show what steps each organization has taken. I am trying to make it so I can easily see the steps that an individual organization has NOT taken yet/ what they still need to do (They all have to do all of the steps). I don't necessarily care how it is done as long as I don't have to do it manually and can easily see what steps have not been taken by each organization.For example, I want Organization 2 to say that it still needs to do steps 15, 19, and 20 (the steps do not have to be done in order for the most part).Images and an example base are attached for a better understanding of what I am trying to get at. Link: https://airtable.com/appP3aMz3aJ2jYLGp/shrnb4rpltjlBPdZH/tblbT6mtF29tzfsbF/viwiytG0caCqn0XZT?blocks=hideThank you for any help that you can provid

Using Zapier, I am trying to lookup the “full name” field of a linked record by using the record id of that linked record. The record ID is the relevant record is returned by Zapier - so I should be home and hosed, right? However, This post seems to suggest that I cannot serach by record id unless I first define a “record id” field in my linked table (using the formula RECORD_ID()). UPDATE This works RECORD_ID()="<TriggerValue>(Step 1: Record Id)<TriggerValue>"

I understand that this may not be the appropriate place to ask my question in the Airtable Community, but I've found some very intelligent users, so I'm hoping someone can advise me on how to proceed.I want to integrate a dynamically filtered table from Airtable based on user selections to questions in a Fillout form.The goal: any clients can select our employees from a dynamically filtered table that shows in a Fillout form based on their needs.The table contains several columns: Name (single line text), Job (multiple choices: computer skills, math skills, English skills, and teaching skills), Working Experience (single choice: 1, 2, 3, 4, 5), Recommendation Letter (single choice: yes, no) and Availability (available/non-available) in Airtable.I was successfully able to integrate some questions that are integrated from Airtable, such as job, working experience, recommendation letter, and availability, because they are categorized, but I have no idea how I can display a dynamically fil

I know there are a number of Noloco users who use Airtable as the back end, and I'm hoping for some advice.I have a fairly complex app and due to some changes my clients IT team made the magic links and password reset emails not longer get to the users.  Noloco support is recommending I clone the app under a new name which should work as long as the new name is acceptable.Has anyone had experience with cloning apps (I've done it but not with a larger live app)?  Is there anything I should watch for or be aware of?Thanks.  

I can’t figure out how to center align a column. Surely I can do this?

I have a task table and some have linked records to a subtask table. Is there a way to get the subtasks to show up on a timeline view page that the source is the task table?If not, is there any other suggested way of managing subtasks that would allow this that isn't a long text with rich text checkboxes?Thanks! 

Hi there, I’ve added a new custom field to my primary view and put it the order I want it to be with my other fields. When I navigate to a secondary view that custom field is alllllll the way at the end of my view (not where it is in my primary view). Is there a way to customize the field so that it’s at the beginning of every view? Does that make sense?

I have tried all week, very unsuccessfully, to get my company's account upgraded from Team to Business.  I have submitted multiple sales contact forms and help desk tickets.  Nothing but crickets.  Is there any DIRECT line to a human sales person at Airtable that can assist, today, in getting our company switched over?  We were supposed to roll out AT to our entire research team today but because I could not get it hooked into Okta, we had to delay for...well who knows now.  

Hi All,I've been working on customizing a script for an air table base I'm building, and I've hit a wall with fixing the section about copying over dependency (linked record field) from the template tasks table into the active tasks table. I need the newly created tasks in the "Active Tasks" table to have dependencies mapped to each other as instructed by the "Template Tasks" table. Here is how my base is set up: Newsrooms Table"Revenue Services Link" → Links to "Template Revenue Services" Table"Create Template Tasks" → Button Field"Link to Active Tasks" → Links to "Active Tasks" Table"Onsite Ad Ops Tasks Created" → Checkbox/Boolean"Newsletter Ad Ops Tasks Created" → Checkbox/Boolean"Strategy and Execution Tasks Created" → Checkbox/Boolean"Branded Content Tasks Created" → Checkbox/BooleanTemplate Revenue Services Table"Template Task Links" → Links to "Template Tasks" TableTemplate Tasks Table"Task Name" Single Line Text Field"Dependency" Linked Records in "Template Tasks" Tab

Hi, How can I add multiple rows at once in a table. (This is a function that is super easy in google spreadsheet). AT only allows for one row at a time and I have to keep clicking on the Plus sign. Too much work. I wanna add 100 rows at once. Is that possible?

Hi, I have shared a Base with two users from a different organisation (our client) by an email Invite to the whole Base.They are using the same view links as we do, and they cannot see the view filtering options (icons are hidden). What can be the root cause of the problem?We have already tested the same invite with a test account and it works fine - same Editor permissions, no specific settings applied, but we can see all icons on the test account.Might this be linked to some restrictions on the client's side or a web browser with cookie restrictions?We are unable to identify the problem so far.

Hey guys,I am receiving reports from my team that people are receiving multiple emails about any comment on a record. So 1 comment is sending 6 emails to a person. Is anyone else experiencing this bug?Thanks.

Hi Everyone,I want to resize a column in a automation email I use.My product code field is too large - and the description field is too small (causing the text to wrap).I am inserting a grid into the email (a list will not work - there might be multiple rows).Thanks in advance for your help!Greg 

Maybe this question has already been answered. However, I search for it and found nothing.I'm a new user. Is there a way to make kanban boards more colorful like adding background colors? It seems that kanban boards are mostly black text on a white background when using Airtable on the web. It would be easier on the eyes if the white background could be changed to another color of my choosing. I'd also like to change background colors for each category and each task if possible.Thanks.