Ask the Community
Recently active
Hi,I've tried using automations to "find records" but it doesn't seem to be working for me. I have a platform where we assign people from our "Staff Directory" to different stations of an event. I want to have a linked field that adds anyone assigned to a station to a general "Staff Assigned" field that I can pull e-mails from (already have that part setup). How can I have "Staff Assigned" update as each field is updated? Is there another or better way to do this?
I have a formula that pulls text from another field. That field is a link to another table. Airtable is creating quotation marks around the text if the text contains any punctuation marks. Is there a way of stopping this??
When inserting a Date field in an Email Action, the Date and Time format I’ve set within the table does not get used. Instead, I get the default formatting, something like: 2020-06-07T01:00:00.000Z. I’d like the date and time to be outputted in a more readable format in emails, something like 6/7/2020 at 1:00am.
Hi all - I have a table in grid view that I’m trying to group and then sort alphabetically. The table is: Grouped by StateOrProvince from First-Last Sorted by StateOrProvince from first-last No matter how I group, sort, etc. I can not get the table to group/sort alphabetically by State. Any insight you can offer is so appreciated. Thanks!
Super simple question...I have an email action automation that runs when certain conditions are met. I need to update a date field (excluding time) when this automation runs. There isn't an obvious answer to this in the forums. Any ideas?
Hi,I have a table which is sort of a Bill Of Materials containing the all the required parts to assemble a single product, including the required quantity of each part. It's basically looks like:|Product|Part|QuantityRequired|There is another Parts table containing the cost of each part.I'm trying to calculate the total cost for each part in a single field. So far I was able to do it through two fields, one is lookup for the cost of the part and another field with formula {qty}*{cost from lookup field}My question is can this be done directly in a single formula field, without needing the extra aux lookup field to fetch the price of a single part? Feels a bit redundant and was wondering if there's a way to fetch that lookup directly through the formula. (The final calculation of of the product's cost is done in the Products table through a sum rollup on said result)Thanks.
This will be challenging!I have a Table with around 350 rows that i would like to export automatically as database file tha can be opened in excel, something like Timebale.xlsOnce generated this file i would like it to be inserted automatically in a cell as "Attachment" in another Table. Are there any extensions or functions that allow me to achieve this?Any help will be very well appreciated!
Problem...A business software license broker has 200+ records of inventory available for lease. Currently she sends her customers a link to a google sheet. Then they email her back with what they have picked, and the deal moves down the pipeline. There are issues with follow up and communication which result in a lot of missed opportunities. Each deal requires several variables be determined such as Price negotiation, length of term, location, server hosting requirements, etc. additionally there are document generation issues which further slow the process, purchase orders, nondisclosure agreements, and sales contracts. These are all generated by hand allowing for additional project slippage.In an attempt to automate this process she moved the inventory records into a base and created some views then created some forms to allow provider/vendors to easily add new inventory offerings via an embedded form, or she could easily enter it herself while on a phone call. This has proven success
Does anyone know what the character limit is for the length of URLs of photo images exported in CSV files? Is there a way to limit the URL size/length?
first off: recurring issue: where can i report bugs?the record history seems to give wrong information when the change in the record was an addition of a linked record. the record history should say "[USER] created this ['record' or custom name for record as per table settings]" but it does not respect the table settings of the related table and does not use the custom name of the record of the linked table.i.e. i have two linked tables, one called "products" and one "sales". the tables are set up so that records in the "products" table are called 'product' and in the sales table are called 'sale' (for example in the footer of the table when summing up etc).when i create a record in the sales table say 'sale #5239234' related to say the record 'GREEN APPLE' on the product table, the record history of that 'GREEN APPLE' records should say "[User] created this sale" and display the change in the link-field. instead it says "[User] created this product", but i created a sale related to a
DEAR ALL,Column type "link to another record" with "Limit record selection to a view"✔️When you try to select a value manually, the list is OK⛔When you copy/paste a value which is not in the list/view, it works ! Why ?BR
Hi all, I’m a social media manager. I have a base which links together editorial content with associated social posts. It makes amazing things like this possible: Now, I’m trying to create a fully automated UTM parameter system which collects data from various linked records — such as linked web content, associated campaign, etc — and spits out a single URL with appended UTM parameters for tracking in Google Analytics. I’ve got most of it figured out. One step remains: how to extract part of a string. In this case, everything found AFTER the final “/” in a given field. Here’s what I mean. I’d like a formula which scans this text, finds the final “/” in the string, then spits out everything AFTER that: Here’s my current, incomplete formula: Could I do this with RIGHT()? Any help is much appreciated! Thanks in advance. :blush: Best, Alex
Hi,i am creating 3 tablesINVENTORY, SUPPLIER, PRICEINVENTORY contains every items SUPPLIER is just supplier namePRICE containsLinked table INVENTORY, linked table SUPPLIER, currency field.thefeore i have:SupplierA ProductA usd10SupplierB ProductA usd9 I want to design my INVENTORY table so that i can see the min price with the corresponding supplier. I did rollup the price and it is easy. How about the corresponding supplier? How do i rollup this?Thanks
Hi all, I’m currently trying to set-up a pie chart via Airtable’s ‘Blocks’ function. Is there any way to choose my own colour for each of the segments? The default colour scheme that my pie chart is using is completely contradictory from the labels of each of my segments - and I can’t find a way to change it. Any ideas? Thanks in advance. Cheers, Mark
I have a summary table that is comprised of a single row with a linked field (projects) containing multiple values, then a series of rollups with $ calculations based on project status back in the project table.I would like to automate the addition of new projects to the summary table linked field when projects are created in the primary table, and also automate the deletion of those linked field values when projects are completed.I'm unsure how to best accomplish this in an automation. Are there any suggestions?
Hello,Can anyone help me?I'm trying to get the data from Airtable by using this scripthttps://github.com/sleiman/airtable-phpHere's the code<?phprequire 'vendor/autoload.php';$apiKey = 'tokenFromAirTableMyAccountSection';$database = 'AirtableTest';$tableName = 'Data';use TANIOS\Airtable\Airtable;$airtable = new Airtable(array( 'api_key' => $apiKey, 'base' => $database,));$request = $airtable->getContent( $tableName );do { $response = $request->getResponse(); var_dump( $response[ 'records' ] );}while( $request = $response->next() );after all that I'm just getting NULL.Any help would be much appreciated.Thanks.
I am in Real Estate and have created at table for all my transactions. Some date fields are calculated based on a formula. For example, a Loan Application is due x# of days after contract date - it can vary based on the contract. I am creating a template that lists tasks based off that calculated date. I create the template and choose a relative date but the calculated date is not listed, only dates that are manually entered (vs. calculated) are showing. Does anyone have any suggestions on how to accomplish this?
Hello everyone, I have a data base with activities wher date and time are fulfilled but I would like to show only the hour in one column.I'm unable to display what i want. I have for example one column with ISO 14/12/2023 1:52 and i would like two different columns with 14/12/2023 and another one 13:52 Thank you for your help !
Hi, Seeking help here.. I need a formula in the Client name cell where in it will only show the client name if either of the Client or Brand columns has a name on it. Meaning if the Client cell has a name the Client name formula will only show "Path Social" and if the Brand name has a name on it "ThingTesting" it will only show in the Client name cell
So if you have an Airtable Enterprise account and issue personal access tokens (PATs) tied to a service account. Apparently, once you create 100 PATs, the interface WILL NOT let you issue any additional PATs tied to that service account:Honestly, this seems very arbitrary. The workaround is to create *another* separate service account to issue new PATs, but this seems very, very janky.I don't understand why Airtable gates the max number of PATs per service account to 100 total, but it is what it is. This is mildly annoying. FYI.
I have a script that has been working for over a year, but now will not update records. I sync a table from another base to a second tab in main base. I then use the following script I was given over a year ago (can't remember where I got it). It has worked great to look at the synced tab to see a unique ID (emp #) and then pull that onto the main table and pull multiple records from the syned tab. Now when I run it the script runs super fast and doesn't update anything even though I have matching Unique IDs.Here is the script I am using://Substitute "Orders" for table name which contains values//on which you want to run the vlookuplet mainTable = base.getTable("Covid LOA");let mainTableRecords = await mainTable.selectRecordsAsync({fields:["emp"]});//Substitute "Product" for table which contains range to searc
Hello! I'm trying to create an email automation to go out to my team on a weekly basis that would display our top three social media posts by engagements within a certain timeframe. I've figured out how to set up the email and created a view filtering for that timeframe and sorting by engagements. I've seen there's not really a way to limit a view to a certain number of records automatically, but I wondered if anyone had any workarounds or ideas for setting up this email to go out without the entire list having to go out each time and without me having to go in and manually change something in order for the email to go out? Tall order, but appreciate any help.
Hi, I'm pretty new to Airtable and currently just exploring if it will be viable for our company to use. The set up I have is two tables, one for learners and one for workshop sessions. The sessions table has names etc and a field linked to the learners table that shows the attendees booked on the session (multiple select allowed). The learners table has a similar field linked to the sessions table showing the sessions that they are booked on to (again multiple selections allowed). What I would like to be able to do is have a new field on the sessions table that for example shows the attendees that did not show up (nothing fancy I would just use a linked field to the learners table and just input the learners manually, again multiple select allowed). But then I want a corresponding field on the learners table showing the names of sessions they have not attended, is there a way to populate this with the session name (stored on the sessions table) based on the d
Hi, I'm currently on a free plan with five editors. We are considering upgrading to the Premium Team plan. But wnat to clarify if $20 a month means we can retain our five editors from the freemium plan.
I am a solo lawyer but I collaborate on some of my cases with other lawyers.I need to be able to see all of my cases in one place, but I need to share information with the other lawyers only for the cases that they are involved with and they need edit-level permission. “Views” are not sufficient to share information in a usable format, so I have created “interfaces” to do that. The problem is that interface sharing seems to require base-level collaborator access, but all of the cases are currently in one base and based off one master table with several related linked tables for specific things.Under this arrangement, some of the data for cases that are not associated with a given collaborating lawyer may be visible to those nonaffiliated lawyers, but it is impossible to know or to control that easily.I don’t know whether to divide the cases into bases according to the co-counsel or not. If I did separate the cases into separate bases, I would still want to have one in
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
