Solved

Hi there, I’ve taken to Airtable recently to catalog all my acquired clients. I have a single select field called ‘$Flow’ that tells when the current status of the client in the sales funnel, for example: Made contact, Talking, Email, Won, and Lost. What I want is a formula that can tell me exactly when I win a client over. I.E. when I turn the single select field from any other option to ‘WON’ the date (and time, if possible) should be captured in the formula column. I used the formula: IF({$Flow}=“Won”, NOW()) But the date always resets every time I reopened the table, not when I originally turned the option to WON. Does anyone have any suggestions that could help? Thanks Yashwant.

I use Airtable to hold content parsed from HTML emails. The html content is in a long text field. I want a Block that I can use to render the message content from those emails. Does this exist?

Hello! I have a program that can make API calls via HTTP Request but you can only input URL’s. Is it possible with the Airtable API to create records using just a URL with query parameters? Everything I’m finding says to use curl but that’s not possible with the software I’m using. If not is there a service that my software can send a URL with query parameters to and then it takes it and executes the proper curl to Airtable? Maybe Postman? Thank you.

Thank you for taking your time to look at this. The company I work for offers services that are modular, so not all clients are going to request the same services. The client will pick and choose the services that they need. To help automate the quotes we give for our pricing, I’m trying to use a formula field to calculate the final cost, however I’m running into problems. As of right now, I want to use multiple single select fields with the name of the service with the options of selecting YES or NO I’ve written up the following formula. IF({Service 1}=“Yes”,13,0) I can assign a dollar amount to the service.The problem I’m running into, is getting all the services to add together to give one total amount. What I would like to do is, 1. Give each service a dollar amount. 2. Then using that number, calculate all the services the client has requested into one final total that uses the currency format. Lets pretend that there are 3 services. Service 1 is $13. Service 2 is $67. Service 3

I’ve generated a page using the page designer block. Is there a way to create a new field in the original table and add a print of this page? I’m thinking along the lines of an attachment. Thanks!

I already receive submissions to my Airtable via a form, and would like to allow submitters to pick a date from a list of available dates from a calendar field. Once someone reserves or picks a date and submits the form, that date should be removed from the list of available dates. I would also like to allow people to reserve dates up to 3 weeks into the future. Calendly already supports this functionality (and in fact I have a Calendly for this purpose) but would prefer to be able to collect submissions from a single Airtable form. Is this possible?

Hey hi! Ok. So I have a Table with multiple Views, each with a specific criteria of hidden tables and Page Designer set up to pull from various Views. All seems totally normal. BUT… when I attempt to edit a record from within the Page Designer Block using the “Expand Record” button, Page Designer will only ever show me the same specific View. Doesn’t matter what View I select in the Block’s dropdown; whenever I am trying to edit from “Expand Record” from within the Page Designer Block it seems “stuck” on showing me the same (read: wrong) View; a View that has all the wrong hidden fields. I have reloaded the Block. I have disabled/enabled the Block. Any ideas out there? Anyone noticed similar/same ? Thanks C

Good Morning Brilliant Friends! Is anyone aware of web based database tools that are ideal for data analysis and ongoing process capability analysis? Airtable is great for project management, but is extremely limited in it’s ability to crunch data. We could use Microsoft Access, but it’s not exactly intuitive and I am hoping to find a beautiful interface like Airtable, but focused on data analysis. Thank you! Paul Warren

As our business has grown over the last several months, we are finding a need to automate some redundant tasks. Is there a way that I could create a ROW in TABLE 2 when I add a ROW to TABLE 1 (When a certain field is VALID)? Furthermore, if this is possible - could I have the new linked row auto populate with fixed fields or information? Ex: Table 1 (Manual Input) ABC Liquors / 123 Boulevard / John Doe 123-456-7890 / … / Conditional Field that yields NEW ROW Ready to Launch? (Y/N) Table 2 (How do I add fixed fields in place, if possible) ABC Liquors / Ready To Launch / …general info… / (Y/N) / Fixed Fields / Anyone’s expertise is greatly appreciated!

I accidentally deleted my table when I was trying to delete a view. How can I recover this?

Hello, We use Airtable for confidential information. Is there a way to lock a view so that not only can our team not change the filter settings, but also not be able to duplicate the view? Also, is there a way to create a personal view, but for a group of people? Is there a way to keep people out of certain locked views? Something else that would be helpful is being able to customize the permissions of each user for each view. For example, I would like users to have editor permissions for Views A, B, and C but Read only permissions for Views D, E, and F. I know this can be solved by creating different bases, but because we can not link bases, copying and pasting records from one base to the other would allow the possibility of clients falling through the cracks.

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