I have the primary field set as a formula right now as CONCATENATE({Client Last Name},', ', {Client First Name}). I want the formula to include the spouses name after the client's name if the marital status (separate field) is married. What would be ...
Hello there,I am trying to create a formula that calculates the total cost of items based on their quantity and unit price; while also factoring in a discount percentage if applicable. I have tried using nested IF statements; but I am running into so...
Hey all! I am trying to set up a form that is being sent out to about 200 people for the purpose of tracking time allocation for employees. To do so, the employees will fill out a form at the end of the week, selecting the projects they worked on thr...
Hi,I'm using AirTable to track potential sales opportunities and would like to visualise on a chart the revenue per month. This is similar to the Gantt chart view but instead would show the size of revenue rather than simply a project.For example, i...
Hola necesito generar in ID de solicitud para mi form que sea facil de buscar o indentificar
How do I use sum values automatically calculated when grouping fields for other formulas?I have to calculate the sum of values of a grouped field in other formulas. Is it possible? someone told about rollup, but I did not manage to obtain any useful ...
I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteeredI want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and i...
Hi all, first-time poster. I'm working with form submissions right now, and I'd like to check if the free text of a Location form field matches any value in an existing table's list of locations. For instance, if we received 'Bayview South' in the 'L...
Hi there,For the same task, how can you define a Daily Time Required of 100% on certain days or periods, and a lower percentage on others?Thank you!
Hi! I am unsure if it is possible to create a formula to make this work for my school, please help!I have a base created to track all applicants. We offer 5 trade classes each held 3 times a year that have a minimum age requirement; age 16yrs and 8mt...
