Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


wvantongeren last won the day on June 23 2016

wvantongeren had the most liked content!

About wvantongeren

  • Birthday 12/14/1956

Recent Profile Visitors

804 profile views

wvantongeren's Achievements


Newbie (1/14)



  1. It's in normal text in a Word document: 01 Algemeen, opleveren, garanties en tekeningen 00.03.01 Constructieve veiligheid <- here I want the hyperlink: 01.02.22 Garanties <- here I want the hyperlink 01.02.A Oplevering woningen 01.02.C Oplevering installaties 01.03.02 Brandveiligheid 01.05 Tekeningen 01.09.01 Renovatie woningen I uploaded also 2 PDF-documents 00.03.01-Constructieve-veiligheid.pdf 01.02.22-Garanties.pdf
  2. Hi all, I try to create a hyperlink in a Word document to a pdf file. Nothing I tried works. In my Word document I have the following text: 00.03.01 Constructieve veiligheid 01.02.22 Garanties 01.02.A Oplevering woningen 01.02.C Oplevering installaties 01.03.02 Brandveiligheid 01.05 Tekeningen 01.09.01 Renovatie woningen the above items in my Word document must be linked to a pdf file saved in my table When I try to open the pdf "00.03.01 Constructieve veiligheid" file with Google: https://c1esh889.caspio.com/dp/d8564000dadcf2b020d94c098608/files/5784369 it works. When I make the Hyperlink in a Word document it dont work. Link to my Report: https://c1esh889.caspio.com/dp/d8564000dadcf2b020d94c098608 See also the Picture of my table:
  3. Hey all, I have a question. In a Submission Form I select companies with a Radio Button. The selected companies were previously submitted in another Submission Form. Once selected, I want the selected company to disappear visually only that day. The next day the selected comapany must be there again. Test it yourself: https://c1esh889.caspio.com/dp/d8564000553fcadd78024278a937 Thanks.
  4. Andrew, Thanks I'm going to try it out. I will let you know when I am ready.
  5. Hi all, Does anyone have experience with Daily Stand as attached. I would like to make a program for this Greetings from the Netherlands.
  6. Hi Vanallope, I solved my problem I was counting with text instead of numbers, stupid. Don't try to smile
  7. Hi, Nothing works! Previously, I applied this to other DataPages: SELECT (Artikelprijs) FROM Betontechniek_Bonnen_Producten WHERE Artikelnummer = 4000 And SELECT SUM (Werk_uren) FROM Beton_Bonnen_Daguren_1 WHERE Werknummer = target.[@field:Klus_Werknr] It's still working. If I change the last code (I want to count how much rows ther are with the same OfferteNR) in: SELECT SUM (Teller) FROM K_Schadekenmerken_Data WHERE OfferteNR = target.[@field:OfferteNR] it does not work, see a piece of my table and error message. Table.pdf
  8. Hi all, Whats wrong with this code? SELECT sum(Teller) FROM K_Schadekenmerken_Data WHERE OfferteNR = target.[@field:OfferteNR] Greatings from the Netherlands
  9. wvantongeren

    Check date

    Hi all, I want to check 2 dates for a machine control program. In my table I have a field "Laatste_visuele_test" thats the last date the machine is checked. Now I want, in a calculated field, to know the difference in days : "To day" - "Laatste_visuele_test" The result can be + days or - days. Thanks and greetings from the Netherlands
  10. Hi all. I have a table with over 40000 records. All records have working hours per day. I try to find out what the first and last day is for closing projects. So I'm looking for the first and last day. 129/5000
  11. Hi all, I want to do the following: In my Report Tabular I show building projects. If the checkbox "Actief" is Ja the project is live, otherwise "Actief" = Nee, the project is ready and closed. When the project "Actief" = Ja then I want instead of Ja "Go to the project" with href='https://c1esh889.caspio.com/xxxxxxxxxxxxxxxxxxxxx' See also https://c1esh889.caspio.com/dp/d856400060880bba71bc4e1d8594 How can I do that?
  12. How to separate number, In a calculatedfield I only use the second digit, like: the number = 35 I only want to use the digit 5. I now have (only) this in the calculated field: [@field:Firstnumber]*7 (in my case thats 5*7) = 35 Thanks
  13. Hy all, I want to sent a notification email on stored dates. The customer always receives a email 30 days before he must be done something. The date can be over (84 days - 30 days) 7 weeks (1095 days- 30 days) 3 years and over (2190 days- 30 days) 6 years The dates are stored as: -A1_date; (84 days) -P1_date; (1095 days) -E1_date: (2190 days) Ther is no option for not receiving a email. Please help!
  14. Hy all, Can I do something like this, to store my score in the table? UPDATE [@field:Score] (this is the parameter) SET Score = (this is the fieldname) CASE WHEN [@calcfield:2] < 75 THEN 5 END Thanks
  • Create New...