How to show Numeric Calculation

  • dalaho

    (@dalaho)


    1 year ago

    Thank you for the great job you’ve done with this plugin and for letting us use it.

    I have a database solution to manage a queue system, but I’m having trouble getting it to work when trying to display how many days a user has been in the queue. I’m using this
    [date_recorded]+[#n_days]=[?days]
    in the template and Numeric Calculation box. However, I’m not getting any results.

    I would greatly appreciate it if someone could suggest a solution.

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

    (@xnau)

    The time span tag needs a value, the “n” part of the tag must have a number to tell it how many days it represents.

    Taking a step back from how you are doing this, I assume that what you want to show is how many days it has been since the record was created. If that is what you want to show, you can do that like this:

    [#current_date]-[date_recorded]=[?days]

    Thread Starter dalaho

    (@dalaho)

    Thank you for the quick response. I have made changes in the field but it still shows empty results. Is there anywhere other than the field itself that I need to adjust to get the results to show?
    Grateful for a solution.

    Plugin Author xnau webdesign

    (@xnau)

    First, the field must be a “date calculation” type field.

    The way this works, the calculation is performed when the record is updated. Also, when the record is first created, the “date_recorded” value isn’t available at the time the calculation is made because this value is set by the database server and the record hasn’t been stored in the database yet. (there is a workaround for this)

    What this won’t do is dynamically update the value every day, it only updates the value when the record is updated or changed.

    Thread Starter dalaho

    (@dalaho)

    I made the changes you suggested and I am getting some kind of result, but it’s not what I want. I’m seeking a solution that can display the correct value as soon as the page containing the table is opened. There must be a solution that allows the correct value to be displayed without needing to update or manually change the record.

    Plugin Author xnau webdesign

    (@xnau)

    OK, so what you need is some custom code so that the value is updated after the signup is submitted.

    I have some example code here: https://gist.github.com/xnau/aaa669e0cf9ea1e1478beb2cda0f2199

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How to show Numeric Calculation’ is closed to new replies.