Other Questions

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:

We need to be able to build a calendar from multiple tables to track and manage our Brewery Schedule. We have tried with Zapier but the time delay is an issue and it’s not a true integration (when you update AirTable it won’t update the Google Calendar in real-time). I’m surprised there aren’t more people that require this feature- it’s a key limitation for us. Will the new Blocks feature help, or is there any other way to accomplish this?

im working on project having multipule bases. im facing an issue that i want get a data from table of one base and store it to a table with different base. i searched in metadata api ducumentation, i submited a new form Airtable Metadata API Request Form but didont found a taken. how to resolve this issue? how to do registration?

Need help on Webclipper since it is not working on Wayfair but works on other sites

Hello! I am trying to put together an email digest that shows start and end times that are synced to my base from Google Calendar. My Google Calendar is set to Alaska time, and the times show correctly within my base. However, when my email digest is sent, the times have been converted to UTC. I have seen the threads about dealing with this through formulas, but because my dates are synced in I can’t modify those fields. Does anyone know how to address this? Thank you!

Hi there, new to Airtable but familiar with relational databases. We want to import a CSV on a regular basis and then from the mapped data, have it fill data that is already in a lookup table. The specific problem we want to solve is this: We have a CSV file with a list of courses and instructors associated with the course. If the course in the CSV is SOWK 600 we want to import into our Fall 2021 table and have it link to the Courses table and the faculty table. Can that be done? The relational database side of me says it can but i cannot find the appropriate terminology for Airtable.

I am using Integromat to build some fairly complex summary reports. Things are going well - but Integromat cannot seem to serve up info from Linked Record fields - instead - shows some sort of alpha-numeric ID tag. A lot of my data is represented by linked records, and I’d like to not have to make duplicate fields that strip them down to string text. I have an Integromat ticket in, but curious if anyone here has run into that. Was excited to get Integromat approval from our IT dept, and was hoping it would be the silver bullet that it seemed, but this is a major issue… Thanks!