Hi Airtable Community, I have the following problem:I have a Projects table with columns Assigned Budget 25, Assigned Budget 26 etc.I also have a table “Orders” which is linked to the project table. This means that several purchase orders can be assi...
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) ...
Hello community, I have an automation that informs the user by e-mail if the deadline of a task is before the start date. Unfortunately, in my opinion, it is not possible to set a dynamic validation for fields that would prevent this.However, if the ...
Hello everyone,I have a complex use case that I would like to implement in Airtable.I have a table “Projects” where projects can be created via a form. Among other things, the form must specify how the project affects our strategic goals. So we have ...
Hi Community, i have a single select field with the following options. I want to add up the results from different columns in a formula. To do this, I need to extract the score from the rest. For example, only “2” should be extracted from “2 More the...
Hi @TheTimeSavingCo, in the projects table we have the projects an the assigned budget for each Financial Year.In the Purchase order Table we have the informations regarding the POs and the link to the financial Budget for each PO. Test project 2 has...
