Other Questions

I’m wondering how I should get values from fields based on record IDs? I have a table called customers with a record created by record_id() formula. How can I get the value of say an email address or billing address if I know the records ID in a different table? Or am I thinking about this wrong somehow?

Hello, I’m running out of idea to make my automation work. Here is what I’m trying to do : take the count of this ( synch from google drive ) put it in an other tab : please help me :slightly_smiling_face:

I have an open-access data collection form that my members can fill in. Members are in different organisations with their own email domain. I want to be able to restrict views of the results by domain so that people can only see the responses from others in their organisation - which Airtable lets me do via the restrictions options built in to the view. So I created a View, gave it the name of the company in question and restricted the view by domain. However when somebody is invited to collaborate on the base they just see everything in the table/view and the view itself isn’t restricted by domain - I think the difference between being invited as a full base collaborator (with commenter permissions) and simply having a link to a view without being invited to to the base. I believe I need these members to be collaborators, as opposed to simply being sent a link. If they only had a link to a restricted view they wouldn’t (necessarily) have an Airtable ac

I’m creating a node.js/react app, I have my users in airtable (and all other data), how can integrate an SSO login for those users?

I have a table with all information about my students: 44 fields initially, 48 now. I have a table for collecting grading information about students, when created, the students’ table had 44 fields. The grading tabkle has the 44 fields synced. But I would like to see the 4 other fields I have created in the students’ table but they do not synced with the grading table, it only shows the 44 fields and not the 4 new ones. Any idea?

While organizing an event I have this simple table: https://airtable.com/shrClDgt5JN17c7XX People register on a certain date, and pay a certain amount The same people pay what they are due a week or 2 later. Now, here’s my thing: I want to know per day how much money is due. So if 2 people register on day 1, at the end of day 1 $30 is due On day 2 $45 is added, On day 2 a total amount of #30+$45=$75 is due. On day 7 people start paying. What system could I use to visualize per day how much money is due? In a spreadsheet you can make use of sumif / sumifs but that is not possible in AirTable.

How fine-grained is “Field & table editing permissions” listed for a Pro account? Can I restrict the ability for a user of a base (Collaborator?) to create/delete views but still be able to edit records in a view I’ve created and locked? Because if I can’t stop my users who are allowed to enter new records from deleting forms and views that I’ve created for their use, then it’s a deal-breaker.

I’m looking to create an automation where a google calendar event is created when we know the 1% rollout date of a feature. Then I want that same event to update once the 100% date target is known as well. But the automation doesn’t seem to be able to create an event with just one day being known. Should I create a formula to auto fill in 14 days as a default? Also struggling on how to do that effectively.

I would like to sync fields from one table to another table in the same base. And I don’t mean link the records. It appears the only way you can do this is between bases, however then you lose the ability to link records back to the source base. I must be missing something and would appreciate help. For example, what I am trying to accomplish : I have a table named “Active Pipeline” and it contains fields with last name, and first name. I want another Table named “Master Client Contact List” in that same base and I want those 2 fields to sync over to the other table. Thus, I am not manually duplicating data entry. I want that Master Client table to grow via syn from the Active Pipeline table. Thank you,

Hi all! I’m conducting a survey that includes a multiple-select field. Has anyone devised a formula or some other clever way to transform multiple-select data into single-select fields (toy example below). I came up with a way of doing it in Excel and then pasting it back into Airtable, but I’m wondering if there is a more elegant approach (other than having the fields be single-select to start out with, which makes for a sub-optimal survey experience). Thanks!

Hey guys, I’m using Integromat (Make) to connect Adalo with AirTable. What I’m trying to achieve: • (1) Adalo “Watch Records” (if created or updated) → • (2) AirTable “Search Records” with formula SEARCH(’{{1.Email}}’,{Email}) (where “1.Email” = Adalo email field and “Email” = AirTable email field) • (3) IF TRUE (Email found on AirTable) → Update AirTable Record • (4) IF FALSE (Email not found) → Create AirTable Record Tried various ways (see screenshots) and… • Update Record = Works perfectly • Create Record = It never creates a new record Please see the screenshots to see what I’ve already tried. What could be a solution is if I could set a filter for Adalo to create an AirTable record when Adalo “Created” date is TODAY() but there’s no condition like “Today” in Integromat to evaluate Adalo date against. Could anyone help me, please? :slightly_smiling_face:

Hi There, I would like to ask if we can migrate or copy the Airtable automation to Integromat? I have a lot of automation in Airtable, it’s hard for me to create them again on a new platform of automation. Does anyone know how will I start in Integromat Basic?

Yesterday was the first time in over two years I experienced a bug in Airtable. Data in 3 columns has inexplicably disappeared. The data is all intergers. The summations at the bottom of the columns is still correct I just cannot view the data anymore. Any thought on recovering my data, I think it must be still thereI just am unable to view it. all other columns about 20 of them appear to be working fine. thanks

Hi, before in the share view, we can right-click a column head and select filter or group by this column. But recently we notice this function is disabled. Can we recover this function?

Hi. I have no scripting experience so hoping someone can help. Is there a way to use the scripting block to delete all records from certain tables? I can do this manually, but I have to do this from 8 tables out of 30 in a base that I duplicate regularly. If there was just one button I can click to do this at once, that would be amazing. Bonus if it first asked to confirm that I really want to do this, so someone doesn’t accidentally click it.

I am working on the intake of roster information for Wildfire Firefighters. We have availability beginning and end dates that we could see might need to be changed. I would like to allow an individual to make a change to just their information after they have submitted an intake form. Submitted info goes into a grid view that will be displayed on a pw protected site for high ranking logistics officers to access. One option is to have someone submit their changes via a change request form. The change would be sent to an admin and they would update that. But I’m looking for a way for someone to control their own info without the use of an admin in the middle. Thoughts?

Hello to all, First of all, sorry for my bad English :winking_face: I would like to get the duration of a video available in a column containing a Google Drive link and then copy it into a “Duration” column of my database. Do you think this is possible? Thanks

Hi there :slightly_smiling_face: I’m trying to batch update a date field in a specific view. The new dates are coming from a formula field (I’ve assumed the output of the formula field in the scripting app is a date because it’s formatted as such in the table). It runs with no errors but the dates aren’t actually being updated in the table and I’m not sure why. If anyone can pick up from my code why it isn’t updating, I would really appreciate it.

Hi, I was wondering: Do all scripting apps count against my app limit of my plan? For example in Pro Plan => 10 apps per base So when I have 10 scripting blocks inside one base I am already on the limit? If so, does the fact, that there are 2 paying users change this limit to 20? Help / Feedback really appreciated. Thanks in advance Onur

Hi guys, i am really new to airtable and i am looking for a solution on an issue thta, so far, i hadn’t find an answer. All i want is to show on a table, a value from another table created. Let me explain a bit better: On one table i have all the interactions with my customers. These interactions have a field called next action with a date and another field with the action itself. On another table i shall always have the next action shown. This has to be dynamic because as interactions keep being updated, the next action should always be the last on created. Hope i made it clear. Thank you very much for your help!

I want to send a message to a Slack channel based on the message in an airtable cell. And I want it to trigger when its the date in another column. I can’t seem to find an automation in Airtable or Zapier that triggers on a certain date, just at regular intervals (daily, weekly, etc) Any help would be appreciated! Thank you

How to check or uncheck all 100 records in a view with one click ?

I have a webpage shared view of a calendar that has a button link to a URL. Previously I could have the button seen when a record was expanded on the web view of the calendar. Now if the button is enabled under “customize labels” it adds the text of the URL to the calendar entry. How can I continue to have that button to link a URL on a web shared calendar without it showing in the title of the calendar event? Images to explain what is happening. The button is named “Change Request.” The first image shows the button hidden and therefore not available, but the calendar looks like I want it to. The second with the button enabled, adding the URL information in the event title. The third image is how it has always looked when the calendar event is clicked on to expand the record. This is where the URL could be clicked on. This all worked until just recently.

Hello! I’m looking for recommendations for easy access to shared dropbox documents for our team. A process of uploading working content documents to Airtable in such a way that everybody can see the current version as edits are made. Thank you in advance for any ideas.

Super excited to share a big update for anyone that’s trying to connect Airtable to Webflow CMS! As of today, Whalesync now supports two-way sync between Airtable and Webflow! Update data in Airtable → syncs to Webflow CMS (in real-time) Update data in Webflow CMS → syncs to Airtable (in real-time) Here’s a 48 second demo of two-way sync in action: