Hello all, I have a tenant directory showcasing all units and properties. I have 2 locations with the same unit # but different buildings. I've created a separate column to distinguish the buildings and their identical units. Here's an example:Buildi...
Hello all, I have a question, and hopefully there's some type of solution to this issue. I managed 3 properties, but for now - we can just focus on 1. Property A has a total of 100+ units. When an end user fills out the form - they type in the unit n...
Hello all, I created a form, and one of the field values needs to be "1" as the default value. However, I need that hidden so that when someone goes to submit data, they don't have to fill that field in as "1".Now this is what I have:I tried hiding t...
Hello all,I'm formulating a formula to get the total number of days requested for PTO. The current formula I have is:DATETIME_DIFF({Event End}, {Event Start},'days')The output of this displays the days, but also accounts for the weekend days as well ...
Hey guys, I'm currently stuck on how to formulate a profit based off the total value of the invoice. This is what I currently have:I have the formulas needed to determine the selling price of each product, however via my "Invoice" tab, I have this: W...
Having trouble comprehending this task. Care to outline this? Primarily the automation side. I'm stuck on the update record side of the automation:I have a separate table with: Attachment ID (Main Column) Attachment (1 File) Onboarding (Linked Record...
I actually did something simple. Created a formula with nested IF statements to input the correct value, based on another field's entry. I also removed the input box on the form. Thanks all!
Current Base:https://airtable.com/appYczVtYecoeXdMC/shrhL33aLMGGm2d8R/tbltju9ns971KmN2r/viwHhTYzlTmgzvd83?blocks=biphzXPHX5nZQ2LOS I'm not sure how to capture the profit value based off the markup of said products. Maybe you are explaining it, and I'...
