Other Questions

If my base have two table that is Table1 & Table2,i want to do that when i upload a data in table1 through my app that data will automatic add in table2 …is it possible???if possible kindly help me @Bill.French add a solution image if possible

How can I create question with image on form?

Is there a character limit in the Formula field type beyond which the formula no longer processes? It allows me to type in arbitrarily long formulas, but I notice that sometimes after a certain point the editor no long suggests auto-fill options when typing in the formula, and when I finish writing a long one, it seems like the end parts of the formula don’t process. Then when I go back to look at the formula, the end part of it is not present in the Formula box, even though I know I typed it in there. (A separate, but related issue - the thing I am trying to accomplish with this is converting a month number from a date field to the month name. So my hyper-long formula starts IF(MonthNum=1,"January",IF(MonthNum=2,"February",IF(... etc. If you know another way I can accomplish this that wouldn’t run into character limits, that’d be great too - thanks!

I need to find a way of creating multiple views of all data from a table. Ideally I would like to create a table and duplicate the table in a way that if I edit the data on either of the tables it will auto update on the other table and I can set up different views and filters for each of the linked tables. I may want to show all tasks for one team member on one table and all tasks for part of the project on another table but be referencing the same data on each of the table veiws. The columns would be the same on each table, better still if you edit the column properties on one column it will update on the other. Any help with this would be much appreciated.

The code below successfully display records. Please how do I add pagination to it. Thanks const base = useBase(); const table = base.getTableByNameIfExists('myfirst_table'); // grab all the records from that table const records = useRecords(table); // render a list of records: return ( <ul> {records.map(record => { return <li key={record.id}>{record.id} -- {record.getCellValueAsString('lastname')}</li> })} </ul> );

Greetings to the Airtable Community! In my SVCS/Tasks table I have two special views. One filters where items are coded as “Task”, the other where items are coded as “SVC” and a status of “SVC YES.” I link to the SVCS/Tasks table in my Events table, using the views above to “Limit record selection to a view.” One column to display the SVC items, the other the Tasks. This was working well, but now I’m seeing SVC items in the Task view and vice versa. I’ve attached some screen grabs to demonstrate the issue. Any assistance/guidance would be most appreciated.

Is there any way for a “Link” field to share the filter properties of a “multiple select” field? For example, when filtering a multiple select field, I have many options (e.g., has any of, has all of…) and I can toggle the selected options on/off. Seen in these 2 screenshots: However, when filtering a linked field, I have limited options and I have to type in the exact thing I’m looking for. Seen here: Is there anyway to get the link field to act like a multiple select field? I don’t suspect there is. But wondering what the roadblock is to making this happen. Can that be programmed? My current solution is suboptimal. Every so often I copy the multiple select field column and paste it into a column designated as a linked field. It works but require a lot of ongoing maintenance and if I change the name in one place, I have to remember to change it in the other field. It’s a hassle. I would love a way to allow Link fields filterable similar to multiple select fields. Any advice

I’m sharing a view of a table to a client, however, when I update the table, their view isn’t updated unless they refresh the tab. This makes it completely useless for me. I would add them as a collaborator but that would give them access to hidden data that I need to keep protected. Is there a setting or work-around for this? Thank you in advance

Hey! I’m trying to count the number of Mondays and Thursdays between two dates - does anyone have a formula or tip on how to achieve this?

I’m setting up a large base to track an entire industry. I will have several people adding info to the base. The “Employer” field in the “Worker” table will link to the “Employer” table and will track the employers of each worker. There are thousands of workers and dozens of employers, and many of the employers have different possible ways to write their name (e.g. MEC Consultants, M.E.C. Consultants, Inc., MEC, etc.). Is there any feature in Airtable that will protect against us creating multiple unique entries for the same company over and over, other than clear rules, thorough training and pro-active clean-up?

Here’s what I’m trying to do: In Table-1 I have records with a “Created At” field and “Status” field. I’d like to create a new Table where I could see total numbers of records from Table-1 where “Created At” is let’s say May and “Status Field” equals to Done. I’ve tried linking records from Table-1 to Table-2 and use Rollup filed but it only counts number of linked records, to look like this: Month - May Total Sales - 12 Amount - 120$ Any ideas?

Hi I have a project / task management base that works well, If i can find a solution to the following point I’d be a very happy man. I have tables for projects and tasks and link the two, in the task view i have a grid view where task are grouped by project. The top task under each project is the next action on it, i have a process (GTD ish) where I have a list of those next actions across all projects, I currently create the next actions with a tick box I manually set but its cumbersome. Any suggestions on how this could be automated would be appreciated, Regards Rob

chart is very useful but i cannot see numbers or % in the pie or bar that i generate. Any suggestion or help ? Thank you

At the bottom of a form editor it states ‘send email of submitted form to…’, and then my admin email address. Is there a way to have these get sent to my assistant on a different email address? Thanks!

How would you approach representing a sitemap in Airtable? I can see how using a select field would help me denote different types of pages. But how can I overcome the fact that a sitemap is essentially a hierarchical construct? Thanks, all.

Is it possible to build a multi level bill of materials? Similar to this Bill-of-Material-Setup.png695×533

I will want to possibly create several different lists so that they can be choices for different drop down fields. Thank you.

I am creating a Master Calendar & Team Calendar system in Airtable, where each calendar update automatically updates/creates based on an update in the other calendar. I put together a system that created a “Unique Event ID”, which is a shared ID for the same event across both Bases. Everything is working great so far, except that I would like to delete records automatically in one Base if the corresponding record is not found in the other. There’s no Delete trigger in Integromat, so my workaround is: -The trigger is an existing “Update Record” automation After that automation completes, the automation will do a scan on both Airtable Bases. Step 1: Search all existing records on Master Calendar Base (up to 10,000) Step 2: Search all existing records on Team Calendar (up to 10,000) Step 3: Filter, then Delete - If the Event ID is found on the Master Calendar Version but does not exist on the Team Calendar Version, Delete the record on the Team Calendar (up to 10,000) I’ve tried a f

I’m trying to set up a hire system that tracks when an item is on loan or when it’s available. Is there a way to restrict selection of an item if it is ‘on loan’ for that date?

Is there any way to create a read-only table view that can be accessed anonymously via the API? I just want to be able to do a simple table lookup/mapping (with a filter formula) with a front-end Javascript call without exposing an API key (or having to host a back-end script on a 3rd-party server). Alternatively, is it reasonable to create a “collaborator” account with read-only access and expose that account’s API key?

I have recently configured the Map block on a few tables with a total of couple of hundred rows between them. A few days later I checked my Google Developers console to see how my geocoding API key was faring, and I was shocked to see ~18,000 requests for that key. If I open a Map block and the associated table simultaneously, I can see the geocoding cache column get updated repeatedly as I interact with the map — even though no data in those rows is changing. The gif below shows cell updates being triggered just while viewing/panning/zooming the map… Then, if I open up one of records in question, I can see a bunch of changelog entries of the form: “User X edited this record using Map block Y”… Can anyone explain what’s going on here? I’d like to keep using the Map block, but not if it’s going to blow up my API quotas simply by viewing the maps :frowning:

What am I doing wrong? How do I as the owner, make it so multiple users (<10) are able to view/update the database at the same time?

We would love to be able to use AirTable to create interactive client facing asset collection docs that only let them make edits to a couple fields (such as client notes and an upload portal). Ideally they would be able to do this is in a view where they can’t change anything except those couple fields. I’m not seeing an option in the field permissions to do that. The closest thing I’ve been able to come up with is giving the client editor permissions and then locking the fields we don’t want them to change. This still allows them to make edits to the view, grouping, filtering, etc. that changes the entire document. Is there a workaround for this that offers permissions sort of in between editor and a view link where they can’t make changes to the table but can utilize the upload feature in the records and maybe paste a URL? What I’m imagining is a locked kanban view where each card is a task for a process or asset we need from the client. They would be able to click the card to see th

Use SendGrid block to contact our members, great! But is it possible to schedule the start of sending? Met vriendelijke groeten, Geert Dornez

Hello, I am trying to gather information from my colleges on how they do specific tasks through out our building (some departments have the same tasks but are done differently, we are trying to accumulate all the data and compare). I have a grid view of all the tasks from all departments, but I am having trouble finding a way to track which department answers which questions and making sure that when a department does answer, the question can not be asked again (I do not want duplicate data if someone forgets that they already answered a previous question). Is there a conditional format I can use to accomplish this or will I need to find an external form builder? Thank you.