Using CSV Data Source

  • Resolved aderal

    (@aderal)


    3 years, 2 months ago

    Hi!:)

    I recently got the Developer version of this plugin, awesome work DEV Team.

    I’ll try to explain my issue and see if you can help me.. I’m building a financial simulator based on an Excel I received and there’s step I need to calculate using an external database in CSV.

    The CSV has 2 columns: date / days. The first column is the date of a country holiday, the secondo column (days) contain the number value I need to sum in my equation.

    Now let’s step back. I have the following formula:

    IF(WEEKDAY(fieldname3+30,”dd-mm-yyyy”) == “7”,fieldname3+32,IF(WEEKDAY(fieldname3+30,”dd-mm-yyyy”) == “1”,fieldname3+31,fieldname3+30))

    fieldname3 -> it’s a dynamic date field that the user choose.

    This control I’m doing is “if current date + 30 is equal to saturday make +32, otherwise check if it’s sunday then +31. If all false, just +30.

    Now the point: I also need a last check that is “check if date+30 is equal to a record ‘date’ on the CSV table, if does sum the value ‘days’ of that table.

    It’s tricky and I’m not sure my explanation is enough clear…just I still don’t understand nor found a complete documentation regarding the use of external data source and all its fields.

    Hope you can help me with that!

    Thanks in advance,
    Davide

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @aderal

    We’d like to help but we can’t reply about that in this forum. We are not allowed to support any customers in these forums.

    For pro or commercial product support please contact us directly on our site. This includes any pre-sales topics as well.

    Commercial products are not supported in these forums. We will happily answer this and any other questions you can have on our own site.

    However, if you need to read about the use of DS fields with the CSV files, please, visit the following link:

    https://cff.dwbooster.com/blog/2019/02/14/ds/

    Thank you.

    Thread Starter aderal

    (@aderal)

    You’re right! Thanks for the quick reply and sorry, I didn’t realize about the policy here.

    Cheers:)

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Using CSV Data Source’ is closed to new replies.