Hey everyone!I’m running into a challenge while using Airtable in conjunction with Fillout forms. When using the duration field in Fillout, it only provides the exact times (start and end) rather than a length of time in between. To simplify things, ...
Hello,I have created a check Request form in my system. For some of our transactions we will deal with multiple transactions but I only want to have one button. I have created multiple fields (Fee #1, Fee #2, Fee #3, Fee #4, Fee #5). I am trying to...
I have a table with all our fiscal weeks, and their corresponding start and end dates. ("Fiscal Weeks")I have another table with projects, and the start date of each project. ("Projects")I need to add a column to the Projects table that tells me whi...
Hello,I have a table that is synced with transactions from my bank account, but I need help with extracting data from a JSON string stored in the Notes (Long text) field.An example of the JSON looks like this: { "transactionId": "2022142460021", "end...
Hey everybody,I am trying to match 2 columns to see if a name from column 2 appears in column 1 (list of names). The answer I need is simply true or false.Column 1 is a lookup field with a name.Example: “Smith, Jack”.And column 2 is a list of names. ...
Hi Airtable Community, The problem is to check in Airtable whether a value in a column (e.g. column 2) occurs **for the first time** or whether it is a duplicate. If the value is the **first occurrence**, a value from another column (e.g. column 4) ...
I've tried to work my way around this problem several ways and I can't seem to figure it out... I have a nested IF statement that uses a value from a text lookup field that just doesn't want to play nice. Essentially, I have a formula title for a rec...
If my event is September 2, 2025 (aka "program start date"), it would be in Quarter 3, 2025. But I need to list that commission would be paid the following quarter (aka "quarter earned", so Q4, 2025. Fiscal year runs Jan - Dec like the calendar.I cur...
Hi again,Is there a way for you to have data from a field "written" to that field and fixed for those changes elsewhere will not affect the result in this field in the future?An example of this might be;A fee in one table is designed to be updated in...
Hello everyone!I need help with a formula that computes two fields as {field 1}/{field 2}.However, the base is new for my team, and we're working to input backdated data, so some records that use these fields are 0 (zero), at the moment. The formula ...
| User | Count |
|---|---|
| 906 | |
| 836 | |
| 611 | |
| 552 | |
| 381 |
