Dear community of people so much smarter than me!I am using Airtable to build a film budget that has a number of fields and formulas that are causing me headaches. Table 1) Budget top sheet (two rollup fields: budget & actuals)Table 2) Budget (above ...
Hello, I am new to formulas so I was hoping someone can help me with the formula below. I am trying to create two new formula fields.In the first new formula field, I am trying to do the following: If the 'Category' field is Finance and the 'Owner' f...
I am facing difficulty in prefilling forms with 'Link to another record data type'Data is occasionally getting printed when the data type is 'Link to another record' with 'Allow linking to multiple records' switched 'ON' What changes should I make so...
Hi. I am trying to construct a formula in a Make.com search records module. The module is the trigger and I've been trying:AND({Ind Doc}!=BLANK(),(DATETIME_DIFF(NOW(),{Record Created}(),"days")=14))('Ind Doc' is an attachment field)Any help would be ...
I am looking for a way to calculate some percentages in my base. There are a few things I need to do first:1. I want to only include records listed as "Budgeted" or "Not Budgeted", not any "N/A" records. (this removes TEST 1 and TEST 4 from my calcul...
Hello,After the customer submits a request form to the client for order fulfilment, if the client has a follow-up question for the customer - Is there a feasibility/workaround to submit a comment/question on the request so that it can be re-directed ...
Hello, I just started with Airtable, and to be able to use it, I need solve this problem. I am having a database of volunteers on a national level. I would like to make them write their post number when they apply, and in the base allocate a decided ...
I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a l...
Hello,We are a vitamin supplement company and we buy ingredients from all over the world. We have 178 different ingredients which are used to create 17 products. Sometime the same ingredients will be used for five different products.We want to creat...
Hi There -Im having trouble with adding dynamic mentions with my slack message automation in airtable. Currently my airtable is connected to salesforce where it pulls a managers name into the airtable record. I'd like to set up an airtable automation...
