Solved

Good Day I am setting up a customer base, Included in the fields is vehicle Information. The Car registration number, Make, Modle, Colour, 1st Contact, 1st Contact Phone, 1st Contact email, 2nd Contact, 2nd Contact Phone and 2nd contact email are all the fields that are for the registered person. The problem I am facing is that a person with more than one car has to register its registration number, make , Modle and colour. However the 1st and 2nd contact details remain the same. Is there a way of doing all of this in the fields without having to add the extra Information already entered

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, Professionals here, I encounter a problem, I want to use EmailJS service to send HTML emails. I try the automation of Airtable, the actions of “finding records” and “sending email”, but it is not as intelligent as I want, So I want to use EmailJS service. So I wrote the below code in Airtable script. let params = { service_id:'service_gbwx81a', template_id:'template_6euwe2d', user_id:'cxkTio1YLQSY241rj', template_params:{ to_name:"Stone", from_name:"Stone", reply_to:"Stone", message: "ABC", } } let headers = { "Content-Type": "application/json", }; let options = { method: 'POST', headers: headers, body:JSON.stringify(params), }; console.log(JSON.stringify(params)); let emailJSURL = 'https://api.emailjs.com/api/v1.0/email/send'; await doRemoteFetch(emailJSURL, "POST", params); async function doRemoteFetch(url, postOrGet, body = null) { let success = false let fetchedData = null let fetchOptions =

Here is my example address: https://www.google. com/maps/place/42+Nayland+Street,+Sumner,+Christchurch+8081,+New+Zealand/@-43.570045,172.7595125,17z/data=!3m1!4b1!4m5!3m4!1s0x6d32282318638d65:0xdbd8ceb7acf3afba!8m2!3d-43.570045!4d172.7595125 What I need to extract from over 350 records is this: @-43.570045,172.7595125, I was thinking i could take out everything before and after this showing up in the address but all longitudes and latitudes are different so I thought I could say maybe (?) I want to keep everything between the @ and the second comma. thanks in advance!!!

Hello, Do you know how to link to records from two steps in one field in an automation? Right now it’s concatenating the records into one new record instead of linking to the two records separately. I’ve tried adding “,” and “;” or even just a space to no avail. Thank you for your help, Joachim

Hello everybody! I was trying to create a automation that emails someone a prefilled form so they can respond to a record that somebody else put in. However both the button formula, and the record formula stops short of the entire form being a clickable link. It has the form link and then ?prefill then it stops. Can anyone help me with this? I would like the entire URL to be clickable.

Hello, How do I pass function parameters as JSON field name for updating fields in Airtable using Airtable REST API and Node.js? The code const updateField = async (id, field_name, updateValue) => { base('table_name').update([ { "id": id, "fields": { field_name: updateValue } } ], function (err, records) { if (err) { console.error(err); return; } }); }

Hello and thank you for any future replies, I need an automation that checks that every week 10 records have been created. If this is not the case, a slack push is sent. I have no idea how to do this. Do you have an idea how to get me started?

I’ve created a simple 3 question SMS flow in Twilio and by using Zapier I am easily seeing new records and their SMS responses in Airtable. How do I get all 3 responses added to the same record? I did my best to search for this and came up short, I apologize if this has already been answered. Thank you!

I am creating a proof of concept script which you can see below: const data = { title: 'AirTable Pusher', content: 'Push, push, push this.', excerpt: 'The short version' }; let response = await remoteFetchAsync('https://staging2.conveyancingqld.com/the_vision.php', { method: 'POST', body: JSON.stringify(data), headers: { 'Content-Type': 'application/json', 'Authorization' : 'Basic d2h5d29udHlvdWNvbm5lY3Q6Y2N1WSAxWWhkIDdsTmkgMzdWSSB5MVlyIDYySEs=' }, }); console.log(response); The return on the server side if you check at the time of this writing is: {“a”:1,“b”:2,“c”:3,“d”:4,“e”:5} It returns some JSON data - I want to access that in the AirTable script - however when I check the Console log response it says the following: {type: "basic", url: "https://staging2.conveyancingqld.com/the_vision.php", status: 200, statusText: "OK", ok: true…} type: "basic" url: "https://staging2.conveyancingqld.com/the_vision.php" status: 200 statusText: "OK" ok: true header

Hello, i am setting up a Google Apps Script to update some records from our student information system. I was able to set up an array of records in the required format for patching the data in Airtable, i also got it to work, however whenever there are more than 10 records i get an error, so i am trying to figure out the best way to process them 10 at a time using plain JS or Google App Script. I was thinking of implementing a for loop to send a patch request for every record, but that did not seem like the smart way to do it. I wondering what was the best way to break it down 10 at a time Thanks Anto

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.

I need to create an IF statement that works with the following logic: If the value of column X is less than the value of column Y, it needs to return the value of column X. If the value of column X is greater than the value of column Y, the IF statement needs to subtract the value of column Y by the value of column X. Can someone please help?

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.

Hello there, I’m trying to use automation for a particular case, with no luck so far, so I’m looking for some help here finally. I have several choices for a field, let’s say CompanyA, CompanyB, CompanyC. Now I’ve got another field, providing an URL, which is different for each A,B,C company (so 3 different URLs in this example). Now if I work on a particular record / line of my base, I’d like the URL cell to be automatically changed with a defined value depending on the company I choose in the Companies field. If I choose Company A, then the URL cell will automatically get the URL - A value, and so on. Any idea on how to achieve this, please ? Thanks in advance, Regards.

Hi there helpful community, I am currently facing the following issue: I have a list of requests from customers that I map to retailers in their area. I successfully calculate the distance between each customer and each retailer using the Google Maps Distance API. Now, I would like to automatically calculate the order of those distances, e.g. 1 = closest; 2 = 2nd closest, etc. I simulated this in the screenshot below. Instead of me assigning those numbers (1-3 in this example), I would like to calculate this automatically for all requests. Do you have any solutions in mind? In Excel this could be achieved by the rank formula I believe…

Greetings, I’ve created a simple base to calculate my stock (vapes) that i’ve ordered. However i am running into an issue. I have created three tabs (Current Stock, Sales (orders) and Orders from my Supplier). My issue is when i register a sale because when i put the items in product column (multiple records) the price at the “price column” shows only as 1$. If i only put one product then that is fine because the product is linked and the price shows okay but once i put multiple products on a single sale the price always remains the same. Hopefully i was clear enough and i can provide more context, info or pics if needed. Thank you,

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:

Is it possible to do this? I’d like have an Airtable form with an attachment field, requiring someone to submit a CSV file (with info already filled out). The contents are then imported into an existing table with the contents mapped out accordingly? I’d have them fill out the contents with a form, but sometimes entries could be as much as 20+ … I checked MiniExtensions but didn’t find anything that would work for this use case. Help is appreciated.

Hi, I’m looking to solve something that is probably very basic. I have a master table that I’d like to bring in add’l data (size) into from Table 2 using the first column as the key. In this example, here is size data from table 2 that will be going over to the Master Table. In the Master Table, I’d like multi select fields with the data from Table 2. Can anyone please help me figure this out? Thanks, Michael

Hey everyone, quick question: I use a table to organize my various types of tasks and I have the records groups by the single select the shows what task type they belong to. It gets annoying getting to the bottom of the list of tasks for a specific task type and the group going away and having to re-add a record and update the single select to open that group again instead of hitting the plus at the bottom of the group to add a new record to the group. Is there any sort of like automation that can detect that a group is out of records and to add in a new one to just keep the group open? If not is there any sort of solution that you guys happen to know for this besides the kanban view? Thank you for any help!

Hi Anyone have any clever tips for removing special characters from text to make them filename firendly? For example < > { } ) ( etc. I could do it with a massive nested substitute formula but that seems clunky so hoping there is a cleverer way of doing it.

My datafile has a field with multiple tags that are joined like this: TagoneTagtwoTagthree Is there a formula possible, with help of regex, to put a comma between all lowercaseUppercase instances to seperate them?