Other Questions

Hi! I’m trying to use automation to input a duration in a duration field from a text field but it doesn’t seem to work (i.e. after automation, 08:00 in text field appears as 0:08 in duration field). Is there anyway to make this work?

Hi there team, I am trying to sync 20+ tables from base A to a single table in base B. Does anyone have recommendations on how this can be done without an Enterprise plan? It would ultimately result in the table in base B to have all the records from the 20+ tables in base A combined under one table (like a master table of all the records). It is important that the records within the table in base B automatically match any changes made to any record found in the 20+ tables in base A. The reason we want to do this is to be able to create a Airtable form in which the user can select a record from the complete list of records found in the 20+ tables in Base A. We would really appreciate any help and feedback! Thanks in advance :slightly_smiling_face: Thanks Jonathan

So it seems my airtable account is two different emails. I have two different emails but they all go to the same inbox if that makes sense so I’m seeing if there is a way to merge these accounts as I don’t want to restart with my other emails. Plus I have credits on the other one and a pro plan. Any help is much appreciated

I have a simple table called “Imported table” where Field 1 is merchant category and Field 2, 3, 4…10 are merchant names. I am looking for a JS function with merchant name as parameter and if present in the database, can return the corresponding Field 1 name. One option that I’ve been trying is filterbyFormula as REGEX_Match and loop from field 1 to 10, but can’t seem to figure how to complete the function. Appreciate any inputs on this or better ways to do this.

Hi! I am really stumped and hoping someone can help. I am trying to add a lookup field that filters in my budget from another table. Here is my first table, you can see I have the linked record (idk why it’s empty) and the lookup field for budget, but it is empty. Here is the other table I am trying to filter in from, as you can see there is budget in every column (sorry for the narrow screenshot, private info cropped out) Am I misunderstanding lookup fields? Any insight is appreciated!

Hello i want to embed my tabil data now how can i show email as exam***@gmail.com! ??

Dear ones, I need help. I’m using a filter on another system that searches the result based on a certain date. If I inform the filter as follows. Date = “2021-06-25”, The expectation is that I would return all the rows that appear on this date, however filtering this way I have no return. If I use the Date filter >=“2021-06-25”. it works, but it brings me back not only the lines corresponding to that date but all the other dates ahead. What is the right way to filter an exact date in the airtable?

I have URLs to articles/newsletters that I store on Airtable. I want to extract an image and text snippet from that article to display as preview (Like you see when sharing an article on twitter/slack/whatsapp etc). Is there a way to do that on airtable?

I would like to generate a new Multiple Select field that contains values found in a series of Checkbox fields. Currently the Subject of each row is marked as a Checkbox. There can be one or more Subject values for each row. Can you help me write a formula that tests a series of Checkbox fields and generates values in a Multiple Select field that match the Name of the Checkbox fields? I have several groups of Checkbox values I would like to apply this formula to, in order to create a more compact Gallery display. Thanks for any help you can offer an Airtable Newbie

Hi, I currently have my IT-inventory in Airtable. I would like to upgrade this with a kind of lending/borrow system. Where the employee’s can scan a QR code and take the (monitor, keyboard, mouse, etc…) device and I know who took it. And when they afterwards return the device and scan again, it shows in Airtable that it’s returned. Is this possible in Airtable or is there something that already exists?

I can’t seem to get email notifications to work in Airtable. I have a collaborator field, with the option clicked on that says “Notify collaborators when they’re added.” I’ve also checked my notification settings and email notifications are enabled. This is not working for my account or any of my co-worker’s accounts. Any thoughts? Thanks!

I’m working on a base that makes some currency calculations and I’ve noticed that when you have an amount that ends in a 0, e.g. £10.50, the zero at the end won’t show up in markdown that I’m using in automations. It will show as £10.5 instead. For any other amount that doesn’t end in a zero, you will get the two decimal places. The same happens whether it’s a formula field, a number field or a currency field. I could probably correct this with something like IF(RIGHT, 2=".", {Number} & “0”), i.e. add a zero when the second from right character is a decimal point, but that seems like an ugly way of doing things. Any advice?

I want to import a JSON dataset. I know I can’t import JSON, but I know I can convert the JSON first to CSV, which is importable. The problem with that is my dataset contains arrays inside the JSON object, eg.: "variations": [ 227, 329, 229, 190, 119, 123, 152, 155 ] In a JSON-to-CSV convertor, this comes out as multiple columns, variations/1, variations/2, variations/3 etc That is not appropriate since, in Airtable, I want the “variations” field to be a Multi-select. How can I accomplish this?

I want to allow members of the team to create custom views via a lookup form (without going into the base). For example, see all records that match a given criteria (type: flower, color:red). Is there a way to do this without pre-creating a view? example: on a form, user enters type:flower, color:red. It returns a view/table with: record1 - rose record2 - tulip miniextensions has a search page that does what I am looking for, I assume this is a form on their site that then uses the API to retrieve info from the base, correct?

Hi, all I need to define the formula for calculation employees` vacation days in total, not within one leave year. How it can be done? Is there a possibility to do the calculation without leave years at all?

I see a form view to collect data from users. I see a few form-oriented addons, but they are for printing forms. Is there a way to create a form-oriented view of a table where users can update the table and add rows?

Hello! I have a long text field with information captured as rich text: Achievement 1 Achievement 2 Achievement 3 I need these Achievements converted to a comma separated text field. How do I get the above, converted to the below?: Achievement 1, Achievement 2, Achievement 3 Appreciate any guidance!!!

Hello, I am trying to create a database using the barcode field. However, the barcodes that I have generated (type code 128) are not read by my phone camera, whereas a barcode scanner on my phone can read them perfectly. Can you please advise on how solve the issue? Thanks a lot, Marziye.

I’m reminding my team of tasks weekly, using a digest. Some weeks there are 0 tasks (although rare). If this happens, the run is considered a failure, and I’m sent a report about it. If there are no records to be found , I don’t want a digest to be sent. So in reality I don’t consider it a failure. Is there any way to adapt the automation to this? Or do I need to await a potential if/then feature?

I want to build a custom CRM for my inside sale team and other teams. I have a Master base that has all the leads data also that’s where we want to assign who will take care of these leads. After we assign a lead, our Sale Agent will see new lead appear inside of their own Sub-CRM. We could do that with Filter and Importrange in Google Sheet. Could we do the same here in Air Table?

Hello ! I’m :fr: and totally new there and with this extraordinary tool. I wanna use airtable for a social media calendar. A database where I can write FB, IG and LK posts, plan on a calendar and reports the results. I have 2 tables : 1) “contenu/posts” where I write the post, update status and decide which day we will post it 2)“évènements” (events in french) where I add differents events as christmas, mother day, mondial days… I would love to see the events that I added in the table “evenements” in the calendar view of the table “contenu/posts” like that Do you know a way to do that simply ? thanks in advance for your help :grinning_face_with_big_eyes: I tried to combine both but this makes a huge data base with a lot of fields (some for the events and others for posts and a lot of blank cells).

Just wanna ask if this is possible… i’ve spent way too much time looking for a solution to what I want to happen already. So I have a column in table B called “version”… I want the color for each cell to change according to the cell value from table A that has all the latest product’s latest versions. Green if the version from both tables match, and red if they don’t match. That’s basically it. I can’t find a way to reference a record in the conditional coloring box.

Hi! Is there a metod to copy or move a record frome BASE 1 to BASE 2? Not between two table of the same base but between two differents table. Thanks

Hi Everyone, I have an automation that is triggered from a schedule, finds records in a view and then needs to email address using one of the values found in the view. The problem is that the email address in the view may appear many times (Multiple rows) so that using that field in the automation will mean the TO: filed looks like this: user1@test.com, user2@test.com, user1@test.com, user2@test.com This means they get the email multiple times. How can I get the unique values from the rows and use that for the sending on emails? Cheers

Im making a airtable system, for a friend of mine. It deals with quite sensitive data… Is there a way to make sure an editor can’t just duplicate a whole his base including all records into their own workspace, but still be able to edit records?