Other Questions

Hello All, I have a base set up to track progress on tasks. I have feilds that I manually enter a % complete. I’d like to display on a dashboard the current %complete of the task but also show last weeks %complete and 2weeks ago %complete so that all dashboard viewers can see the progress…??? hope this makes sense. lmk if there is a better way of thinking through this problem. thanks,

:wave: Hey there! Im trying to learn more about Airtable best practice in terms of overall schema/base design and structure. My question is: How can I more quickly add data to tables and cut out some manual work? Here’s the specific context. I currently have a document with three tables Students (Database table, one record per student) Classes (Database table, one record per class) Enrollments (Junction table, handling the many-many relationships between students and classes) Currently, the junction table only has three columns (Name, Student, Class) But to add a New Enrollment, it feels very clunky and like there is a lot of manual work. You have to select both the student and the class each time. What If I need to add a lot of students to classes at once? Is there any

I’m new to the platform and need to move a record in the Contractor’s table to the Employee’s table in the same base. Can you help? Thanks in advance!

Hello! I am trying to create a way to record for my barn which volunteers cleaned which stalls on which day, that I can then view by volunteer to see what days they’ve worked, and yet another view to count how many stalls they’ve worked in a day, week, month, etc. I got created my first table and form for inputting that day’s records, and it’s working great! The first column is “DATE” and the rest of the columns are “Stall 1”, “Stall 2” etc. The cells contain the date in the first column, and then the Volunteer’s names under the Stall columns. I created a second table with volunteer names, but I’m not sure I’m linking properly. Suggestions on how to set up my data so I can create views to see by single day (original table), By volunteer’s # of days works, and also by volunteer’s # of stalls cleaned? This will help immensely for us all to track their hours so they can get the credit they deserve. Thank you so much!!

I have a “deadline date” and and we have either a 3 months or 6 months, our two different project time lines we use. So when I set the field to 3 months it will take the project start date, add 3 months and the if the project goes over 90 days, to pop up into my past due view. I want when the deadline date has been exceeded based upon the current actual date for it to jump over to my past due view. For example, I had a project start on Dec.24th and because today is March 24th, if the project is not completed today, tomorrow that project would show up on my past due view report. Thank you in advance!

We are currently testing the Airtable solution to upgrade our project management. We are mainly involved in the manufacturing of wood frame houses. For the moment, it seems that Airtable can be suitable to evolve our current Trello. On the other hand, the “user” visualization options are quite limited. Indeed, before, we had checklists easily usable by the workers. Also, we could easily access the checklists through an application. The Airtable android application does not allow a very fluid visualization of the data and a use in the form of checklist. Do you have a proposal to change this? I’m testing Softr but I’m not sure it’s the right way. Thanks for your attention!

I have found this project:GitHub - drewwestphal/airtable_shipping I want to run it to see how it works. It is possible to run this project given I did not create it? If so, how? Thanks in advance!

I wanted to compare my budget and my expenses through a bar graph, and it’s distributed category wise so categories are on x axis and values on y axis and I want a comparative Bar graph. Can someone help me regarding this.

Hello, does anyone have a script that can be used to copy one fields data into another? I need to be able to input a search query using something like the updateRecordAsync() code to update one field with another’s data. The issue is, that I need it to rely on a user input, so I want to be able to choose the preset of quantity by having a await input.textAsync(). I would then define the quantity options in different fields, and the input would be that fields name. It would then copy the chosen fields data into the main field. It must also include a way to scan for a specific record to be the one to be updated. I have code written for this already, but it would need integrated into a script for it. This is what I have so far. It lets me scan my product inventory table for specific products, and copy those products all into a my invoice transaction table all under one specific record number. It gets represented by a number that looks like IN-#. This number would need to be used to sca

Hello, I am sending an email out using SendGrid. I have a filed that is a link of multiple linked records. It strings them all together with commas between, which is really exhausting to look at, i.e.: “Day 1, Day 2, Day 3, Day 4, Day 5” I would like for it to be formatted as: Day 1 Day 2 Day 3 Day 4 Day 5 Any ideas? I tried turning on HTML in the SendGrid app, and used a REGEX_REPLACE formula to replace the commas with <br>, but that didn’t work. Thanks! Tom

I have a table with student information like name, class year, email, etc. I would like to create a form to ask them what their summer job or plans are. Is there a way to create the form so that the summer job question populates to the correct student’s record? I hope that makes sense.

Hello, Kind of unconventional question :slightly_smiling_face: I don’t know where to ask. I wondering if AirTable has a footprint in Europe/France ? And If there is Job Opportunities for Tech Evangelist ? What I underestand: There is a lot of Freelance. There is many startup using Airtable as a Backend. I’m asking this because I love AirTable (and NodeRed) for years and so may be if I could “work” on these topic it could be interesting. The drawback is AirTable is very easy to use and to understand. It’s not a pain like fake SaaS like Salesforce or SAP that requires a lot of integration.

Hello, I would create some records (companies) with their sub-records (employers). And so, if I have a record Company A, I would associate then their Company A employers like a CRM. Company A Employer A1 Employer A2 Employer A2 Employer A2 How could I proceed in Airtable? Thanks in advance

Hello! Is it possible to make different tables in one tab? So that these tables do not duplicate the same information? For example, I created a tab - called it “companies”. Now I need to divide these projects into categories and make a new table for each category to make a separate list, for example: new table - technology companies new table - commodity companies new table - financial companies But it’s important that these tables are on the same tab - don’t create new tabs for new tables.

I have seen various questions like this, but no good solutions. I am parsing text from an email into airtable and using the DATETIME_PARSE() function to extract it. I have tried many formula variations, but AirTable refuses to see the parsed time as the correct time for MY timezone. This is an issue because my next step is to turn this into a google calendar event via zapier. The best solution I can see is to add the time difference, however this is very complicated with daylight savings as I am booking events inside and outside of DST while being inside and outside of DST. The only way I can see to do it is to have a formula that adds a different amount to the time based on the event date and when DST is for that year, which will require yearly maintenance but I literally cannot find a better way. Any help is appreciated.

I am trying to edit the list of options in my single select list. When I open the editing portion of the field the space where I normally see the list of options (including “add an option”) has become so small that I cannot read any of the options that are there, and the “add an option” button is not visible at all. I am working on a MacBook Pro if that makes any difference. It feels like I just need to adjust the size of the window, but I can’t see any way to do so. This has been going on for two days. Any help would be appreciated.

I am new to airtable and trying to determine if this is the proper tool to create a product configurator for our website. I was wondering if anyone has created a product configurator before with airtable and can recommend a starting point or share a template they may have? We are not going to include prices which should make this easier. I am just trying to get an understanding of where to start. Our product is electric heaters so we would select a type (air heater) then Volts, watts, termination, fittings etc. After they select all the options we would want a quote created and sent to us in order to view it and quote them a price. Any help or pointing in the correct direction would be much appreciated!

I’d like to collect a sensitive ID number from my partners that I need for govt. reporting. I’d like to do this with a form view. (It’s not feasible to train partners to use 3rd party apps for encryption etc.) Some things I’m considering to increase security: The table is in a special base with limited access. The table includes 2 fields only, a customer number + the sensitive data field (no other identifying data is held in the same table/base) Once submitted, I’ll store the data in a document offline somewhere and delete the record. Are there other security concerns, features or user experience issues that I should consider? Thanks for any help!

Hi Airtable, When I duplicate the base from the universe, the script is not copied over!

Hi, I will need to separate the data from a “lookup” column nammed “Response (from SMS Responses)” which gives me the list of poll results as numbers (between 1 and 5 or a comment) : I tried formulas like this: LEFT({Response (from SMS Responses)}, 1) Or this one: LEFT({Response (from SMS Responses)}, FIND(",", {Response (from SMS Responses)}) -1) But I always come across errors, what could I do? Thanks in advance !

Hi, I’m looking for a way to replicate one Google sheet I’m using. It’s use to populate a table base on the user input. The user must enter our PO number or the client PO number, then a query fetch the data. User can use this table to send a email. Does anyone have a suggestion ? Thanks

I have three tables. People, Companies and a junction table. The junction table shows the relationship between a person and a company. Sometimes, a person is connected to several companies. I’d like to show that relationship. For example, This is People table This is Companies table Now this is the junction table that basically lists the companies’ employees… We can see companies are related/connected through people here. For example Joey works for both Scott Co and Keychron, Michael works for both ITC LLC and Keychron. What I’d like to do is to show how “Scott co” and “Keychron” has a relation because Joey works in both.

Hello everyone, I this this a very simple question. Unfortunately I dont see this Option in my menu, as explained here. Airtable Support

We have a database in MSSQL … we would like to connect it to Airtable and retrieve the data in Airtable. MSSQL (source): Airtable (destination) What solution is the best, most stable,easy to use, affordable? We would like to refresh the data e.g. at least twice a day.

Hi community! I’m trying to learn airtable: am not a total newbie, but still struggle with formulas. I need a formula (I think) to add up billable hours. How do I tell airtable to ONLY add up hours from any given month? The contractor enters the billable time in a number field and the date on which the hours were worked in a date field.