ronbrumbarger

Thank you @NailDyanC!!

THANK YOU! This was most helpful. Sorry for my late response...

I'm always amazed at how many smart people are on here... Hopefully one of you have a minute to help me out... I have a table with two UserIDs: DebitID and CreditID (think the perspective of your bank - debits to your account reduce your balance). The table also has an Amount field. The logged in user (authfield:UserID) may have sent (Debit) or received (Credit) an Amount. If they sent money, the DebitID field equals their UserID and User's ID to whom they sent the money would be identified in the CreditID field. My challenge is I need the SQL statement to generate a "total balance" from all transactions where... Here's my JS kind of equivalent code. var AccountBalance = 0; if authfield:UserID == field:DebitID AccountBalance = AccountBalance - Amount else if authfield:UserID == field:CreditID AccountBalance += Amount I hope ^ is legible and one of you smart people out there can lend a hand. Thanks - Stuck!

Private message with credentials sent.

I have a form and have added an event listener exactly as above and as described in the Caspio help. I have the same form as outlined by Alexray above, but I cannot get the form to not submit. I even have the exact code as above. Help me out? How do I get the form to *not* submit? What am I missing?

WOW @TellMeWhy I owe you a dinner! THANK YOU. I'll give your approach a try. That took some time - much appreciated. What city do you live in?

Thanks again @TellMeWhy They are separate tables. The time entered is not a checkbox, but the actual start/end times for an employee's work day (or portion thereof). It's a record in the time entry table; assuming it is present. If it's not there, the query is empty - hence my first step of building the Employees object/array. While looping through the employee table, how would I go about querying the time entry table? Mind you, this is intended to be automated (as per my post above) as I don't want to have to run this manually every night.

Thanks @TellMeWhy - I appreciate the response. I'm familiar with tasks, but they're looking for records that exist... not seeking to find those that do not. My problem is I have to see who has not yet journaled their time for today. Am I missing something? Ron

Hello friends, I am building an application that looks through a list (view/query) of employees, builds an array of objects (Employees), then spawns (window.open) a new datapage/window and shares the Employees object/array with the child window. The child window/datapage invokes another query into a time entry database and looks for all time entries for today. My Employee object looks like this: name = employee name id = employee id # phone = employee cell # check = boolean / status of a time entry for today or not In the child datapage/window, a report is created retrieving all time entries from today. With each record, I loop through the Employee array looking for a matching employee ID. If a match, I set the 'check' attribute for that employee to true; time entered for the day. This approach basically enables me to look for records in the time entry table that are not present (yuck). At the conclusion of looping through each time entry record for today, in the 'Footer' of the datapage, I loop through the Employee array and for each entry where the check flag is false and send an SMS. I want this process to run every hour from 7:00 pm until 11:00 pm every evening Monday-Friday. This "nagging" application will message employees who have not entered their hours worked that day. (READ: Our staff is tired of nagging reminding employees to enter their time - imagine that!) I think I have the Twilio SMS API on the verge of success (check back Monday), but my vexing problem is this: **** How do I initiate running the initial datapage which creates the Employee array which starts the cascade of events? **** Or... am I full of mud with my approach and should throw it away for a more elegant solution? Any of you geniuses out there have an elegant answer to this? Zapier? Scheduled tasks in Caspio? Help a guy out? Thanks - Ron

Using the Caspio functions in a "Formula Field", I'm trying to use the "Display Value" from an associated table/field. For example: Table: Customer CustomerName - type text CustomerID - type integer Table: Contact ContactName - type text CustomerID - type integer -> points to Customer table The tables are are "related" and the CustomerID field in the Contact table is using the Display Value of CustomerName Question: In the formula field, how do I access the CustomerName?

Thank you @AtayBalunbalunan. My account doesn't have Tasks enabled... Aside from that approach, might you have another idea?

Hello - This has surely been addressed on the boards before, but for the life of me, I cannot find such... I want users to be able to login to an app with the "timeout" of 7 days and NOT have to login again when accessing the same secured page until the expiration of that window of time, even after the browser is closed. My "time out after" setting is set to 7 days, but I'm not sure this is the right way to set this duration or if that's the intent of this setting. Help a guy out? Thanks!

Yes, same here. It's maddening. The issue is that the modal dialog boxes pop up in the center of the active window, NOT relative to the CKEditor's location on the page. It's frustrating and a setting changed on the back end of Caspio, but they claim there's no such change. It just happened to start happening one day to my applications without any changes on my behalf. @caspio

Thank you, @Franchiser I'll give it a try! I appreciate your help.