Solved

Hello, I would really appreciate some help here. I have a big list of client birthdays, the majority of them are partial dates (DD/MM), but some are complete dates (DD/MM/YYYY). Now, I have 3 fields: Date of birth This is a single line text field because I can’t enter partial dates in a date field Age This is a formula field I use to get their age when I do have their full date of birth IF({Date of birth}, DATETIME_DIFF(TODAY(), {Date of birth}, ‘years’)) Birthday This is a formula field I’m using to strip away the year of complete dates and make both, partial and complete dates, recurring dates that I can see in the calendar view IF({Date of birth}, DATETIME_PARSE(DATETIME_FORMAT({Date of birth},‘MM/DD’)&"/"&YEAR(NOW()))) The problems I’m having are the following: We use the European date format (DD/MM/YYYY) here, but when I enter a partial date in the date of birth field (single line text field), say, 1/6 (June 1st), the birthday field (date field, European date for

Hi all. Total AirTable newbie here, and I’m hoping someone can please point me in the right direction. I’ve started working with a charity that uses AirTable to track requests that members of the public file for COVID-related assistance. There are two tables involved specifically in what I’m trying to achieve: Requests and Requestors. The person making the request fills out a WordPress form with name, postcode, etc. which are fields in the Requestors table and details about what they’re requesting from the charity; these are fields in the Requests table. Within the Requests table, there is a field which is a link to the Requestors. We end up with a lot of duplicated rows in the Requestors table if people make multiple requests. What I’d like to be able to do is intercept the form when it’s submitted, check to see if there’s a criteria match in Requestors (say on name and postcode) and if so, assign it to the existing requestor. If there is no match, then it would create a new requestor

I just cloned the to-do list example to get familiar with blocks and it starts with a can not read primaryField of null when compiled. It’s a small fix with the code i found, this is just if anyone else finds it also for the airtable team to update their sample code. Since there is no table selected in the beginning of the list table is null therefore need to add in a check for table present before calling table.primaryField. const records = useRecords(doneField ? view : null, {fields: [table ? table.primaryField : null, doneField]}); {fields: [table ? table.primaryField : null, doneField]}); update this object! Thank you!

Good morning, Developers, @Katherine_Duh, @Airtable_Admin I found pory.io on this message thread. As I’m struggling to study and practice Script-Block and Custom-Block simultaneously while I’m supposed building an excellent airtable frontend, I don’t have an airtable frontend at the moment. In its current state, pory.io looks very attractive for a temporary airtable frontend for me before maybe one day I will find time to do much more with the same REACT needed for the Custom Block… But after a registration at 0$ to try it, I stopped: I can’t figure out who is pory.io at all. Do you know these Developers? I’m really not enthusiastic about giving my airtable API-Key to a site I can’t find the Owner, the office address, the phone, the company registration number… What does the CSO think about it ? Best, oLπ

Hi, I found a script enabling a percentage count: https://airtable.com/shr1uUxBtpin68DsN/tbl83MENluhVCm20y/viwuf0HQjtKfYVvmb and I would like to adapt it by counting the number of cells completed, in place of the direct input in the “Current” cell. What type of formula can count the number of cells completed for a specific row? Thanks for your help.

Hi, I understand the idea of normalizing a database - and I see that I can create a column type for a drop down list. Why use a drop down list instead of a linked table? Is there a configuration/structural reason to do so, or is it just easier?

I have a table titled “BIO” where I’ve made records for each player on a football team. I also have a “REPORT CARD” table that includes a record for each player and a field for each player’s grade and a field for the players GPA dependent on their grades. This GPA is used as part of a disciplinary points system for the team. Points are stored in a separate “POINTS TRACKER” table. I’ve created a ZAP so that when a new record is added to the BIO table, a new record for that specific player is also added to the other tables. My problem is this: I used a linked field to connect the REPORT CARD and POINTS TRACKER tables. This allows me to pull that GPA score into the points tracker to be used to calculate a points system score for each player. However, when I add a new record, this linked field does not update the linkage for the new record. Any tips are appreciated!

I need to find a way of creating multiple views of all data from a table. Ideally I would like to create a table and duplicate the table in a way that if I edit the data on either of the tables it will auto update on the other table and I can set up different views and filters for each of the linked tables. I may want to show all tasks for one team member on one table and all tasks for part of the project on another table but be referencing the same data on each of the table veiws. The columns would be the same on each table, better still if you edit the column properties on one column it will update on the other. Any help with this would be much appreciated.

The code below successfully display records. Please how do I add pagination to it. Thanks const base = useBase(); const table = base.getTableByNameIfExists('myfirst_table'); // grab all the records from that table const records = useRecords(table); // render a list of records: return ( <ul> {records.map(record => { return <li key={record.id}>{record.id} -- {record.getCellValueAsString('lastname')}</li> })} </ul> );

I’ve been trying but it seems like it’s not possible.

i can see and press the copy button for the examples where is the paste button and where do you paste what you have copied???

Is there any way for a “Link” field to share the filter properties of a “multiple select” field? For example, when filtering a multiple select field, I have many options (e.g., has any of, has all of…) and I can toggle the selected options on/off. Seen in these 2 screenshots: However, when filtering a linked field, I have limited options and I have to type in the exact thing I’m looking for. Seen here: Is there anyway to get the link field to act like a multiple select field? I don’t suspect there is. But wondering what the roadblock is to making this happen. Can that be programmed? My current solution is suboptimal. Every so often I copy the multiple select field column and paste it into a column designated as a linked field. It works but require a lot of ongoing maintenance and if I change the name in one place, I have to remember to change it in the other field. It’s a hassle. I would love a way to allow Link fields filterable similar to multiple select fields. Any advice

Hi, maybe I its to obvious and I don’t get it - but how can I work with the outcome of a formula field? Every time I build formulas with which I want to “work further” with the outcome of another formula field there is no output (blank). Any idea how to make that possible? Thanks in advance Onur

I’m sharing a view of a table to a client, however, when I update the table, their view isn’t updated unless they refresh the tab. This makes it completely useless for me. I would add them as a collaborator but that would give them access to hidden data that I need to keep protected. Is there a setting or work-around for this? Thank you in advance

Hi, how to use a XOR formula with 3 and 5 arguments (with real world use cases)? I’m trying to understand how i can apply this in real life

I would like to be able to automatically import contacts with the status “closed-won” into a sales tracking table. Example: I have a travel agency, so when a prospect goes into “closed-won” status, I have to do a different follow-up (hotel reservations, excursions, etc). I’d like the contact to be automatically transferred to the customer follow-up file when it is in the prospect file. I’m a novice on the platform, thank you very much for your help. Beautiful day. Alexia

Hi all, I may be missing something in which case apols! I have two fields: an integer field and checkbox field. I wish to set the checkbox field if the integer field is >x. I can see how to simulate this using a formula field formatted as text and a ‘tick emoji’, but this doesn’t work for me as I need to link my base to an external system that uses airtable checkbox fields to construct filters. Alternatively, would be nice to flag a feature request for the formatting option ‘Checkbox’ for formula fields where the output is boolean.

Is there a way at present to debug a custom block on my local while building it? It would be great if I can such debug error like these with better and more helpful build time error messages.

Hello. I am really new to the Airtable API and for some reason connecting the API this way did not work- at = airtable.Airtable('Base_Key', 'Airtable_Key') But I got it working this way - get_url = ‘https://api.airtable.com/v0/BASE_ID/TABLE_NAME’ get_headers = { ‘Authorization’: ‘Bearer API_KEY’ } Response = requests.get(get_url, headers=get_headers) Response_Table = Response.json() However, this fetches only the first 100 records and am reading about offset and pagination but I am unable to figure how to incorporate it into this code. Thank you for the time!

I’m looking to use Airtable as a full project management solution for my company. But one of the requirements is that projects must adhere to a certain project numbering convention: XXXX-0000-X XXXX is a 4-letter code, specific to each of our clients (1000+) 0000 is a 4-digit number, which auto-increments starting at 0001 for each client (not globally, each client counts up) X is one letter, based on the project type Our current system generates this number automatically upon entering a new project. Let’s say that my client’s name is ABC Tool Company. They already have 96 projects in our system. I’m going to enter a graphic design job for them. The client’s unique client code is ABCT. The next project number would be 0097. The suffix for a graphic design project is G. All I have to enter on my project request form is the client’s name and the project type, and the system would automatically generate this code: ABCT-0097-G I’ve searched everywhere to figure out how to get Airtabl

We are an architectural and general contracting firm who is trying to set up an CRM base design using the different ‘Divisions’ (Electrical, Site, Roofing, Doors, etc.) used in building and construction. There are about 31 or so of them that we use and we would like to organize our Airtable so that each subcontractor is below the correct header (a roofer under roofing). CSI Standards What is the best way to set that up?

I’m importing a google spreadsheet of workers and their trades. The sheet has over 11,000 rows (each worker = 1 row). There are 40 trades. Each trade has its own column, and there is an “X” if the worker is skilled in that trade. I converted each “X” into the name of the trade that it represents. I now want to combine all of the columns for each worker into 1 multiple select field so that each worker has one field where it lists all of his/her trades. Any ideas?

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 swear this must be really easy, in fact in excel it’s really easy what am I doing wrong :frowning: I have one sheet on there I have a variety of columns I want to create a column at the end that says how many out of columns xyz (which are all single line text columns) contain text - please can anyone help as 4 hours later a rabbit hole of videos and posts on here I still cannot get it to do anything - thank you in advance