Other Questions

Hi All, How do you produce a gantt chart which has the tasks from two different tables (in the same base) and shows the dependencies between them? ie you have two projects generally be tracked separately but want a gantt view of the dependencies between the projects? Thanks

I’ve made a airtable form and received quite some data already (incl email). I realised I forgot to ask the date of birth. Is there a way to send many people individual emails to request them to send it back and it auto fills the DOB field?

Hi everyone, I am new to Airtable and I have been stuck on this for a while now, basically what I need is: A Products table for thousands of products These products can be grouped into 10 main categories There are a few dozen sub-categories under each main categories What I would like to achieve is, each time when I am adding a new product record, I can select the main categories drop down menu, and after that only those sub-categories related to that main categories will show in the sub-category drop down menu I am totally lost here, please help. Thanks in advance. Anson

I use airtable as a ticketing system. Would like to be able to have users send an email that can be parsed and turned into a ticket in my airtable. Was wondering if anyone knows of an airtable app that will do this?

Hi! I want to create a report with some figures that I have in APPs. Is there any way to do it? I use Page designer for reports but there seems no way to add there the graphs I obtain from other apps. Could somebody advice? Thanks in advance

So our team is semi unique in that some collaborators only need access to certain fields to change, while others need semi admin. The semi admin is easy enough, as I can set them to editors only. But let’s say another set of collaborators, I only share one base, and only want them to be able to edit a certain field or set of fields. Is there a way to do this?

I’m just curious what other peoples workflows are here? I am using airtable just for myself right now, since its easier for to completely setup and manage the data on my end. But how would I go about collaborating when I start adding team members who can edit these airtable files? For now its just going to be 1 additional user adding data My major concerns are the following: The other user being added on here, some of their data isn’t up to my standards so its considered slightly “garbage” data in my mind. It doesn’t meet the high level standards I set out, so I need to keep a close eye on this data. This is mostly for a product database. How exactly would I go about ensuring my data is as clean as possible? Which feature would I use: Collaboration / revision history checkups? Personal table views ($24/plan)? (only give permissions to edit certain parts of the table?) Rigid referential integrity enforcements? (I don’t know how this works yet though) Could someone possibly chime in

Hello, guys. I’m looking to visualize data in my Base with a spider graph. Their is no app in the community, and I can’t seem to find a platform that I can afford, or that’s good, to do this. Does anyone have any experience, or can recommend something Help and thanks!

Hello, I’m discovering AirTable, I have a free airtable plan. I would like to connect it to my Mysql database. In my database I’ve the number of messages that my member (Adolphe) sent. Adolphe could send 0 or 100 messages every day, so the number could change every day. In AirTable, I have a raw specially for Adolphe. I’ve created a column named “Total messages sent”. How could check every 24 hours the total number of Adolphe with my Mysql in AirTable please ? Thank you

On my calendar view, it automatically applies a label to my entries. I want to remove this for my date ranges because it is applying a “Start Date” label to the first day, but when it’s a long title, this label can appear on a day that’s not actually the start date. I do not see any option to remove the label. I’ve just been putting a “-” as the label for a workaround, but I’m curious if there is a better way. Thanks!

Hi Airtable community, Currently i am working on setting up a referral program. I have attached an images to explain what i am looking for. I hope someone could help me out, as i am quite new to airtable. I have been experimenting with the FIND() formula, yet i could not figure it out. The “gebruikt download url” tells me from which url a subscriber of the Ebook has downloaded it. This can be the basis url, as is the first record. In the second column, you will find a generated referral url. This url is meant to be shared, in order to get some price. In the second record, the column “gebruikte download url” shows that the ebook has been downloaded through the generated referral link from the 1e record, as both of them contain the same =ref"" code. What i would like to do in the last column “Aantal referral” is to count how many times a certain referral url has been used. The before last column shows the referral code of the subscriber. I’d like to built a formula, which looks for that

Hi all, I sent an urgent email to Airtable support, but since their auto reply says they’re very busy and can’t guarantee a prompt response, I thought I’d try here. We have an account that’s been used for about 6 months or so and we’ve been collaborating on a base virtually every day. Suddenly this morning, while logged in to AT, there are no bases listed. When I access the bookmark to a base in the browser, we get the “You do not have access to this base” message with a Request Access button. After requesting access, I didn’t get anything sent to the account email address. I confirmed that I’m logged in to Airtable with the right account name when getting this message. I don’t see the Workspace at all, though it shows I am logged in. I don’t see anything in the inbox about a billing issue or that the account has expired. Anyone have an idea about what this might be? Is this a known issue? Thanks for any ideas!

I like airtable but seem to have difficulty in exporting data over the printer. The page designer did not provide the solution I needed as it seems to be a product to design single pages for each datapoint, not long lists of data from different tabels all on one or two pages. My alternative is copy/paste to Excel to get data out - but there must be more people with the same diffuclties out there (and searching through the Forum there were a few). So what is the suggestion to get the data that is available in long lists of items just like in the grid view to a printer?

Dear AT Community, I have just started using the Page Designer Block/App but when I click on the colour of a text in order to try and change it, no colour palette comes up. Has anyone else experienced this? Thanks in advance Ladi

Hello, I’m using WEEKDAY() to show me which day of the week (Jour (#)) an order came through. For some reason, the formula shows me this : Orders with different dates 15/04 and 14/04 shouldn’t show the same Day Number in Jour (#) which is where WEEKDAY() is applied. I know it’s related to the fact that these orders came between 00:00 and 02:00 am, tho I don’t know how to resolve this. Any idea ? Thanks

Hi there. Am wondering if it is possible to duplicate a table and then when I update the original table, the duplicated one is updated as well? I am trying to achieve a scenario where by I have a table holding all the master info for employees - including salary, contact details, etc but want to share a table just showing the contact details with the rest of the team. Thanks

Hi everyone, I was wondering if there was a way to share access (either at creator or editor level) to a base but not allow for them to duplicate it to their own account. I’ve tried everything so far and have had no luck! Thanks!

Hi, I’m not new to Airtable but I’m still very novice. I’m sure there is a way to do this but I can’t figure it out. I run a horse show association where our members earn points. They can earn awards in 3 different areas, all are captured within our Airtable bases. I figured out groups and then adding the sum to the summary row. But how do I get an output for this, into a report or html I can insert into our website? Here is an example of what I’m trying to do: Name - Class - Division - Points John - Apples - Fruit - 5 John - Oranges - Fruit - 4 John - Green Beans - Vegetables - 3 John - Asparagus - Vegetables - 2 So I need to be about to output 3 things - total points (all points added together) so for John this would be 14 points. Then I need John’s points by Division - so for John this would be Fruit - 9 and Vegetables 5. Then I need it for each Class - so Apples - 5; Oranges - 4; etc. I can get my bases sorted/grouped to give me the sums correctly, but then I don’t know wha

Some of the data entry is funky - how do I protect fields so they cannot be changed?

Hi Community - probably super simple, but I have looked through and done searches but I still can’t figure it out. I’m using DATEDIFF to find the number of days between two rental dates, but it is not counting the end date, ie hire date of 12-Apr thru 16-Apr counts 4 days, not 5. I think the same goes for outing weeks too. Any solutions please? Thanks,

The option to specify a card cover field seems to make that field appear in the gallery view when a card is clicked, even when the field is hidden. This seems like it might be an unintended. Obviously it’s not a concern over the attachment content being shown since it’s displayed as the card cover, but it seems unneeded. It’s also weird that it says “hidden field” but is still shown. Wondering if I’m just missing something…

Is there a way to hold zapier activation while I finish all the new record fields? I have managed creating a new view which is filtered to have the last field filled so that zapier takes it as a new record. Is there any way I can avoid this? Thanks

i am looking to create a simple formula , i say simple even though i can do it . :rofl: :rofl: but here we go if column Fab pack issued is not blank ( or fab pack issued in full is selected ) i want area value indicated in formula column can someone please help me

Being able to paste images into a rich text field is very cool. We do this all the time in our GitHub issues: This is currently missing from Rich Text Fields within Airtable and kills all my hope of using it in our company :frowning: Are there any plans in the near future? Ironically it works here in the community board :grinning_face_with_smiling_eyes: So the advantages of using this feature in a productive environment must be clear. We also want to include audio and video for bugs and user feedback. Having to tediously create and reference attachments by their filename in a long text is currently something we don’t want to go back to and stopped us from using many other Productivity tools like Asana. Especially with filenames like “Screenshot 2021-04-06 at 16.37.06.png” generated from MacOS and not being able to just “Paste media content from the Clipboard”. Painful.

Hi, I want to create a scenario in Integromat that will get all the records (Customers) in Airtable. How do I design for this? I have tried using “Limit” and “Max number of Cycles” parameters but no matter combination I do, not all records are returned. Updating with screenshots; Regards, Ruchika