Other Questions

I’m locking make a public database. Is there a way to lock a row’s data once it is entered? But not have the entire field be locked. The idea is that it would be a database of contacts where each contact will enter their own information and be able to see everyone else’s (but we want to lock all previous fields except the one you are entering)

Sorry for the newbie question, if I have the same four tasks repeated daily and I need the totals for those noting respectively, do I need four separate tables to monitor date and total or is there a way to have all four tasks on one table? The end goal is be able to monitor task totals over week/month.

I’m trying to use Dropbox as intermediary file system to get PDF attachments from Gmail into Airtable, using Integromat. Have had a long struggle trying to use GDrive as the intermediary system, which unfortunately does not work reliably. With Dropbox as stepping-stone, it seems I can reliably get a file into Airtable (hurray!) but the file lands as application/binary rather than application/pdf which causes other problems for me - Airtable does not generate thumbnail image, and some of my downstream automations do not work because they think the filetype is wrong. All these files have .pdf in file name, and Dropbox does correctly recognise these files as PDF in its native interface. How can I make Airtable know that these file attachments are PDFs?

Hi Airtable Community, Could someone please help me out, I have two columns, one that is Start time and one is Stop Time, they both have dates and times. I use a formula to get me the total hours between the dates and times. The only issue is, some projects that have start end time of 1/12/2020 10:10 till 2/12/2020 15:30 will give me total hours but I only need it to calculate during working hours which is 7 Hours and not give me a total of hours which include when the employee is not working. Is there any formula that can take in account to only calculate total hours during work hours? I am using this formula for total hours between the two dates. IF({Stop Time},DATETIME_DIFF({Stop Time},{Start Time},"")/3600) Thank you all for any help that can be provided.

I am trying to perform a vlookup type functionality from excel in airtable. Here is what I am trying to do: My setup I have a table called buildings and table called tasks. My tasks are associated to buildings My tasks have a step type, either “Step” or “Milestone” My tasks have a process step like “Data”, each process step has one “Milestone” My tasks have a completion date What I am trying to do On my buildings table, I would like to: Find the “Completion Date” for a given “Milestone” for a given “Process Step” for a given building While not exactly a one-to-one implementation, in excel I would use a vlookup or a match + offset function to accomplish this. Is something like this possible in Air Table?

Is there a quick way to go from a record in the a sync’d view back to the originating view?

I want to store my personal financial info in an airtable base. Including links to accounts, usernames and passwords. Will that info be secure?

I’ve installed the AT app in Slack. It works, but it doesn’t show as an app in Slack and I don’t know how to add a user. ty

Hello! I am wondering if the following is possible: Looking to have a form uses can fill out with different variables. (IE - income, number of children, zip code, etc) I am then wanting to give them (could be via email using Zapier) a coupon code that is predetermined for a certain percentage off. What I am thinking is, there will be different views for each coupon amount, and another table with all the coupons for that amount listed. Ideally, someone would fill out the form, Airtable would then (using Zapier, I assume) assign them a code from the correct table, send the user an email with code, then mark the code as used in the table. Any help is appreciated, thank you!

I am wanting to submit a form and redirect the user to some digested results. Is this possible? There is an example here: https://support.airtable.com/hc/en-us/articles/206058268-Guide-to-forms#redirect but I cannot figure out how to configure this for redirect for the script-digested information post submit. Best, Rose

Hello all, I am wondering if there are tools in AT to compare text inserted in two different cells? Thanks for your time. Caroline

Hi, new to airtable. So I have three tables, A. Subjects, B. Teachers, C. Activities. In table A there’s ‘taught by’ column linked to the teachers’ name from table B (there might be more than one teachers per subject) and ‘length’ column of the lesson taught (in minutes per week simple number e.g. 15, 60, 75 etc.). In table C is form submitted by teachers. Linked to the Subject records and contains things like “playing blocks”, “drawing family”, “playing games with family” I’m trying to Show all subjects taught by a teacher in the B table Count the total subjects taught by a teacher in the B table Count the total hours per week a teacher is teaching in the B table Show the count of unique terms/words from table C from the example to get ‘playing: 2’, ‘family: 2’, ‘drawing: 1’ etc. or a word cloud I tried roll up but it always shows 0 and I can’t find the search term of what I’m trying to do.

Org chart: drag and drop - Show and tell / Product Suggestions - Airtable Community Forum: Org chart: drag and drop like above post and add this function copy whole tree in org chart view

I added a timer app to a table. Is there a way to attach it to a button in a grid view record to directly start the timer, instead of opening the app area, running the app and selecting the record? Thanks.

Hello, with our team we use a custom app. Everything is ok with the app itself the only problem is that the app window vertical size keeps growing waaaay under the screen so we have to manually make it smaller almost every time we want to use it. At first I thought someone from our team with a large monitor keeps making it bigger but it is so enormous that I think it must be some bug although I haven’t found anyone else (apart from our team) to have this problem. Do you have any idea what could be the cause? Either way I consider it a design fault that the app size is shared across the whole team where everyone has different monitor size so that no one can set the app size the way he likes (and keep it that way). Is there any way to change this behavior (or a chance it will be changed by Airtable designers)? Thank you

Hi - I’m trying to help a non-profit organization that accepts membership applications via an AirTable form. As the organization is for military spouses, members routinely need to update information submitted with their membership application. Is there a way a person can update their record with such changes? As it is now, the member updates the form and a new ‘contact’ is populated rather than having the existing information updated. Thanks!

Hello, I need advice. In the United States, an invoice is very different from what the government of the Czech Republic asks for. For our invoice we need VAT identification no. to be included. Also our workplace is named by our department not by our company name, so the invoice and receipt contains wrong name and it’s not useful pour bookkeeping. How can I get an invoice from Airtable with the requirements of the Czech Republic. Invoices issued by Airtable do not meet these requirements. To whom I should turn to if it is not adjustable on the airtable settings? Thank you for your help, Barbora

I have x amount of users which needs to categorize X amount of websites URL’s previews. There is around 300 categories which is predefined and needs to be shown in a searchable or treellike structure. The urls is something i define. It’s important that the website URL is shown in some visual way, the best would be if the user can preview the whole website URL in an easy way so that they can read the content. Can i do this using Airtable?

I set up IFTTT algorithm so that daily summary from RescueTime should be saved to AirTable. It records my daily total time, productive time, and distracting time as a separate column (‘duration’ field with ‘h:mm’ format in airtable) and one row per day. My yesterday’s total time, productive time, and distracting time were 8 h 6 m, 3 h 4 m, and 2 h 44 m, but the AirTable record for yesterday is weird. They are respectively recorded as 1:26 (1h 26m = 86m which may be mis-understood from 8h 6m), 0:34 ( 34 m. mistaken from 3h 4m), 4:04 (4 h 4m = 244m mistaken from 2h 44m) How can I correct this? (RescueTime also sends daily summary to Telegram and MS OneNote and they show the duration correctly. So I believe it is not a problem caused by RescueTime or IFTTT.)

Is there a “save to (google) calendar” button on the Calendar view? Thanks

Hi All, How can I connect Airtable with HTML/Js Website? Thanks.

Hi Airtable Fam, How can I ensure that fields from different bases stay in sync? For example: Field C of Table 3@Base1 should be identical (i.e. sending data to) to Field B of Table7@Base2. Values shouldn’t be changing order after they sync otherwise Base2 will be a mess. Thank you

Hi Airtable Fam, I have a base with two tables: Table 1 and Table 2 I want Field C of Table 1 to become the primary key of Table 2 after removing duplicates and while ensuring that Tables stay in sync (i.e. it should become, after eliminating duplicates, Field A of Table 2). How could I accomplish that? Apologies if this is a basic question but I couldn’t find an answer for it in the forums. Best

I’m trying to make my “group by week” formatting easier to understand by showing the date range for the week rather than the week number but can’t seem to get the formula that works in Excel to work in Airtable-- has anyone figured this out? Thank you!

Is there a way to automatically import sales data? We use Square, Zapier and WooCommerce and could potentially add another platform if needed (Hubspot, Mailchimp, etc.), but we want to track all sales (and line items) and inventory automatically in airtable. Thank you in advance for any assistance you can provide! Cheers, Carrie