Other Questions

Hi, I have below table which I track all the transactions each per row. Transaction No Description Income Category Total Amount N1 Apple Social Media 100$ N2 Nike Production 120$ N3 Mercedes Content 310$ N4 Adidas Production 170$ N5 Toyota Content 210$ N6 Porsche Social Media 305$ Using the above detailed table, I want to create another table where I summarize the total sum of respecting categories. What I want to do it, I want to sum all values belonging to a specific category in another summary table. Income Category Total Amount Social Media 405$ Production 290$ Content 520$ Tried to use Rollup but no luck. Any idea how I can do this? Thanks

I have a form with a lot of questions, which I’m sharing with people as a questionnaire. Is there a way to have the questions numbered? My questionnaire looks good otherwise, but I’d really like to have each question numbered. I hope there’s a way to do this. Thanks in advance!

Hi everyone, I’m looking for a way to update records from multiple tabs into one single tab automatically. For background, I have a base with multiple tabs in accordance to my org’s departments. Every department has its own unique deadlines in accordance with a program/task. Is there a way to: Create a link, automation, or script to take all of the deadlines from the multiple tabs into one overview tab automatically? That is, every time a new deadline is created in the individual department tabs, it will automatically transfer that date into the overview tab. Create/update records from the individual department tabs and include them in the overview tab? I had a free consultation that ultimately expired so any help is greatly appreciated, thanks!

Is there a way, in a form, to collect the lat-long of the location where someone is (say, from their cell phone) when they upload a photo? Or at least is there a data field format for lat-long? I’m also interested in a time stamp data field, but I only see date, and time modified - I want the user to input the time they recorded the data. Elizabeth

2 Tables - Constituents and Constituent Types. Constituents holds contact information. First Name, Last Name, Email, Phone, etc. Constituent Type holds the taxonomy (so it has a hierarchy) to organize the Constituent data a. Individual a. Organizations b. Foundation b. Business c. Healthcare c. Retail c. Personal Activities-Interests b. Government c. Local c. Regional c. Federal b. Nonprofit b. Religious-Educational b. Club-Membership-Association I have three fields in Constituent to link to the Constituent Type Constituent Type Links to Constituent Types with a Limit record selection to a view only a. Works great because there are only 2 options. Constituent Organization Type Links to Constituent Types with a Limit record selection to a view only b. Works great because currently, only Organizations have multi-levels. Constituent Organization Area. This is where I want to link to “Constituent Types” based on the “Constituent Organization Type” selected in the “Constituents” table. Crea

I am a lifetime Excel user, so forgive me thinking like a spreadsheet and not a database, but…here is my problem: I manage an Oyster farm. I have a table that logs the oysters that are harvested. I have another table for the demand for the oysters. I want to net the two against each other and see whether I have enough. As my table of Harvested oysters is set up so each day the team either enters the number of oysters they harvested (a positive number) or the number of oysters they delivered (a negative number). Thus, choosing “sum” at the top/bottom of each column will show me exactly how many oysters I have (summing all the postive/negative numbers to date). And as my table of Demand for oysters shows the number of oysters requested by each client on each date, I can group those by day/week/month, and look again to the “sum” of the column to see how many oysters are needed. But I can’t see how I create the Sum of all the oysters I have (the sum of Harvested Oysters table) less the su

I’m trying to keep my team’s resources all in the same place, including some very simple fill-in-the-blank text boilerplates. The text contains and tags for styling already because one of the platforms it will end up in, for some reason, interprets strings of more than one line-break character as something it needs to preserve, so it automatically adds a   to “preserve my intent”. I’ve noticed that I can copy text into an airtable long-text field (with or without Markdown turned on) that’s formatted like this: Some random text More random text And some more but when I copy it back out to plain text it looks like the invisible \r\n at the end of the line has been turned into \r\n\r\n like this Some random text More random text And some more Is there a setting to fix this, or will I need to remove the extra line breaks from everything that comes out of an airtable interface? (I already have the expression for it (\r\n){2,}, I just don’t look forward to teaching people who bare

Hi there, I’m a pretty novice developer so would appreciate any help here… I am making API calls using AJAX and get URLs. I use this helpful tool a lot to help me write the URLs: https://codepen.io/airtable/full/rLKkYB?baseId=appSzxZJK94yvza3a&tableId=tblYFuqRveHg52vvb My question is can I do two FIND formulas in one URL? I’m getting a 422 error in console, just trying to narrow down the problem here. Example URL: https://api.airtable.com/v0/appID/base?filterByFormula=(FIND(“player”,{players}))&filterByFormula=(FIND(“match”,{matches}))&fields… What I’m trying to do / the problem: In one base there are various amounts of players that have played various amounts of matches. Each record is a one match for a player. I am trying to dynamically return 1 specific record / match for a player. I need to tell the API which player and which match and after that there can only be one record - I just don’t know how to tell the API that… Cheers, Thomas.

We use our AirTable for content management for our blog. I’m looking to randomly assign a collaborator when an article updates in a “For Review” view. Any thoughts on how I might be able to do this?

Hi All The link from within Startups.com for the Airtable Redemption Benefit is not working airtable.com/startups.com. Hoping to redeem the offer and apologies if this is not the best community forum to ask. It seemed like the closest compared to the others. Appreciate in advance any assistance! Cheers Matt

New user here, I made a mistake in my view, not my grid is all out of whack and I can’t get the rows to the order they were in before — help!

Hi All, I am attempting to embed the scripting block into stacker, but am not having any luck. the block keeps showing up as greyed out. (Image below) Any idea on how to fix this? P.S. i’m not having this issue with any of Airtable’s built-in blocks. Not sure this is an Airtable limitation because they do give you the option to embed the scripting block. Thanks

Hello everyone. I have built a robust task management system in airtable. I run my own business and i wanted to track the time it takes me at various tasks so that when I am ready to hire out/hire intern etc I have an idea of what i’m spending the most time on. I have started using the time tracker block to accomplish this, but i’d love to be able to add BUTTON right next to the task in order to accomplish this. I don’t have scripting experience but I was curious if this was possible? The fact that I cant just be working down my task list and say “start time tracker” drives me crazy and I was hoping to just integrate. Thanks!

Hi, we have been using AT for the last couple of month and it is going very well on most of our projects but I’m stuck on the following. I would like to have a view where we can show all records with the same date. We produce a daily publication and it would be helpful to have a view where our sale people can add an advert booking for a specific date and page. It would also be good to have the same thing but for editorial notes. I wanted to upload a screen shot to help describe the problem but can’t as I’m a new user.

Hi, I’m looking for a solution to add the working hours to a record. Should work like the comment field where anybody could just log his hours which he has worked for this record. I know I could do this with another table and crate a record for every work-log. But it would be much easier for the team if they could log work like they can make comments to a record.

I am trying to figure out if there is a way to have a table automatically update, as I create new entries on my main table. Specifically, I have a table where I add new vfx shot names and info and I want the status table to automatically add these new vfx shot names as they are added to the first table. Is there a way to accomplish this? Manually adding hundreds of new entries on one table is fine, but to add them to all the other tables would be inefficient.

Hello, is there a way to automatically send an email with the content of a row to someone when tagged? I.E when delegating them a task tag them in it and this sends an email with all the info in it

Im looking for advice. When a user submits a form is there a way to distribute a custom email response? I am wanting to send the user an answer from the data logged using a search block. Is this possible? eg. What animal are you looking for cat, dog? user inputs dog and submits form. Email response is a list of available dogs

I am trying to use the new Airtable Automation to update record. I have a form that captures updated information whil I am auditing a computer. This information is stored in a table called Encryption Audits. I want to use airtable’s built in automation to update a separate table with any information that has changed. Encryption Log is the name of this table. When I try and set it up to update, I get “received invalid input.” I am attemptimg to take the fields from the encryption audit table and update my encryption log table with this information. Even tried just having it update the record with text I typed in manually. All attempts end with invalid input. Any help would be much appreciated.

I have added a map block and have that map displaying location pins from the table, but I have 2 questions: How can I em bed that map in a website Customize what pops up when someone clicks on the map (to include a link with anchor text) and not the “expand” option Thanks for any helep you can provide!

I’m used to using an enterprise account, but now I’m on a PRO account and I’m looking to randomly assign a collaborator to a record. I’ve got an idea of how to do this already, but I don’t know how to pull a user id in a non-enterprise account.

Noob Zapier user here. I am using Zapier to create an Event in Airtable when a new Calendly appointment is made. I use Pacific time for my time zone in Calendly but all collaborators use GMT time in Airtable. When the zap runs. It is putting in the wrong time (as expected). I am a new Zapier user so I don’t know how or where to enter the adjustment so the correct time appears.in AirTable.

Hey guys, Thanks for the help to start with- If I use a form, is there anyway to have that info automatically feed in to my AirTable- I.E. I have an AirTable that requires alot of info for the different blocks. I was thinking it might be easier for my VA’s to simply fill out a form- Then that form feed the answers in to the correct AirTable. Is there an easy way to do that?

Hi, Here is my problem : In my “people” table, I want to display a count of “meeting” records created by each collaborator. In my “meeting” table, I created a “created by” column that automatically sets itself to the creator of each new record. It is important that this information cannot be manually overwritten, this is why I chose “collaborator” field type instead of directly linking it to my “people” table since links can be changed by every user. Now I need to link both tables so I can create a “count” column in my “people” table to count the number of meetings created by each collaborator. In a nutshell, I need the link between those two tables to be automatically set through the creator of each record in the “meetings” table. The problem is that there is no way to set a “Collaborator” type in the Primary Field of my “people” table. Do you have any suggestion that could work around it ? Hope I am clear enough

I have started to build a pedigree database for my cats. I want to se result in health so for me it’s importent to follow my breeder lines. I have some questions regarding Blocks and though Org Chart is it possible to have more relationships types than one? As it is now I can se the mothers lines and the father lines but not at the same time. Is it also possible to embedd blocks into en website or share just the view from the block? Hope someone could help med!