• Resolved michjack

    (@michjack)


    HI,

    Love this addin. I wanted to see if it would be possible to use the lookup values for ABN/GST registered dates in the number fields. I want to be able to do this so that I can do calculations on the dates and add conditional logic based on this.

    I am not sure how the date is stored, so this would probably only work if it is stored as a numerical value – similar to how it is in Excel.

    Regards

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author ovann86

    (@ovann86)

    Hey,

    All the dates that come from the ABR system are a string in YYYY-MM-DD format, e.g. “2007-06-18”

    How would you see this being applied in a number field?

    Thread Starter michjack

    (@michjack)

    Thanks for the quick response.

    My goal is to apply conditional logic based on how long ago the ABN / GST was registered.

    One way would be to display the YYYY, MM, DD as three separate number fields. This would then allow to do conditional logic such as:

    I.e. show a field if YYYY < 2014

    As a side note,it is also worth noting that if a company is not regisitered for GST, the date shows as 1970-01-01

    Plugin Author ovann86

    (@ovann86)

    hmm, sounds more like a case of needing to apply conditional logic to a date/date field – something that Gravity Forms doesn’t do natively but I see GravityWiz have a plugin to help do it … but as far as I can tell, it basically turns a date into a unix time string.

    I would try creating a date field, setting it up to act as a ‘gst registered date’ result and then where you want your conditional logic applied instead of entering a date enter in the equivalent unix time string.

    Do you follow what I mean?

    Plugin Author ovann86

    (@ovann86)

    Hey –

    Just a small update – it’s not as simple as what I thought.

    Looking at the GravityWiz Gravity Perk thing, it looks like it only supports US date format, which I think it’s safe to assume isnt that useful on this side of the Earth. So I’m working on my own free plugin that will do the same thing but will support all the date formats. I’ll let you know once it comes available.

    Plugin Author ovann86

    (@ovann86)

    Hey,

    I ended up writing another plugin to add in the date conditional logic functionality, similar to what comes from Gravity Perks.

    I noticed that GP doesn’t support Australian date formats (MM/DD/YYYY) at the moment – so this plugin is the way to add this conditional logic in.

    Let me know if you get stuck.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘ABN/GST registered date in number fields’ is closed to new replies.