0

Is there a way to have a calendar entry post to iCal only if record is unpaid?

I have a database that tracks my spending in several accounts, including upcoming repeating bills and paychecks. I have these bills/paychecks records populating into the calendar and iCal. I’ve tried various ways to limit the records that populate into the calendar and iCal to only those that are upcoming and unpaid, but in all instances, the records that are paid also get populated to the calendar and iCal, making for a cluttered and obnoxious mess of calendar entries that defeat the idea of the calendar being limited to unpaid entries only. Setting the calendar display formula to null for paid records still generates a “NEW ENTRY” in calendar and iCal. Does anyone have any ideas for how to accomplish calendar postings on only a select set of records in a table?

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 10 days ago
    • Reported - view

     

    You can use the settings in the date field "show as" as follows:

    if text(StatusInvoice)  != "PAID" then
        styled(text(InvoiceNumber) + " " + text(StatusInvoice), "red")
    else
        styled("", "white")
    end

    So only the paid Invoices are kind of "hidden" but still clickable....

      • brentjl1
      • yesterday
      • Reported - view

       Thanks for the suggestion, but the question pertained to iCal posts of dates/times. Your suggestion will sorta hide entries on the Ninox calendar, but in all cases of a record that is enabled to post to iCal, either a record is posted, or if using an if…then to check a status and using null as the post as definition in the case of a status that you don’t want posted, a NEW ENTRY with no other info is posted to iCal. I’ve been unable to find a way to selectively post to iCal, where selected records simply do not post. Any other ideas?

Login to reply

Content aside

  • yesterdayLast active
  • 2Replies
  • 30Views
  • 2 Following