Hi! I have the following problem I'm trying to solve:I have one Trip table which lists a series of trips, which each have a start and end date and a list of 4 potential locations.I have another Crew table which lists crew members start and end dates,...
I'm trying to create a field which lists a user's two heads of department (HoD) for each building.I have all the pieces I need in my current table, but am struggling to find the best way of looking up the data to return.I have the following fields fo...
Hi,I have built two automations which work great independently, but when I use both of them in my table one errors out with a "Could not convert string to date" error.Here's what's I've got going on:Automation 1 looks for a Name field with no Start D...
Hi, I am using a timeline view in my interface to view the holiday status of our crew.I'm having an issue trying to find out how to keep one field per line - in this case my "Name" field.Currently, the names are all over the pace in terms of layout, ...
Hi,I'm trying to work out how to display the difference between two dates as weeks, then days.As an example, one of our crew will be away for 9 weeks and 3 days. It is difficult for them to work out how long that is if it's only displayed in days (66...
Hi Adam,Thanks for your suggestions. Rather than use a separate table I ended up using an automation to watch whether a record had an empty HODs field but a valid building and department, then find records matching building, department, and whether a...
It's fine. I think we're going to have to go with the standard base, as opposed to an interface, for the moment. Things certainly look better there. Thanks for your help @Alex_Wolfe !
Thanks for your reply Alex. I am trying to do this in an interface, for ease of filtering by our crew (immediately choose departments, roles etc from a dropdown menu, instead of having to go through the filters at the top.)I've had a look at the time...
Hi @Alex_Wolfe. Thanks for the suggestion. I've just tried all row heights and unfortunately it doesn't seem to make any difference at all.I also tried removing a large chunk of the label for easier reading, but that didn't seem to make a difference ...
