Jump to content

Aussie John

  • Content count

  • Joined

  • Last visited

  • Days Won


Aussie John last won the day on February 20 2015

Aussie John had the most liked content!

Community Reputation

6 Neutral

About Aussie John

  • Rank
    wanna be master

Profile Information

  • Industry
  • Gender
    Not Telling
  1. Can't upload new solution to server

    It was to do with password protected files; under database server>> security>>Require Password-Protected Databases probably not your issue but it did catch me on a couple of files.
  2. Can't upload new solution to server

    There is a new v16 security option that can be unchecked in the admin console which will prevent uploads
  3. Hi I have a DB where I have a string of Relationships with tables as follows: Room Type>>Room Name>>Equipment in room. There will always be a Room type and always at least one Room Name but not always a piece of Equipment in the room. The tidiest way I have found to report this is from the Equipment table and use field sliding to remove potentially large areas of blank as Equipment detail varies significantly can be very detailed and may include photographs and special additional detail and notes, but without a piece of equipment in a room the reporting misses that room (and room type). I am currently resorting to using a dummy equipment record. So, Ideally I would like to report using the room name table but as Portal sliding options are limited and making a list of equipment would also not be good as there are many different field types to report on and seems overly complicated. Any suggestions and Thanks in advance.
  4. Color-assigned sort indicator

    Provide a prominent sort button might be enough. I'm not sure this will work in Go but control your users menu options and force your users to use a scripted sort.
  5. Connecting to Xero

    Thanks Rwoods. Any plugin that you know of?
  6. Connecting to Xero

    Hi does anyone know of a tutorial or other instructions for connecting to Xero (cloud finance software)
  7. The other alternative is to have a related receipts table and drop the new files into a portal. That way they have a unique date or description.
  8. how to add text from parent record to child in portal

    If I understand you correctly you should be able to create a calculation field in the child table << ParentTable::fos_root_name & ChildTable::sequence number >>
  9. Backup script error and corrupt files

    Setting the permissions for the source and the destination fixed things - thanks
  10. Insert PDF error

    Yes PDF is visible and will attach to an email if the check box is selected. Insert file does work. just not Insert picture or PDF
  11. Insert PDF error

    The file appears to save ok and the error occurs on the insert picture step. (error 100 file is missing). Just to be sure I changed get(temporarypath) to get(desktop path) but with same error.
  12. Insert PDF error

    Thanks but unfortunately no luck I had already tried with out filemac (didn't work). There is no space - just looks that way And yes I can see the field highlight during the script
  13. Insert PDF error

    Hello - If I run my script to insert a PDF from a saved PDF I get an error after the insert picture step saying "can't find the file" - I tried "insert PDF" but the debugger says it is a wrong file type. The data viewer shows - $temppath as filemac:/Macintosh HD/var/folders/bd/v_q7j9997d1dph_lz5m1x_mm0000gn/T/S10/Dec 2016-2077 UTAS Retainer.pdf the Script is as follows; Set Variable [ $temppath; Value:"filemac:/"&Get(TemporaryPath)&Project»DATA::worksheet filename&".pdf" ] Save Records as PDF [ File Name: “$temppath”; Current record ] Go to Field [ worksheet PDFs::PDF ] [ Select/perform ] Insert Picture [ “$temppath” ] Any help would be appreciated. Cheers John
  14. Get original contents of a checkbox field

    Interesting. I'll try that
  15. Backup script error and corrupt files

    Hi Wim some of the backed up files won't open (file size in KB not MB)

Important Information

By using this site, you agree to our Terms of Use.