I have a group database on airtable that I am trying to clean up and make more efficient using some automations. Here is the flow: input group details into database, send a bid, send a contract, input into pms, get rooming list and input into pms, ...
I have a database of incoming groups with all the pertinent data such as group name, arrival/departure date, #rooms held, # rooms picked up, room rate, # guests, contract attachment. I need to present to my hotel managers a summary of specific infor...
Hi…I have a field with ‘arrival date’, a field with ‘terms’ (which is days prior to arrival payment is due. This is a number and varies from record to record)(Both are lookup configurations) and I want the third field to calculate the date it would b...
I’m sure this is a simple solution but I am just learning the formula lingo. All in the same table, in field a, I multiplied field b by .14 and it automatically rounds the number up. As this is a dollar amount and field b is also a formula multiply...
Hi…I have the table “Groups” and the table ‘Assets’. If a record in the field "Type’ in the groups table equals the word ‘bus tour’ I want to attach an images URL from the field ‘logo’ in the assets table to the field ‘logo’ in the groups table. My...
Thank you for your advice…I discovered that I can create the view that I want with what information they will need and share a link to it. They can filter and sort as they want and even download the contract or rooming list if they need it. Easy Pe...
Thank you Justin. I’ll check it out. Can you take problems that you help find solutions for here and do videos on them (with expansion of course) in YouTube?
Here’s one more: I have 2 fields in my financials table “# picked up” (rooms) and “# guest...
Ahhhhh…Thanks Justin! That makes absolute sense. I will give it a shot and definitely write that formula in my handy dandy reference book for the next time. You Rock! I have to admit, this is pretty fun to learn. Any good resources for really un...
Hi Steve…I just read you question as mine was similar but I came up with a different solution. I have a group table and a task table and I didn’t want to to add my tasks to the group table as it is quite large already (lots of logistical details in ...
Hi Justin…Thank you. It was originally a single select but I changed it to a number thinking that this was the issue as well but through my experimentation, it appears to be a problem with “terms” in my task table being a lookup. It only works if th...
