Table View column Totals

I have setup a view of my invoice table grouping records by customer and summing the total invoiced, total paid, and total owed fields. What I am wanting to do is to have a total row at the bottom…

How do I change the date format to year.month.day?

New 3.6 Script Editor

Is there a way of turning off the auto-complete function in the new 3.6 script editor? If I want 2x " (double-quotes) or a pair of braces () or {} then it assumes I always want a pair.…

Values of Multiple Choice shown as list in print report

Hi guys, Normally when you put the values of a Multiple Choice field in a print report, it's shown as all the values separated by a comma and a space. Is it possible to get the values shown as a…

• Answered

while loop stops before reaching end

Hi everyone, I created a button in one table which is to export some values to another table creating new records there. I am using a while loop to create the records.…

Organize Reports

Hi all One question about organize reports on DB. I organize a Table Reports ( no informaton here) with for now 3 reports one for each subtable (Disciplines,…

• Answered

I need to build a string for each "checked" multiple choice

Hi, Hope someone can help! I have a multiple choice field which has 5 options (at the moment, this may change). I have another field which is a numerical value,…

• Answered

URL Field expands off layout view

Hi, I've reported it to support as a bug, but just wondering if there's a workaround in the meantime? I have a couple of URL fields in a database and they're already at the maximum width I can go in…