Other Questions

Hey! I was trying to group the weeks by the month, so like if I have a Date, I want to get the weeknum in which the date falls WITHIN that specific month only. Eg. - 1/6/22 - it should show as 1 - since it comes in 1st week of June. I read up and tried to use the following formula - MONTH(TODAY(WEEKNUM(NOW()))) However, its giving the output as 6(?!) I think its because its counting 26th May till 2nd June as a week. Is there any workaround to this please?

I have recently set up a form so that our customers can make booking based on available meeting times. Everything was working fine and suddenly the Time format on the form view has changed from DD/MM/YY hh:mm to yyyy-mm-ddThh:mm:ss.sssZ I am unsure why the format has changed and how to amend it back to the original. Many thanks in advance for any help you may offer

Hi All, Very new to AirTable! I would like assistance on the following: I would have made a formula for: if the single select field ‘major/minor’ is Major NC, then give a date 12 weeks from field ‘report date’, if minor NC, do nothing. and I see the correct results showing in that new column that I made. But I would just like the date to show dd/mm/yyyy but I am getting 2022-07-22T00:00:00.000Z for some reason? Also, it is not showing in the calendar view. I hope that makes sense!

Hello AT users - I’m wondering if anyone might have an idea on how I can solve an issue. I’ve got a base that has a table for Tasks Tasks are related to: webpages, video or photos. I have a table for webpages and a table for photos. I want to link each task to a webpage, video or photo but I’d like to have one field rather than 3 fields. So I was thinking I’d create a table “All content” that combines - webpages, videos and photos. The webpages & video tables are synced from other bases. Photos are added individually. The task table can link to records from the “All content” table. Airtable doesn’t let you sync tables in the same base - so I’m not sure how to create the “All content” table from the other 3 tables. Any suggestion on how to summarize 3 different tables - 2 of which are syncs from other bases into one? Or is there another way to have one field do a look up on 3 tables instead of 1 table? Thanks in advance for

I am trying to create a formula that creates a unique ID number based on a concatonated value. Value should reflect year, customer number and the order number for that customer. It should look like this, YYYY-CustNo-OrdeNo. So the order for customer that we sight up in 2022 as the first customer of the year and makes their fifth order will have the following number 2022-001-005. I have already generated the Year and customer number from our accounting program, so I have the first two pieces. (2022 and 001) but I need a formula to generate the order number relative to the client. Can anyone help with some code or a reference to the knowledgebase? Thanks.

Hello everyone, I have a calendar for work where people have the chance to show up to multiple events throughout the year. I would like to have a multiselect with the names of the various events instead of just days to show up. I’d also like to for their name to show up in the calendar with the days associated with the event. Is this something I’m capable of doing with airtable?

If I place the cursor in a cell, then normally I can drag that cell up or down by clicking on and holding the little square at the bottom right and then moving it up or down, but sometimes when I move it up or down no other cells are selected. I just stay in the one cell. Same when wanting to select multiple cells. I can only select one cell. I genuinely don’t understand why this is happening. It is independent of the type of cells I’m working on. Cells that I can drag one day are no longer draggable the next. I’ve turned Sorting on and off. I’ve tried refreshing the screen. I’m sure I’m overlooking something very obvious… but what?

A button field is appended in a synced table. What I would like to do is that once a user clicks the synced record’s button field it will update the source record based on other appended fields in the synced table. Is this possible? Maybe a script attached to the button field can do it.

It sucks that every other CRM comes with a dialer/ chrome extension to hook up with the CRM to call numbers with Twilio / Plivo dialer except Airtable.

A while ago I posted a question How to do Partner field? “When I have a new network of eg 10 partners, and I put all 9 partner orgs of 1 of those orgs in that org’s Partners field, I want it to, for each of those 9 orgs, also fill their Partners field with all the other 9 orgs (the 10 orgs minus itself) rather than with just that one org in whose Partner field I put the 9 other orgs.” and @kuovonne posted the solution How to do Partner field? - #6 by kuovonne I thought I’d post how I’ve now implemented it an organization can be the name of a network of organizations, in which case it is not a member organization itself or an organization can be the head of a network of organizations of

I need the summary total for each group, seems like this is not happening in airtable yet so my only workaround, in a hurry, is to print screen! come on guys!

Hi, I’m trying to send 17 records to an email of a collaborator - and to myself - but we’re both not receiving anything, and it’s not in junk mail. I’m highlighting records and right clicking and then ‘send all selected records’ From what I’m reading this should be possible on the free version as I’m sending to a colleague that is part of my team. Can anyone let me know where I’m going wrong?

Hello people! I am trying to setup a table which will contain reminders for when I want to connect with my clients. Basically, I want to setup weekly/fortnightly/monthly reminders based on day of the week. Like so - Weekly - Thursday, Monthly - 1st week Friday, Monthly - 3rd week Tuesday Now, the reminder should be mailed to me like this - Daily reminder - Based on the given day (weekly and monthly) Weekly reminder - All reminders in that week Monthly reminder - All reminders with Monthly frequency I’m feeling very confused as I’ve hit my brain on this for few hours wondering how to make it work. I have read lots of support posts and docs as well, and have given up now. Any help would be appreciated.

I would like the user to be able to schedule with the google calendar. I have created an automation on airtable so that every time an event is created on the google calendar, it creates a row in airtable. But this solution is not very good because it requires a lot of automation to manage the synchronization. Has anyone managed to do this differently? thx

I have a database of incoming groups with all the pertinent data such as group name, arrival/departure date, #rooms held, # rooms picked up, room rate, # guests, contract attachment. I need to present to my hotel managers a summary of specific information including attachments every two weeks so that they are prepared for incoming groups. What is your suggestion of an app or the best way to do this? Thank you. Emily

Hello, my dear friends! Has anyone found a friendly way to deal with having multiple tasks on the same day in Gantt view? The invalid dependencies are enough to drive anyone batty :stuck_out_tongue: , but I can live with that, what’s more difficult is sorting. We are trying to use the Gantt view to communicate tasks to team members on the build floor and coordinate hand-offs. However, the Gantt view can be incredibly confusing, becasue everything is all out of order. Is there a way to sort same-day tasks that are dependent on each other, so they are always in successive order? I did this in another base by creating 50 look up fields to look up the previous tasks task and so on, but that is a pain to recreate each time and will eventually break. Thank you!! p.s. same issue on timeline view

Any ideas how to write an IF code for hotel VAT? I have 50 hotel nights showing in column {Nights} multiplied by the {nightly rate} @ £200/night = £10,000 VAT is calculated @ 20% on top of the first 28 nights and then @ 5% from the 29th night onwards. I would love a formula that can calculate this.

My node api call keeps failing. My code is updating the same records several times, Is the Airtable servers slow that it can’t handle multiple calls concurrently ? There are several update calls being made from my API. I dont understand whats going on here ? var result = body.records.map(function (record) { ^ TypeError: Cannot read properties of undefined (reading ‘records’) at /fast-csv-js/node_modules/airtable/lib/table.js:116:35 at //node_modules/airtable/lib/run_action.js:70:17 at process.processTicksAndRejections (node:internal/process/task_queues:95:5) Node.js v18.2.0 FetchError: request to https://api.airtable.com/v0/appBtcEHoqEBYVB/IN/r? failed, reason: getaddrinfo ENOTFOUND api.airtable.com at ClientR

Hello, how are you? I wanted to ask you if there is a way to connect a Thinkific survey with the platform. We need to compare the results of an initial and a final survey and do a manual process. Thanks!

Hello everyone! I was wondering is there a way to make it so only creators can create views? From my snooping around I haven’t been able to find a way.

I’m not sure the best way to do this but I would love some direction if anyone can help. I have a base with all my upcoming events and their contacts and organizations putting them on (we have multiple each week). In one table are the Events and all their information. In another Contacts and the last is the Organization putting it on. I would love to keep track of which employees are working each event. What is the best way to have an Employee table and then add employees to each event and see it cleanily? (I have relationships across all 3 already) Would making an employee table, then link it to the events table and using a gallery view be the best way? The employee could potentially be scheduled to multiple upcoming events at the same time. Thank you in advance for any help!

I have a column named Day name which is a single select field containing names of day - Monday, Tuesday, etc. How can I create another column which gives the weekday number of this? I know I need to use Weekday() function, but how can I set it up such that it converts the string to work with Weekday() function? Thanks.

Hi fellow community members, In the Tool I am building to follow-up auctions, i created 2 tables: Table 1: “list of lots in auction” Table 2: “Price obs table” in which i made a link with Table 1 My target is, in table 1, to retrieve info from fields “Max Bid Price”, “Max Bid Calculation” and “No bid” fields from table 2 linked with the concerned record. Lookup field trial has failed. Any suggestions guys? Thanks for your help :winking_face:

I have 2 tables linked, one with job information (primary) and one with finance, when i delete one from the job information table the finance table still has its relevant data (information not linked to original). Is there a way of automatically deleting the one when the other is deleted? Thank you