Other Questions

Hi- I know this probably has a really simple answer. But I have a new base with one table and when I go to my Grid View options, I don’t have “Form” as one of the options. All my other bases have the Form view as an option. I have a Pro Plan. Could someone tell me why I have no form option? Could it have something to do with using a synced field? Thanks! Lori

Hi, I have a rollup field in a table, and I want to limit which linked records are included in the rollup by a condition. Specifically, I am looking to get “this week’s data”. In my table where the rollup resides, I created a field to use the Weeknum() function and get the number of this week. Then, in my linked records I also have a Weeknum field. So, in the rollup, I want to only sum those linked records where the Weeknum field value in the linked record = the Weeknum field value in the table where the rollup field resides. But it doesn’t seem I can do that. I would have to update the condition each time I need to pull or review the weekly data and manually set it to the number of the week I’m looking for. Any ideas on how to accomplish what I’m trying to do? Thanks in advance!

Hello everyone, everything good? I’m facing a difficulty in extracting data from the airtable to the power bi free version, even using the api the power bi doesn’t do the extraction, can someone help me?

Hello, I’m looking for some help with a peculiar issue. I have a Calendar view set up and for some reason Monday and Tuesday are titled ‘My’ and ‘Kill’ respectively. All the other days are written correctly. I have no idea what is causing this. I have checked my browser location is correct, but can’t think of anything else. Can anyone advise on how to fix this? Thanks in advance!

Hey I have created a database that has lots of useful information about hundreds of careers for students. I want to add a public comments section where users of the database can engage with each other. Is there a way to make that happen? BTW I am planning to sell the database through Gumroad, where I have shared a read only link to the base. Feel free to let me know if you’ve any better ideas about the platform I should be selling it through. Thank you in advance!

I have a bunch of table linked to different events. I want to create a view that filters out all future events except for the next one. Anyway to do this without having to manually check and uncheck a box?

Hello Pretty new here and pretty new to database design. I have a 2 step user data entry process, with a separate table for each of the two steps. The first step asks a user via a webform to record their performance in an activity. In the second step, I want the web form to call up the data form the first entry/table and present it for the user to then answer more questions aimed at reviewing/assessing their own performance. I want this second step to be able to be done at a later time, on a separate sitting. In this case the user is only me, so this simplifies things. I want to be able to bring up a record on a front end, see the results of one entry and answer my assessment questions to be placed into a second table. Hope this makes sense and I appreciate the assistance. :slightly_smiling_face:

I can’t find the right one 。 btw，how to use the filter（like above image） by the [airtable.js ] [select api][ filterByFormula ].（I can’t find a suitable document） Please!

I have a long text put in a 「Single Line Text」 Cell，(Long Text Also like this)。 when the text into cell，then I see the cell change my text。 Here is the comparison： The top one is the original, the bottom one is the modified one。

Hi all, the XML import app works well for me in trying to import ONIX files - but: I can’t get the app to remember my mappings… Airtable Documentation just says “The app will remember your XPath mappings the next time you import an XML file.” Except it doesn’t… ;-p I am sure I am missing something really obvious?

I created a formula to add 3 weeks to a date that I capture elsewhere in my table, and added an IF blank statement, so if there is no date it won’t show anything: IF({Date Intake Completed}=BLANK(),0,DATEADD({Date Intake Completed},21,‘days’)) The formula is working, but the output format is not what I’d like: 2021-05-19T00:00:00.000Z, I would prefer 05-19-2021, or something like that. When I try to change the format though, I get this message: Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date. The output is a date, so I am not sure why I am not given the option to update the format. Appreciate any help! I am new to Airtable and this is my 1st formula, so hoping I can get it working.

Hi! I apologize if this is a dumb question, but I’m really stuck. I have a column of dates and times that I am available for office hours that ultimately appear on a sign-up form. The way I’ve set it up, I have to manually copy and paste new dates and times from an autogenerator page that also exists in the base. I just want to be notified when I need to do this copy-paste process, which means that I need to find the maximum date in a column of dates and have an e-mail sent when I am near it. Is there a way to do this? A rollup isn’t what I need, since I’m not linking anything. It’s possible that the solution is “note the date and create your own reminder”, but I’d prefer automated if it is possible…

We’re using AirTable to track actions and filtering the todo list using a checkbox field titled “Completed”. I’d like to setup a new view that sorts the tasks with most recently completed at the top. Manually adding the “Completed date” isn’t an option as people will naturally forget to fill it in. I’ve looked down the list of available formulas but nothing jumps out as being suitable. Thanks in advance for any help.

I have a project table, which one project links to many tasks. In my task table I have a Blocked By, in which I can select previous tasks as blockers. When I click the + to add a blocking task, the resulting list is all tasks, of which there are many. Is there a way to limit the display to only tasks inside that project? I tried “Limit record selection to a view” but that means I would need to create a view for each project. Thoughts?

Hello all, I have a single select column named as “City” in all tables of a base. Now I want to have a sync between all “City” columns so that whenever I add a new city as an option it should be updated in all. Therefore there should be a option sync for single select column. Please share a solution to it. Thanks

Hi! Currently I am developing dashboards for customers. The apps/chart will be displayed on a wordpress page using html code generated by Airtable “share”-function. Currently the interaction function prevents me from doing this. I don’t want the customer to be able to see all the records when they click on the chart. Conclusion: I only want to show the graph and not the underlying data. How can I do that?

I didn’t find a way to do that via formula.

I have a table that I’m using to track instrument checkouts for a high school marching band. It pulls from two other tables (one with the student information and the other with the instrument information), but I also enter data directly into the form, namely the date the instrument was checked out. I want to automate the step of filling in the school year field when I enter the date that the instrument was checked out (see screen shot for what I want it to look like). The formula I used is this IF(IS_AFTER({Date Checked Out},6/3/2021), “21-22”) but it only gave me an error. How would I change the formula to get the result I’m looking for? Alternatively, because the school year will only be “21-22”, I could just have that field pre-populate with that value when I create a new record, but I haven’t been able to figure out how to do that either.

Hello everyone, I am facing an issue with airtable CSV export. Every time I export, I see the first column’s title to be a string (i.e. I see quotation marks in the column’s title). I don’t wish to add an empty first column or to edit manually every time I export. Any solutions you can suggest!? Thanks tons

Is it possible to create or copy a table by using api in the same base?

So I found this helpful article https://support.airtable.com/hc/en-us/articles/221104988-Conditional-formulas-with-emoji and used the IF({Completed} = 1, “ :white_check_mark: Done​:white_check_mark:”,IF(IS_BEFORE({Due date}, TODAY()), “ :alarm_clock: OVERDUE​:alarm_clock:”,“ :running_man: In-progress​:running_man:”)) AND IF(Completed = 1, “”,IF(IS_BEFORE({Due date}, TODAY()), “ :alarm_clock: OVERDUE​:alarm_clock:”,"")) Formulas. I am wondering how I could add a date range and have a DUE SOON stage. (instead of in progress, but conditional upon it being due within 3 days)

Is there way to have the button field empty if the record doesn’t have anything in the correlating source field? Ex: I have a “OPEN LINK” button for each record, from each’s social link field. But some records don’t have a social link - and they still have a button (even though it’s a different shade). I want no button for the records without a social link (or whatever source field/URL.)

Is there a way to create a chart based on a multi-select column, but display only certain tags from that column? The specific case - I have an x-axis that is based on a multi-select column “Territory Availability” with 245 possible tags representing global regions, I’d like to be able to create a chart that would show a smaller set of these tags - 25 specific regions. I’ve tried to create a separate column which the app could reference, but the original column is automatically updated by a data feed on daily basis which has complicated other attempts to isolate the 25 regions I want to represent.

I’m trying to use the web clipper app to get the company URL from the button “VISIT WEBSITE” on any LinkedIn company’s profile, and I just can’t seem to figure it out how… I already manage to get the “VISIT WEBSITE” text using the “Text content by CSS Selector” option, but when I try to use de “HTML attribute by CSS selector” option (using the ref attribute), I get nothing in return. If someone can show me what am I missing, or konws about a workaround to solve this, I’d really appreciate it. Here is a screenshot of what I’m doing (without success), de CSS Selector works to get the text “Visit website” though. And I also used the selector “#ember356” with the same results (works with “Text content by CSS Selector” but doesn’t with “HTML attribute by CSS selector”). Thanks in advanced!

I have a Tasks table, which has a Status field (Started, Done, etc) and a multipel link to projects table. In project table I have the lookup field, which shows me links to all tasks in that project. I can enter tasks here and also click to see task status, etc. This is perfect. But in the tasks table, when a task is marked as Done, I just want to hide it from both tables. I have tried multiple formulas and rollupfields, which does what I want but they are just a text list of tasks. I have also created a view hiding “Done” and then filtered that view in the lookup, but nothing happens. Example: This record has all tasks marked Done, which the rollup field sees. But the linked field does not: