Other Questions

Here is the scenario. I have a formula field in Table A {Loan Amount}, that calculates the loan amount based on two other fields in Table A. Based on the resulting value in that {Loan Amount} formula field, I would like to to reference the cost of title insurance (the cost of title insurance is based on the {Loan Amount} in Table A). Is it possible to have a field in Table A that references this cost from Table B, based on the calculated {Loan Amount} field from Table A? If not, is there another way I could maybe handle this?

I’m having an issues with the filters. When I select several filters to look at specific data entries the filter will change on its own. Any ideas on why this is happening and how I can stop it?

I own a gym and we check-in customers through a base on Airtable. On my website, I’d like to have a live count showing how many people are currently checked. Any idea how I can create this live count and embed it? Here’s an example I made using the Summary app:

Hi, I’d like to know how whether there is anything clever going on with the single-select field (the Training field) on this official Airtable form that I was sent recently: Watch on-demand: Create your CRM in Airtable I have a form where I would like to pre-populate the field, but not allow end-users to change it. I’ve read a bit on this discussion group that it isn’t possible (you can’t hide or make the field read-only). I suspect this form is pointing to a custom view, but I’m looking to have personalised forms, where a field is specific for the user, and they can’t change it. Many thanks, DIgby

Hi, folks: Our volunteer organization took in the personal info of 600+ volunteers via a form. Now we need them to update their records via a second form so that they don’t have to fill out the first (very long) form all over again. This seems to be a logical solution … Update table records in form

Is it possible to show records formatted in page designer into a Wordpress website? All I’ve found on the forum is from early last year that the feature is coming. If not, are there any good workarounds? Thanks!

I am attempting to set up an automation and have a script update a linked field in a table. When testing my script the output gives me this error. “Your script has a syntax error” (adding this for search engines cause I could not find this on google at all) The bit of code that makes this error happen is this (it has no syntax highlighted saying it’s an error) await customersTable.updateRecordAsync(depo, { 'Dams': dogs }) depo is from here let depo = depositors.getRecord(depositors.recordIds[index]) depo looks like this when logged: {id: "rec1231412312", name: "Some name"} dogs is an array of objects (“dog” records) like this. I’m not

I have an address field that opens the location in google maps when clicked. It works fine when logged in as a creator or editor but doesn’t open Maps when logged in as a read only viewer. I don’t get an error it just does nothing. Any idea how to resolve? Thank you!

I’ve been using airtable a few hours but I get this message: "An error has occurred. Refresh this page." I’ve refreshed and tried again multiple times.

Hi! I’m trying to figure out a way to get data from ‘Table B’ to ‘Table A’ based on the value of a field in Table A. It looks as follows: I have an entry in Table A, for which I select ‘device’, ‘pagetype’ and ‘country’. For the combination of these three fields I want to create a unique identifier, so I’ve added a formula column: This would result in for example MobileHomepageGermany. In Table B I have set a ‘value’ for MobileHomepageGermany of 100. I want to lookup this value and add it to a column in Table A. So I add an entry, select device, page, and country, and then I want the value to show up in that Table in that row. I’ve been trying to figure this out for 1,5 hours, but its probably a simple solution right? Th

Hi all, I am wanting for filter a grid view so that it only show items with the current date and future dates, and doesn’t show any past dates. Is this possible? Thanks :slightly_smiling_face:

Hi, I’m new - sorry, ha ha! I’m trying to put the date from my date field {Start time for Pre-Meeting} into an email automation but it outputs in the unfriendly format So I’m trying to re-format that date in a formula field using DATETIME_FORMAT but I keep getting error messages. TIA for any help with this one! Cara.

I am trying to create a system that allows me to pull up certain records, open them in gallery, call them, mark that they have been called, and then they disappear from that view. The use case is creating call lists for fundraising and recording those contacts so that I won’t call them again the next day for instance. I have only been able to find out how to do this in the form view of an interactions table but that doesn’t allow me to pre-select the contacts I want to call. This is mostly useful for sharing the list to others to make the calls.

I’m looking for an app that can be used as a Visual Line Plan view. Kanban cards are close, but I am looking for something that is more freeform and can be moved around and seen with a wider scope. Ideally I want the freeform layout of MIRO boards, but from what I can tell, there is no way to link the live data from Airtable to MIRO and vise-versa. Thanks!

Guys hello We are using Airtable to organise our daily tasks. We have a task we stuck at the moment so we need the help of a coder to create a script to run on Airtable Base. Here is what we like to do We are using Airtables CSV import app and importing CSV to the right column. There is no problem with that. Problem is (what we like to do) to insert another row (pre-defined) automatically, when we import new CSV. So 1st row will come from CSV, under that another predefined row, and repeat like that for each row. (Please see Screenshot1) We tried to do it with automation on Airtable but when we import CSV, created all rows from CSV But instead of adding predefined row under each row, adds all at the end. (Please see the second screenshot) So we are looking for a solution to solve that. I guess a custom script will solve the problem. Or some tricks on automation? Any idea?

Hi everyone! Does someone know how could i change this “2021-02-16T21:30:18.110Z” (text type field) to a date and time format and change the time zone (the hour is coming with 5 hours of difference of what it should be, it says. “21:30” when it should be. “16:30”. Thank you so much in advanced!

Hi, apologies in advance if i’m missing something very obvious here. I’m trying to create a shipping label, pulling the name from a single line text field, and below that the address from a long text field. I want all the text to be aligned centre, however on the long text (address) the option is greyed out. Vertical alignment is available, but that’s not what i’m after. Is it not possible to centre-align my text?

I have expense fields set to ‘Allow Negative Numbers’. It would be really helpful to just enter 5.24 and have that field make it a negative number. I have a ton of fields I need to manually enter the currency for and trying to remember to add the minus sign for the expense fields is proving challenging. Is there anyway to 5.24 and have it show up as -5.24? If this is possible will the negative field currency now translate in formula when summing several currency fields with a formula? Many thanks :pray:

I would like to be able to limit the number of times a person can enter into a form for a 24 hour period. The table contains requests to our research center so we want to limit the number of requests from an email address to five requests per day. Ideas on how to accomplish this?

Hi everyone, I’m new to AT and especially the Gantt view - so if this is already answered please point me in the right direction (I looked and couldn’t find it). I’ve got my tasks set up. If I push my dates out, all of the successors push out just fine (e.g., if task A was ending Feb 1 and I change to Feb 5, Task B pushes out to Feb 5). When I shorten a duration, the successors stay in the same place (e.g., If I move Task A to end Feb 3, Task B stays at Feb 5). This is pretty critical for us. Any suggestions? Thanks S

I would like to be able to link two tables in such a way that a record appears identically in both upon creating the record and updating it as time goes on. For example, my boss and I have separate tables for our ongoing “to do” lists. She would like to be able to create a record on her table and have it pop up on my table in the same dept (single select field) and that when I update it on my table, hers is also updated simultaneously. Is this possible? Not using the “link a record” field, bc that isn’t working for her. Thanks!

Just wanted to give a shoutout to the Airtable team for building amazing product and bringing easy to use templates from members of the community! Reflecting back on what an intense year 2020 was in shifting to entirely remote work, I don’t think I could’ve helped organize my own work and collaborate with my team without the help of Airtable. This post is less about an open question, and more to give kudos to a very needed product!

Hello Friends - I created a formula to return the Week # an Item Sold, it was working great until this past week. In the screenshot below the second item in the list sold on August 10, 2019, at 9:01 pm. But the formula in the Week Sold field is returning that the item sold in Week 33 when it is actually Week 32. Here is the formula I’m using for the Week Sold field: DATETIME_FORMAT({Start Date},‘w’) Need your help, I think this is due to the fact that I have hours in my Date Sold field, but I’m not certain how to proceed with correcting the formula. Thanks in advance for your support!!!

Hi All, I am using the “Prefilled forms” App in order to prefill a form. It works quite well so far for single select prefilled values and triggers great URLs automatically. However, if I have multiple values corresponding that correspond and need to be pre-filled, it only shows the first one. Is it possible at all to have it show all values corresponding to the field? i.e., make it possible to create a drop-down / multi-select question in forms based on the prefilled-form. I believe this would be a logical add-on to the prefilled forms as many questions are multi-select. If there is another way to get there, I am open to creative hacks! Thank you! Diane

Hi, Have tried going through the other topics to find what i need but doesnt seem there is an answer or a way to do what i need but will try ask with specifics or what i need and go from there. I have a base that imports entries from an airtable form of tool movements aka date, plant no, original location and new location. This could mean multiple tools so i made a linked plant no column to another table with our inventory. For the information to pull through to the inventory i have made look up columns to pull the information through for one tool vs them in a group but with the look up field i would like it only to show the most recent information or at least fill them in most recent to oldest for easier viewing. Is that possible? I have also tried an automation to update each listing but with no luck at separating the bulk entries into separate tool listings. Thanks in advance