Other Questions

Hello, Printing from Page Designer Layout is not working for me, it’s prepping but never getting to the system printing dialog box.

Hi! I was wondering how can we create a WEEKLY PAYROLL? The template available in Airtable is bi-weekly so I was wondering if it’s possible to build a weekly payroll.

I have a field where users can upload a video file. When I grab the URL to that video from the API and play it in Firefox, everything plays just fine. When I try to play it in Chrome, I get the following error: Refused to load media from 'https://url/to/my/video.mp4?’ because it violates the following Content Security Policy directive: “default-src ‘none’”. Note that ‘media-src’ was not explicitly set, so ‘default-src’ is used as a fallback. (url intentionally obfuscated)

Why is my JSON App not helping format my long-text JSON field? Notice how its all in one big long string? Why is it not formatted?

I deal with clients who regularly cross time zones and have deadlines in those different time zones. I want to show what time zone a date/time field is reporting as a reminder. They are so used to doing the offset calculations in their heads that the reminder would help. In other words, is there a non-convoluted way of finding the time zone of the device? The ‘ZZ’ of DATETIME_FORMAT will give me offset. That would be easy enough without daylight savings time. With it, I’m casting about for an easier way. Maybe using a GMT field in conjunction with a time zone specification field (a la ScottWorld’s thinking) is the way to go.

Hi Team, I am uploading a series of pictures from my iPhone to an attachment field. The files are too large so I used a tool called “Compress” on my iPhone to reduce their size. My phone confirms that the “compress” tool has worked and the files are much smaller. I then upload them from my phone to the attachment filed. When I try to email them they are way to big, again. So, I download them from the attachment field and check their size. They are almost as big as they were before the compression tool. I don’t understand why the files get uploaded at one size but somehow get larger. Please help! This process is integral to our business.

Hi, Say I have a base with 4 tables. A linked to B linked to C linked to D. If I want to visualise data in table D from table A I need to hoop trough table B and C with lookup fields to get this done? regards,

Pivot Table app could be so useful - but it is just half cocked and really needs updating by Airtable. Can’t export / share. Only way seems to be either a screen shot or export to Excel Can’t change the widths of columns. It’s exactly what I need for several tasks, but without either of the above features it’s pretty useless. I don’t think it’s even possible to create an automation to export to a CSV or anything?? Please give us an answer Airtable

hi! i have a field that is linked to another table, and that field is a date. I’m trying to sort chronologically, but from what i see, it can only be sorted alphabetically. is there a way to change the settings of the date to yyyy-mm-dd in numbers instead of mm-yyyy now so i can sort chronologically? or any way to do that? thanks!

The article The primary field – Airtable Support doesn’t explain why rich text formatting should be blocked. Is there any reason to do so? For security?

Hi! I’ve been playing for quite some time now and just can’t get a result. I want to use Airtable as an inventory management tool. In a table orders are automatically imported via the store. One row is automatically created per order. There I get the product with SKU and the associated size. My problem is that the SKU is the same for all sizes: Product A Size 11 (SKU: 123456) Product A Size 12 (SKU: 123456) In a second table I have created the products and entered the stock level. Now I want the stock level to change automatically as soon as an order is received. Maybe you can help me? Thanks

Hi everyone! We’ve been working on a tool I wanted to share with the community. After months of private beta, we’re publicly launching our Airtable x Webflow sync at Whalesync! It lets you sync your Airtable data to your Webflow CMS instantly . The problem Airtable is the best place to manage your data. Webflow is an awesome frontend website builder. The combo allows for really powerful creations, but connecting the two is hard. Trying to do this with automation tools like Integromat can be complicated and brittle… especially when it comes to things like linked records. The solution A super simple (but powerful) way to sync data from your Airtable base to your Webflow CMS. You just map the collections/fields you want to connect and Whalesync creates a real-time sync. We support the major field types out of the box including linked records and rich text fields. How we’re different :zap: we sync in real-time :keyboard: we offer 1:1 support via Slack/calls :rocket: we’re a grow

I have a script that takes a small amount of time to run. While it runs, I want to use the full width of view I am on, so I close the app slide out. That also stops my script. Is there a way to configure this from not happening? I would like the script to continue running while I get other work done.

I am making a GET request to an airtable collection (the data has the form of a list of jsons). I am trying to add a filter according to the documentation but because my data is not relational but json-like, I can’t access the fields inside the records. With an example: The simple GET output: { "results": [ { "id": "12345", "date": "2022-04-14T05:14:16.000Z", "info": { "username": "random1" }, { "id": "123456", "date": "2022-04-13T15:14:16.000Z", "info": { "username": "random2" }] } I would like to filter the date and/or usernames, doing something like: https://api.airtable.com/v0/myBase/myTable?filterByFormula={results}{date}>“2022-04-13” Thanks!

We have a form that populates information into a table - the Private Directory (only organizers can see). In this form, one of the questions is what information the person filling in the form consents to sharing in the Public Directory (everyone in the organization can see). Then in a different table - that is in a different base - we set up a directory that can be accessed by everyone in the organization and it shows records of people with only the information they consented to share. Currently, we are building the Public Directory manually: going through the Private Directory and creating records in the Public Directory and only adding the info they consented too. The only issue is now we have reached 300+ records that need to be filtered and transferred. We want to find a solution - through creating a new form or automations - that would make this process automatic. So essentially, is it possible to create a form that populates to two different tables - one where it puts all the inf

Hello… I am using a couple of single and multiple select lists but have made a few typos and decided to change some other. So I added the new options to the select list but I can’t seem to remove the old options that I no longer need? Either this isn’t supported or i just can’t see how to do it! Any help would be appreciated :slightly_smiling_face:

I added a Table2 where i want to pull data from Table1 In Table2 i added a Column called “link to Table1” and i made it “Link field type to Table1” Then i started to adding Columns in Table2 that i made “Look up type” Example: in Table1 Column1 (Name): John in Table2 Column1: Link to Table1 Column2 (Name) Look up “Name” from “Table1”: But when i fill a record on Table1, Table2 ignores all and nothing is happening, any idea?

Hello, I am building a very simple app in which people can upload a file into floter, then that file is imported into air table. However, the data I receive from Soft is a s3 bucket. Is there a way to read the file in this S3 bucket and put it into my table?

PLEASE I NEED HELP!! I want a formula that will automatically fill in a particular word in a particular field So the plan is i want to do an automation where by when there is a check box all that data goes to another table which is the re-order list, i have different table for different vendors so i find it unnecessary adding a vendors column field but the reason i added it is so when the automation takes place and the data moves to the re-order table, i will be able to identify that that product is from a particular vendor, i input the vendor name myself but i want a formula that will automatically fill in the vendor coulumn list without me inputing it manually, is it possible? Please i really need help

I’m starting a business while still in college and was wondering if anyone know if it is possible to use the Airtable Student Account for commercial purposes. Thanks!

Is there way to export data from excel (VBA) to Airtable??

Hi everybody I want to push some data into a field(array) and I don’t find any example or comment on how to do that in Airtable. For some context, I have a table with users and another table with events, every user has a unique ID, and when people fill the form to create an event, they have to enter their ID so the event is linked to the user in a lookup field that I added in the user table. I’m okay to take the ID from the event field and compare it to the ID in the user table. I’m just not able to push this same ID in the Lookup field to connect them at the end. In this case, the user Id is named Magical Number. My console.log at the end tells me I have the right value in my filterUsers variable, I have the right user that needs to b connected with the right event. How do I target the right field to push the ID into it, which is an array into an array cause I can have multiple events connected to the same user? Is there something in opposition to getCellValue like postCellValue? He

i have a communication log table, when i request something from Client and he didn’t replay the record still opened , i forced to call back to the client and open new ticket , finally i found may tickets still opened , how can i close all opened ticket related to to same client automatically

Hello, I’m using the Airtable Python wrapper found here: Airtable Python Wrapper Documentation — Airtable Python Wrapper documentation I’m trying to get all records modified after some date time. My code is: AT = Airtable(BASE_KEY, TABLE_NAME, API_KEY) filterByFormula = ‘IS_AFTER(LAST_MODIFIED_TIME(), DATETIME_PARSE(“2022-03-15T14:23:41.000Z”))’ AT_ITER = AT.get_all(formula=filterByFormula) However, this is always returning every record in the table. Also, how do I get it to return the last modified date in the fields? I have tried: AT_ITER = AT.get_all(formula=filterByFormula, fields=“lastModifiedTime”) …but this throws an error. The docs say the default is to return all fields, but there’s no modified date field when I try that, either. Any help, please? Thanks! -Dan

Hi Guys, This is probably a pretty easy one - for the right person… haha. Pls see attached. This cell started as CURRENTLY AVAILABLE. Then a linked record called ‘2022 Camry’ was added, and I now have ‘2’ records in this field. How do I automatically unlink (remove) **CURRENTLY AVAILABLE", ie, updating to only leave the record called ‘2022 Camry’. Thanks!!