Other Questions

Is it possible to build a multi level bill of materials? Similar to this Bill-of-Material-Setup.png695×533

I will want to possibly create several different lists so that they can be choices for different drop down fields. Thank you.

I am creating a Master Calendar & Team Calendar system in Airtable, where each calendar update automatically updates/creates based on an update in the other calendar. I put together a system that created a “Unique Event ID”, which is a shared ID for the same event across both Bases. Everything is working great so far, except that I would like to delete records automatically in one Base if the corresponding record is not found in the other. There’s no Delete trigger in Integromat, so my workaround is: -The trigger is an existing “Update Record” automation After that automation completes, the automation will do a scan on both Airtable Bases. Step 1: Search all existing records on Master Calendar Base (up to 10,000) Step 2: Search all existing records on Team Calendar (up to 10,000) Step 3: Filter, then Delete - If the Event ID is found on the Master Calendar Version but does not exist on the Team Calendar Version, Delete the record on the Team Calendar (up to 10,000) I’ve tried a f

I’m trying to set up a hire system that tracks when an item is on loan or when it’s available. Is there a way to restrict selection of an item if it is ‘on loan’ for that date?

Is there any way to create a read-only table view that can be accessed anonymously via the API? I just want to be able to do a simple table lookup/mapping (with a filter formula) with a front-end Javascript call without exposing an API key (or having to host a back-end script on a 3rd-party server). Alternatively, is it reasonable to create a “collaborator” account with read-only access and expose that account’s API key?

I have recently configured the Map block on a few tables with a total of couple of hundred rows between them. A few days later I checked my Google Developers console to see how my geocoding API key was faring, and I was shocked to see ~18,000 requests for that key. If I open a Map block and the associated table simultaneously, I can see the geocoding cache column get updated repeatedly as I interact with the map — even though no data in those rows is changing. The gif below shows cell updates being triggered just while viewing/panning/zooming the map… Then, if I open up one of records in question, I can see a bunch of changelog entries of the form: “User X edited this record using Map block Y”… Can anyone explain what’s going on here? I’d like to keep using the Map block, but not if it’s going to blow up my API quotas simply by viewing the maps :frowning:

What am I doing wrong? How do I as the owner, make it so multiple users (<10) are able to view/update the database at the same time?

We would love to be able to use AirTable to create interactive client facing asset collection docs that only let them make edits to a couple fields (such as client notes and an upload portal). Ideally they would be able to do this is in a view where they can’t change anything except those couple fields. I’m not seeing an option in the field permissions to do that. The closest thing I’ve been able to come up with is giving the client editor permissions and then locking the fields we don’t want them to change. This still allows them to make edits to the view, grouping, filtering, etc. that changes the entire document. Is there a workaround for this that offers permissions sort of in between editor and a view link where they can’t make changes to the table but can utilize the upload feature in the records and maybe paste a URL? What I’m imagining is a locked kanban view where each card is a task for a process or asset we need from the client. They would be able to click the card to see th

Use SendGrid block to contact our members, great! But is it possible to schedule the start of sending? Met vriendelijke groeten, Geert Dornez

Hello, I am trying to gather information from my colleges on how they do specific tasks through out our building (some departments have the same tasks but are done differently, we are trying to accumulate all the data and compare). I have a grid view of all the tasks from all departments, but I am having trouble finding a way to track which department answers which questions and making sure that when a department does answer, the question can not be asked again (I do not want duplicate data if someone forgets that they already answered a previous question). Is there a conditional format I can use to accomplish this or will I need to find an external form builder? Thank you.

Have had this issue before, but haven’t really tried as hard as I just have to solve it. I copy and paste in a list of names from a spreadsheet directly into a ‘link to another record column’ for contacts. This work awesomely to bring out a ton of information I can then export to another app in the right form. What’s really wierd is I need to do this for a different set of data from a different source in a different table. I set them up the same way, but Airtable won’t let me paste the data straight into the “link to another record column” for contacts, it doesn’t matter whether I’m doing it from GSheets or Excel. HOWEVER, if I paste some of the names from the other sheet used above, it DOES work. So, in summary, Airtable is letting me paste names directly into a “link to another record column” from one spreadsheet, but not from another. How can this be?

Hello everyone - Does anyone know how to send an email notification when an editable field within a record changes? I looked at Zapier and the only triggers are New Record or New Record In View. We have several scenarios where people want to be notified via email (not currently collaborators) when information changes. Many thanks for your insights and advice. Doug

Basicly everything is in the title. I have a checkbox filed that return null instead of false when not checked. Is that some normal behaviour ? am i missing something ? Here are some screenshots

Hi everyone ! I’m not new to Airtable, but I’m completely lost with the calendar sync … I tried everything i saw on the web, but i can’t do what I want to do. So here’s my goal: I have a date column in a table, which is the “Next call date”. I would like to have a new calendar event created in my Google Calendar each time this date is updated I tried this with zapier and views, I tried with sharing the airtable calendar. I thought to create as many columns as events I need, and views with certain filter as triggers, but it’s not really clean … Thanks for help !!!

Hello, I would like to be able to view various locations daily performance reports. Is it possible to have several different forms within one table and then create a view or report for each of the locations? I was thinking to create forms that can be completed for each location and then be able to view a report based on location or other criteria in the future.

We are using airtable as our CRM system. We have an interaction tab set-up where our sales team records interactions with leads and clients. When we open the contract record the interactions need to be sorted by the “Date” field - located on the interaction area. Even with the view being sorted by date they are not appearing sorted by data on the contact record preview (sample image attached). Can anyone provide insight on how to get them to show up in the correct order?

Hey :slightly_smiling_face: We use [interactions] table and we have a linked field to [customers] table. If we don’t have the right customer we can create a new recored in customers table BUT if we use the form we can choose only from the exists customers and we do not get the option to create a new one… What do I miss?? Thanks

Hi, I need a report (list) of all bases created on a workspace. It´s possible? I need to list all the names of the bases created on a workspace. The result must be recorded on a base named report Thxs

Hi Forum, i created a Gantt block for one of my projects. The problem is that while I can change the start and end dates manually I can,t move the bars in the block view. I have tried everything to no avail. I even created a new base and copied in the bar items, which didn’t work either. i would be grateful for your help.

I’m trying to roll up a bunch of different dates. I need them comma separated in an array, so I later can replace the comma with a line break to display them on top of each other. I’ve tried with ARRAYUNIQUE(DATETIME_FORMAT(values, ‘DD-MM-YYYY’)) in my roll-up field However this only works if there is only one date, but when there is more dates then they return ERROR. Is there a way around this?

Hello Airtable Community. I’m actually not sure if the subject is the right for this question but it’s the closest I could think of. I created a formula field to autofill out instagram.com prior to a profile name to save me re-typing it every time. (Thanks to Scottsworld for helping me with that) "https://www.instagram.com" & {profilename} Is there a way to only show instagram.com if a profilename is not empty? ie nothing will show in the formula field if profilename is empty. Hope this makes sense!

Is it possible to hide fields in the expanded view? Right now the expanded views is totally unusable. We have over 100 fields in our table, but only need to see 6-10 in the expanded view. Is that possible? Thank you!

Hello Airtable Superheroes! A major frustration with the Gantt block for our team is being restricted to using two input date fields. It would be so nice to be able to have one of them be a formula, so we can drag the dates around, which would change one of the dates and then the formula can update based on a duration input field. This seems silly, because you can just drag things around already, but if someone manually updates a record’s start date (which is very difficult to control with the current permissions scheme), the end date does not automatically update, nor does the gantt automatically shift to accommodate the change. Another super feature, would be to have the gantt show how many records are scheduled for each day. Because the gantt view is so “big” and blocky, it makes a lot of scrolling up and down is required to have a an idea of the number of tasks scheduled for each day. Giving a summary in the top date bar would be a HUGE help. Alternatively, I was going to try a com

I do not see a way to add a time field, so someone can choose 7:00am or 9pm, etc.

I have table with 3 fields name(lastname,firstname, email). id seems to be auto incremented in airtable. Now am trying to update records where id is 1 with the code below but it displays error below here is the code I have table with 3 fields name(lastname,firstname, email). id seems to be auto incremented in airtable. Now am trying to update records where id is 1 with the code below but it displays error below here is the code 1.) update records where id is = 1 const first_update = base.getTableByNameIfExists('myfirst_table'); // Update cell values //{id: record1.id, fields: {'My field name': 'updated value 1'}}, const ok = first_update.updateRecordAsync({id: '1', fields: {'lastname': 'Carrots-2','firstname': 'joy-2', 'email': 'joy-2@gmail.com'}}); if(ok){ alert('records updated successfully'); } 2.) update record where id is = 1 and email is = john@gmail.com const first_update2= base.getTableByNameIfExists('second_table'); // Update cell values //{id: record1.id, fields: