About JamesWB

JamesWB · 03-11-2024

Hi, I have a table called Loop where I want to create a virtual column that does a subtraction on two fields from a related table called Device. There are always two devices, one where [Device][Zone] = "Safe" and the other where [Device][Zone]="Hazar...

JamesWB · 11-30-2023

I want to create a dashboard calling a questionnaire form, a page where you can view and upload some documents and browse some reports.This needs to be visited by different customers (probably about 5 or 6, but maybe more over time) and each customer...

JamesWB · 11-14-2023

I want to use a Start...End expression in a template.I have the code shown below. The condition doesn't work, but all the field and table names, etc, are correct. This is a parent table Machine and a child table Hazard with the column 'Regulations' i...

JamesWB · 11-13-2023

I struggle a bit with template code, so apologies if this is in fact simple!I have a template that requires either a block of text or selected record to be written, depending on a text value stored in the record.The structure is that I have a Machine...

JamesWB · 11-10-2023

I have a table Hazard related to a table Machine. Each machine can have one or more Hazards.When editing in the Hazard form, the user can choose a Regulation number in the column Regulation.I would like any instance of using a Regulation no in the Ha...

JamesWB · 11-14-2023

Yes, the problem is though that Regulations is in the table Hazard, which is a child table of Machine and the template needs to call Machine.The use case is that there are Hazards belonging to each Machine. Within a Hazard, there is a Regulation.Mach...

JamesWB · 11-14-2023

This doesn't work either. It doesn't like having a conditional within a Start.<><> HazardCreationRegulationsBrief Hazard DescriptionImageFactor 1<<[HazardCreation]>><<[Regulations]>><<[Brief Hazard Description]>><<[Image]>><<[Factor 1]>><><>

JamesWB · 11-14-2023

Thanks. I tried that and a NOT, the template doesn't execute.<><> HazardCreationRegulationsBrief Hazard DescriptionImageFactor 1<<[HazardCreation]>><<[Regulations]>><<[Brief Hazard Description]>><<[Image]>><<[Factor 1]>><><><><>Some other text <><>

JamesWB · 11-14-2023

OK, I get the NOT bit, thanks.What should this expression be then if it uses "="?<>

JamesWB · 11-14-2023

This doesn't work either, which points to not being able to use START outside a table?<><><<[Regulations]>><<[Brief Hazard Description]>><<[Image]>><<[Factor 1]>><><>

My Stats

JamesWB's Bio

Badges JamesWB Earned

Recent Activity

Doing some math on related column values from another table on a condition on another column

Portal for different customers to view dashboard

Conditional within a Start...End in a template

Template logic issue problem

Changing a flag in another table

Re: Template logic issue problem

Re: Template logic issue problem

Re: Template logic issue problem

Re: Template logic issue problem

Re: Template logic issue problem