-
Round to nearest $5?
How do I make this formula round to the nearest $5 increment? if Host.'First Name' like "Kari" then 'Total Prize Pool' * number(Payouts.'1st Place %') / 100 end
-
Spam = Garbage = Not Good!
Alright. The SPAM is completely out of control here and while I don't 'offend' easily, some of it is frankly disugusting/offensive. --- My friends (show of 'hands' out there), ...…
-
Trying to count using where with child and linked tables data
Hi, I am new here and have spent a long time trying to do a simple count count formula. I can use cnt(Observations.Regulation.Code) to easily count all the codes on the form,…
-
Calculate new date by adding months to an existing date
I have gone through some of the posts and tried to use the syntax but don't seem to get it right. I want to add the number of months (Fieldname Tenancy Period) to date field Tenancy Start Date into a…
-
related fields in Pivot Table
I have a table which contains a date with a price fields. The day is broekn into Day field, Month field and Year Field. The Pivot Table view is then created using Year for left axis and Month for…
-
Filter field
Hi I need to filter out only data for the current week.. i can't seem to use a formula in the filterfield. I need to get only the records with the current weeknumber How do i filter out only the…
-
Prevent the reading of a field or reset it (make it null) if it is not displayed
I would like to know if it is possible that, when a field is not displayed thanks to a condition entered in the "Display this field only if" parameter, its value is not "active" or "taken into…
-
More Spam
For those checking in for answers, hang in there. You might have to load a few more pages to see your response.
-
Show a form within a form and link it to a contact.
I have a Form which is called "Contacts" for my customers. On this form is data such as name, address etc. I have another form which shows around 30 choice fields for pupil progress,…
-
Popup related record
What is the script to open the related record in another table ? Thanks in advance for your reply.