Other Questions

Hey guys, I need some help and can’t find de answer for this! I have some projects and tasks, but each one have a kind of “weight” in certain steps, like: When a task is in To Do, it have a weight of 5% When a task is in Doing, it have a weight of 40% When a task is in Validation, it have a weight of 5% When a task is in Done, it have a weight of 50% When I sum all of them, the result is 100% I don’t know if it’s clear. I just want to do something like this /

Hi, I am an old school database developer and have recently discovered Airtable. I am intrigued and have signed up for the free account to try to discover what it’s about and how it all fits together. However, I am gobsmacked that there appears to be no downloads available to study Airtable. I am unable to learn from a screen. Whenever I teach myself new skills I do it by pouring over reference manuals and experimenting - that’s the way I learn. I simply cannot concentrate when some is spouting information at me in a webinar or a training video, clicking on various things instructing you to do this and that with out learning the REASON and UNDERLYING logic behind what you are doing. I also cannot read from the guides displayed onscreen, mainly because you have to keep swapping form the guide to your workspace trying to copy the examples. What I need is a printed manual I can learn from. I am not asking Airtable to provide printed manuals, just PDFs that I can download and print m

Hi there! I’m having an issue where I can’t add certain multi-select options to a form view that are referenced in another linked table. For example, in one table called “Groups”, there’s a series of options like A,B,C that a group organizer can set. In another table called “Participants”, (linked to Groups), I want the ability to reference those options to be selectable in a form to be filled out by the participants. However, any referenced or linked field does NOT appear as an available field to use in my Participants Table form, even though I can see them in grid view. I’ve tried every formula I can think of. What am I missing, or is there a workaround where I can duplicate data in a referenced column so it becomes “native” to that table and I can put it in a form? Thanks!

Hello, I am tryig to setup automatic CSV import of our product catalog to Airtable. Every morning it should update in case there are changes in prices or stuff. I was able to setup the Make.com (Integromat) scenario to: Get the CSV from FTP Parse the CSV And I can even create new records in airtable sucesfully BUT We use our codes for every product (and it is unique). I amy trying to setup that it will “Create new” record if it doesnt exist and “Update” if it does. I am trying to use “Upsert a Record” in Make.com scenario. But that only let me to pair it with Airtable “Record ID”… which the CSV of course can’t have. Does anyone figured out how to pair the records by OUR id? (which is IN the CSV and also Airtable first column) Thanks! Matt

Hi everyone. Let’s pretend that i have a table with some entries and an external person knows the name of a specific entry that he wants to update (maybe just one field). The table might be populated with colums with name/surname/mail address/phone number, and the external user is able to add an entry by a dedicated Form. Is there a way for an external user (which knows his email) to use this field to update somehow it’s phone number? A possible solution, for instance, is to have a form in which an external user input his mail and a phone number, and if his mail is recorded, the form updates the phone number. Maybe can be a form for another table, and an automation that checks at every new entry if something has to be changed. Is this doable? Thank you in advance.

Hello, I am looking to extract the individual dimensions of an object from a cell that contains them as a LXWXH string. for example, I have a cell that looks like 11’9" X 4’11" X 8’0", and would need those in three different cells as 11’9" | 4’11" | 8’0". Trying to find a formula that would do this for me. Thanks!

I’ve built a Project tracking space in Airtable and I would like it to automatically import my emails pertaining to that project into the project record. Is there a way to do that? Ultimately, I’d like to open the project record and see everything that’s involved with that project, emails, PO’s, Art Files and Client conversations. Right now the Airtable world is totally separate from the email world unless I take the time to copy an email and add it to the Chat of the project record.

Hi all, First time poster.! I am looking to import a file each day that we receive via e-mail. Using Zapier I can save the attachment to G Drive but can’t figure out how to get this data into a base as it hits the folder. I have tried using New file in G folder but you can’t see inside the file so you can’t map the data fields. I’ve converted the file to a Google Sheet to see if it was a CVS thing but same issue. Any help would be gratefully accepted.

Hi, I’ve built a website that pulls data from Airtable and displays them as custom posts in Wordpress. If a row is deleted from Airtable, it is deleted from Wordpress. If row-data is changed in Airtable, it is updated in Wordpress. All row data is stored in a custom field and can be displayed on the site using a bit of custom php. I know AirPress has been working on the same thing, although it didn’t quite fit my needs. If you want to have a look, go to individual books or authors here (http://700d196048ef63665a08376aa5dd9bebacc382bc.web26.temporaryurl.org/historier/) - it is, unfortunately for many, in Danish. If anyone knows how to make a php-lookup of a key/value-pair in a custom field, feel free to let me know! Regards

Hello Airtable community :slightly_smiling_face: First of all, apologize if I missed something, I’ve tried to find a way -as usual- before posting here. This seems so obvious that I can hardly believe it’s not possible … or I am totally wrong about how to use Airtable ! A few months ago, when discovering AirTable, I separated things on multiple bases within our workspace. Now that I have a better understanding of our needs, I would like to gather various bases, adding new tabs … but from what I see, using “+Add or import” only allows to create an empty table or to sync data from another table. I can’t import an existing “tab” from another base. Sure I could simply copy/paste records, but doing this, I’d lose the views I set up for the tables I’d like to import. I’d need to do this all the more that I’ve recently discovered Image MarkUp extension, that we badly need, and it seems the only way to get what we want, is to get our various bases in multiple tabs. Thanks in advance for you

I keep attendance with airtable. I would like my clients to be able to request a copy of their attendance and see it automatically. Ideally they would go to a website link “please show me my attendance” and it would show them their attendance for a range of dates. Is this possible? If so, how? Thank you.

I’m working on a fun, friends and family base for recording daily quiz results (Wordle etc.). The idea is that people can use an iOS shortcut to parse their score and past it to an Airtable base using the API. The eventual goal is to build a friends and family league for these types of games and maybe use interfaces to display the league. I’ve got the shortcut working for the most part in so much as I have game name, the game #, date and number of attempts to successfully get the answer working. However I thought it would be nice to bring through the visual representation of the attempts - this is the bit normally displayed using emoji. For example… :brown_square: :brown_square: :orange_square: :orange_square: :yellow_square: :yellow_square: :green_square: :star2: :arrow_up_small: :arrow_up_small: :arrow_up_small: :arrow_up_small: :arrow_up_small: :arrow_up_small: :hammer: :star2: I was simply going to add these lines as a multi line text field in the base but I am st

Hello. My question here is if it is possible to give access to a Record just to a few people (non-collaborators) by a shared link, and if those people can edit the same record. I don’t want those people to have access to the full database, just to a specific record within a table. Many thanks.

Greetings wise ones! I have a base to track family medical history which includes a Doctors table and a Dr Appointment table. All appointments in the Dr Appointment table are linked to a doctor in the Doctors table. This includes past appointments and upcoming scheduled ones. In the Doctors table I would like one field where the date of the next appointment is calculated and shown and one where the most recent appointment is calculated and shown. How do I write a formula/rollup that looks at only the past or only the future dates and chooses the last of the past or next of the future? I’ve created fields calculating the appointment dates from TODAY if that helps. Thank you!

Hi, I am new and am attempting to show Gantt colored by ‘Category’. However, no matter what the only category I can use to color right now is ‘Status’. Thank you in advance for your help.

Hello all! I added the pivot table extension to my base hoping I would be able to somehow extract the data I have it calculating (Avg. Weeks of Completion based on project category). Has anyone attempted this or found a way to do this? I am on the cusp of being able to use our already amazing workflow to project lead times of projects coming through based on recently completed projects. Any help would be appreciated! Thanks!

I had an Interface that load data from client table for fill additional fields. This Interface has a record picker linked by phone field, several editable and non-editable fields. I want the Interface be able to add new client (add new record). I setup the record picker for allows new records by a form. But I can’t update record picker on Interface automatically with new record data without seaching it manually. I want that new record created by form launch from record picker updates it automatically. I ask for help me in this question.

I am using the free version with what I thought were just the basics. I am getting a notification that I have too many extensions and that they are disappearing on July 27. I can’t get a hold of anyone from Airtable. I really don’t know what extensions I am using and although I consider myself fairly tech savvy, their information on extensions is confusing.

When I’m printing view in calendar view, the words are truncated. Is there a way around this?

For example, I can’t tell the difference between the two when I use it. When can I use the timeline view or gantt view?

I have a Bikes table containing a form that collects bike details, either for bikes donated to a charity, or bikes that are repaired on behalf of customers by the charity. The view is linked to a Customer table. On my form, the first field is a ‘Bike Type’ Single Select dropdown asking ‘Donation’ or ‘Repair’. My Customer table contains a Multi Select field allowing me to specify whether the customer is a Donor, Service Customer, or both. In this Customer table, I have created two view one that filters all ‘Donors’ and one that filters all ‘Service Customers’. When I make a selection in the form field for the ‘Bike Type’ (point 2 above) for, say ‘Donation’, I’d like to show a field containing all the customers who are Donors from the Customer table. I have done this successfully. Happy days. However, at this point I now need to add a second field for when ‘Repair’ is selected in step 2 above to then show all the ‘Service Customers’ from that View. This is not possible as it ju

Hello! Have seen a few recommended solutions but as a total novice ( I haven’t even used Excel formulas🙈) I can’t seem to follow them. My boss uses airtable, and has made one for me in her account. It feels simple . I need to keep track of the number of hours I work each day. Hours vary, but as an example: Column 1 - clock in 9 am Column 2 - clock out 5.15pm Column 3 - number of hours worked Please can someone help ? Many thanks Vic

Hey there, i’m working on my own simple CRM to get familiar with the platform, on the free version, and i’m stuck on a problem. Here’s a video overview: confusion on using hidden fields to match record id with another airtable column? and some more info: I have a list of deals in the crm, when you click on one of these deals it takes you to the invidiual deal view The recordid is automatically passed onto the url I want to add a hidden field that captures this recordid and matches it up to the name of the deal in my airtable database On each individual deal page their is a form with an option to update the stage of the deal (from proposal, to negotiation, to close won, etc) I don’t want the user to have to manually enter in the name of the deal in the form, I believe that softr + airtable should be able to do this My challenge is that I can’t seem to lookup and match the name of the deal based on the recordid in the url in tandem with the hidden fields function. I’ve been a

Hello, I use the timeline view on this table to manage my rentals : in the column “Grouped By” I have all my chambers, and each record is a reservation. The chamber are Cottage 1, Cottage 2… until Cottage 20) But, when sorted A-Z, it do not includes the numbers : Instead of : Cottage 1, Cottage 2, Cottage 3, etc… I have : Cottage 1, Cottage 2, Cottage 11… What can i do to sort the column “Grouped by” from A-Z and 1-9 ? Thanks.

Hi everyone, maybe its not a new question, but apparently i couldnt manage to find the answer :slightly_smiling_face: I m trying to et a Single Select field by ticking a Checkbox field in the same table, so in my understanding it has to be something like: IF Checkbox ticked THEN set Single select field to Value I am trying to automate following function: IF my client is ticking the checkbox for approval - the task should automatically set the Single select field to ARCHIVED. Anyone a idea. THANKS in advance. -M