I need to populate a Lunch Menu Scheduler with a Unique Lunch Menu each week day and I want it to grab the menu item from another table of 10 Menu Items sequentially. So every Monday the “Dinner” field is filled with the next meal in a list of 10 Mon...
Hello everyone, How do you remove the last word from within a string in a record so that another record shows the same without the last word?
I am looking to create profit margin and profit margin formulas on a multi-record base that I am using for inventory management. The manufacturing cost is on one page, purchase orders on another page and sales orders are on the final page. I’m lookin...
I’m trying to make a basic set up for switching between currencies when pricing a product I’ve got 2 fields; one for € and one for £ and then a formula field that’ll show the price from the £ field or the € field depending if a ‘switch’ is set to £ o...
I have a table called “Conferences Costs” I have a table called “Conferences” In Conference Costs, I pull in the conference name from the “Conference” table. After that I have a column called “Year in Review”. This is the year that the conference fal...
I’m using a formula to create a URL that automatically prefills a form field in an airtable form. It uses the title field in the URL and the replace function to replace spaces with %20 But it also seems to be removing any periods that are found in th...
I have a start date (example 12/25/18) I have an end date (example 12/26/18) I need to find out how many days that is total. I used this: DATETIME_DIFF(Date1,Date2,‘days’) and it came up with 1 (26-25=1, however that is accurate as it needs to be 2, ...
I get an error when I use DATEADD with a date I formated in another field with DATETIME_FORMAT. Is there a way to “unformat” a date?
I have a schedule table for a church band. Another table is used for setlists that are connected to every church service. Every record in the setlist table is linked to the schedule table through the datefield. In the setlist table I want to filter t...
Is there any way to concat all the values in a column? Bascially I have 60 email addresses and I want to concat so that I can reference all the emails at once. Need all in one field. Similar to the CONCATENATE(TRANSPOSE()) functions in excel? Any cha...
