Hi all, I am using a table to record jobs and one of the fields holds photos of the job during its progress. I what to be able to share a view of the table which only displays the photo field so that subcontractors can take photos of the jobs they ar...

Hi all, I’m using the following CONCATENATE() function inside of a SWITCH() which is displaying the result below. Is there a way to remove the decimal places so that it’s only correct to two? CONCATENATE("4 tins: ",“£”,6*26.32) = 4 tins: £157.920000...

Hi all, I’m creating a quotes table with multiple formula fields which include prices which I want to be able to change easily. At the moment, the figures in each of my formulas would have to be changed after a price increase which could lead to some...

Hi all, I’m creating a calendar for next year. I’m looking to have three identical records on every Monday and Tuesday for the entire year. What the easiest way to go about creating these? Just wanted to ask before I wear out my copy and paste keys (...

Hi all, Im using a table in a calendar view to display my free job slots which I am then clicking on to create a new job record in another table. Is it possible to auto populate date fields from one table to another? i.e. after clicking on a record f...