Build Forms & Workflow Apps

- With NO Coding Required

Try Us Free for 30 Days

First Name*
Last Name*
E-mail Address*
Password*

Build forms & workflow apps

with no coding required.

Create

Workflow apps made easy.

Simply drag and drop objects on a canvas to build powerful and engaging html forms and workflow apps.

Learn More

Deploy

Get apps into production fast.

No technical skills are required to get your app into production. You can deploy in minutes without relying on IT.

Learn More

Report

Monitor and improve.

You can build powerful reports to monitor performance. Get the visibility you need to drive improvements.

Learn More

The Form is Just the Beginning

It doesn't matter if you have one simple online form or 100 complex workflow processes, PerfectForms can scale to meet your unique needs. From feedback forms to entire customer relationship management applications, PerfectForms offers a flexible, powerful environment to:

  • Design HTML forms

  • Automate workflows

  • Integrate with other systems

  • Create reports

Using our intuitive visual designer, simply drag and drop to build pixel-perfect forms and workflow applications which are accessible from desktops, tablets or mobile devices. No coding required.

Do you need to automate a form or workflow and don't have access to IT resources? Do you need to replace a manual, paper intensive or outdated application? We've helped companies, across industries and in every department, optimize workflow processes and reduce costs.

Mike Abney
Process Improvement Facilitator (Retired), University of Tennessee at Martin
We took an entire department paperless – automating 20 processes in 2 weeks with just one resource!

Technology Partners

Technology Partners: BBB, VeriSign

Customers

The US Bank
State of Oregon
University of Tennessee
Do NOT follow this link or you will be banned from the site! Date format in report csv output - PerfectForms

Date format in report csv output

Home Forum Reporting Date format in report csv output

This topic contains 3 replies, has 2 voices, and was last updated by  Dennis @ PerfectForms 5 years, 10 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #6962

    Peanuts890
    Participant

    I am trying to import a date to a software package that only accepts csv format of dd/mm/yyyy from a Perfectforms report. the form is setup to show the format dd/mm/yyyy but I notice that the csv exported from the form is yyyy/mm/dd (unless you read it in Excel). Thought I’d be clever and create a formula using day(date) + “/” + month(date) + “/” + year(date). Work great except that day and month values need to be 2-digits. Then noticed there is some new functions, GetExactDay, GetExactMonth and GetExactYear which are not on our system. Presuming that these were introduced as part of an update. Can you advise whether we can get them without updating or whether there is a workaround using the day, month, year functions.
    Thanks.

    #6967

    The new functions, GetExactDay, GetExactMonth and GetExactYear were part of an update. In lieu of the update you could use some helper fields and behaviors to set a field with the full date including zeros. Set the day in a day helper field. If the field length = 1 use a Set Field with a formula (0 + d + day). Then use another set field to set the Day helper with a replace function. Replace d in the field. leave it blank so it replaces d with nothing. Do the same with the month field. Then put them together in a formula (day + / + month + / + year).

    #6968

    Peanuts890
    Participant

    Thanks Dennis for a quick response. Not sure what you mean by helper fields. Do you mean additional fields to hold temporary results? I have already split the date into day, month and year fields. Can I manipulate the day and month fields or do I still need additional helper fields. Hate to ask, but in this case an example would help a lot.
    I was hoping to do all this with the formula facility on each report field assignment, but guess that can only be done using the GetExact functions.
    Thanks.

    #6971

    I have emailed you an example form. Please let us know when you would like to update your installation.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.