Solved

The records in one of our main tables are legal cases. Each case has the same set of tasks that need to be done to it. When we create a new case record, we want to automatically create the appropriate set of tasks in a task table and have them connected to the new case. Can we do this? If so, how? Thanks!

Hi guys. Trying to figure out the best way to overcome the limitations of the Page Designer and hoping a formula might be the answer. I’m collecting a lot of data in a table called “Rooms”. Each room record has linked products, materials, and concepts, and then I use a bunch of lookups to retrieve the information I’m hoping to display on my Page Designer. The problem is how the Lookup field combines my information. Here is my Product Name Lookup field for one room as an example: Aqua 2 Complete Shower Rail, Lapiana Towel Bar, Lapiana Towel Ring, Lapiana Robe Hook, Lapiana Paper Holder, Square Tubular Pull Handles for Back to Back Mounting, Square Trim for 1/2" Valve, Caso Single Hole Faucet It obviously collects the information in a list, but that’s not what I want. I would like to be able to hand arrange each name in my page design so that each text string can be under their respective images. For that, each name has to be in its own field. Is there a formula that would separate my

I have a simple question. I’m on the Free plan right now. I created 20+ bases in my workstation and sent my clients a link with editor status to the base I created for them so they can add info I need. Is this something I can do on a free account or what plan do I need to do this?

Is it possible to reference a specific Field in a Table from another Table in the same database not just the Name of the records but a specific field with in it. Such as currently only the first field shows up when you used a linked record. Is there a way to say pick a record and display a field from that record OTHER then the first field?

What am I doing wrong with this one? Please help! If ({Date Due} IS_BEFORE{Date to work on it}), “ :nauseated_face: ”))

Hi All, I’ve got a client that wants to be able to view airtable data in wix. This has been easy enough when using a grid - eg customer comments for the last month. But,… what I’d like to do is have a chart eg “customer satisfaction by month” grid data is “date” and “rating” (values of 1, 2 or 3). The awful solution i can think of is manually export to csv, generate the chart, save as image, the save to webpage - but that is awful. Is there something I could do with API? That is way beyond my capabilities though (but I’d happily accept help or pay someone via a freelancer app) I’m not committed to wix so if there is another way I’m open to that. Thanks heaps in Advance :slightly_smiling_face:

Hello, dear Airtable community. I want to generate a unique payment ID, based on the sum, date, cashier, and the type of transaction. Everything has been good by far, until I decided that I want to try using emojis. So, I assumed it should be a mix of CONCATENATE and IF, because I want the emoji to appear only in one field = meaning that IF it says ‘cash’ then show ‘ :money_with_wings: ’, IF it says ‘card’ then show ‘ :credit_card: ’

Can we have several sub-records for one primary field ? We make a quotation based on several quantity ranges. So all fields are the same and only the quantity and prices are different.

Is it possible to recreate this formula in Airtable? Where: i = IRR L = Loan amount F = Points and all other lender fees P = Monthly payment n = Month when the balance is paid in full Bn = Balance in month n This equation can be solved for i only through a series of successive approximations, which must be done by computer. Many calculators will also do it provided that all the values of P are the same. I’m trying to solve for i All items except for i would be supplied via columns inside Airtable

I’ve tinkered with a few ways of doing this, but wanted to get some ideas about the most efficient way. I have this full address string: Street address: 1600 Pennsylvania Ave NW # 15 City: Washington State: DC ZIP Code: 20500-0003 I want to extract the State (in this case, DC). I’ve tried LEFT, RIGHT, MID, etc but nothing seems to zero in on it. Appreciate the help :slightly_smiling_face:

There are more fields being returned than in my View through the API. Any suggestions on what could be the issue? Regards, Ruchika

Hi everyone! I have done several searches and cannot find exactly what I am trying to do. I am relatively new to all of this and my ADHD brain struggles with all of the technical stuff at first, so I apologize if this is very obvious. I want to simply have a “total hours” field that takes the start and end date/time fields and puts it in hours rounded to the nearest quarter. 2/27/2020 8:00AM to 2/27/2020 9:45 would automatically compute to 1.75. This is for a timesheet :slightly_smiling_face: Thanks!

Hi There! I have a series of tasks with deadlines. The field next to “Deadline” is a countdown titled "Days Left’ with the amount of days left until the task is due. However, I don’t yet have/need deadlines for some of the tasks, so the Deadline field is sometimes empty which results in NaN. The formula I used for “Days Left” is DATETIME_DIFF(Deadline, TODAY(), ‘days’) I’ve tried a few different IF formulas to remove NaN but I keep getting errors. Can anyone help me out here?

Hello, I’ve a Linked Table with many entries which are populated by this linking feature. I’d like to add a field that counts all linked entries belonging to that entry. All I could find was the build in Count feature, but it’s only applicable to 1 entry. I’ve been trying different formula combinations, sum, lookup, count, counta. no success yet… How to calculate this?

Hi all, First-time post here! so a big hello! This is potentially a newbie question… I’m trying to stack my based column in the Kanban view but the option isn’t appearing? Based is a multiple select list of local authorities I did screenshot but it’s not letting me post them… Any help be much appreciated Thanks

I’ve seen a couple of different places where other users encountered the same issue when trying to use a simple multiplication formula (it simply does not work gives #ERROR! I am using the asterisk. I’ve read every piece of information available and still am not finding any resolution. I’m going to be pretty pissed if after all the work I’ve done I have to abandon this because of this error in a very basic formula. I used ask a question already and no response yet. I kind of need to get it fixed or move on to something that actually works. I thought I had finally found a gem :frowning:

Hi, I’m using Filter By Formula to find records based on Last Modified Date; As per Codepen Airtable URL encoder I get the following syntax; (IS_AFTER(%7BLast+Modified+Date%7D%2C+%222%2F23%2F2020%22)+%3E%3D+0) While syntactically this works fine, the results I get are not correct. I get dates before the given date too. Any suggestions? Regards, Ruchika

Hi, When I access a table-view through an API, fields that don’t have any values are not returned for that record in the API. Is this expected behavior? Regards, Ruchika

I am asking for some advice. I am working on a problem that I have with my Base. That problem is that I am attempting to automate data updates to one table from 4 other tables on a weekly basis. The puzzle is that I am tracking events that occur on each of these 4 tables on a weekly timeline. These events are by employee, in the case that they incur a trackable event on that week. We are tracking these events on a week (or month) per the time stamp on each occurrence. Each event results in either a positive or a negative score. This score is then subtracted/added to/from a credit on a different table. I have run into two problems. First, I tried to roll up each occurrence on the Employee directory. Rolling up there created an accumulation of points, not tracking by week. I then did a look up on the table with that person’s weekly stats. That repeated all the scores from each week to every week thereafter, making that occurrence manipulate their score every week instead of just the week

Hi, I am looking for a way to input Timecode in a Field, (ie: 12:24:32:00) (HH:MM:SS:FRAMES) The Duration type comes close but no option for double digit hours, and regular numbers don’t seem to allow colons. Anyone have any ides. Scott

Hi there, I’m trying to create a “ToDo” base with sub-tasks. I have one table with different “project” in every row, and second table with a few tasks linked to each project. Now, I want to create a rollup record to pull out the percent of the task that is already done. (like if I have 2 tasks for one project, and one is checked, so it’s 50% done…) How can I do it? Thanks!

Hello, Can you please help me : someone did something wrong in the account and delete a lot of customized fields. I see that I can restore an old version but that creates another version I think (and I am the one who can access in). But I would like to restore the latest version for everybody, is it possible ? Or do I have to open the access to the version restored to all the base ? Thanks a lot for your precious help!!! Justine

Hi everyone! I’m surprising myself by not being able to figure this out. I swear at one point or another I had been able to pre-fill an airtable form with a field that includes an emoji. For example, I want to pre-fill a single-select {Status} field in a form with a status of “ :calendar: Consult Scheduled” I’ve tried it with the actual emoji character as well as with UTF-8 (hex) encoding (which is what Airtable spits out if I wrap the emoji in the ENCODE_URL_COMPONENT() function - see below). https://airtable.com/shrIXXXXXXXXXXXXX?prefill_Status=%F0%9F%93%86%20Consult%20Scheduled https://airtable.com/shrIXXXXXXXXXXXXX?prefill_Status=📆%20Consult%20Scheduled Neither of these work. Am I barking up the wrong tree? Should I just forget about the emoji? Maybe try a different emoji? :slightly_smiling_face:

I have 10 checkboxes in my table. Each checkbox corresponds with a task that needs to be completed. I’d like to build a formal that shows an emoji each time another checkbox is checked. For example, if you’ve checked 4 boxes, there would be :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: . Or, if you’ve checked 10 boxes, there would be :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: . Thanks in advance.

I have a column of linked records. I would like to make a second column that filters those linked records based on a condition. Example: Table 1 Column A is a checkbox Table 2 Column A links to records of People that are associated with the Business Table 2 Column B should be a conditional subset of Table 2 Column A; linked records in Table 2 Column A should only appear in Table 2 Column B if the linked record has Table 1 Column A checked. Any time a checked record is added to Table 2 Column A, it should automatically appear in Table 2 Column B. Similarly, any time a record is checked or unchecked in Table 1 Column A, it should be added or removed from Table 2 Column B. From what I can tell, this is not possible in AirTable. Are there any creative ways to make it happen?