Jump to content

skcombs

Members
  • Content Count

    12
  • Joined

  • Last visited

Everything posted by skcombs

  1. What does this error message mean: "Pivot tables cannot have more than 200 columns." I have specified 5 columns and 9 rows with 5 calculated values. If I try to add another column and calculated value, I see this message. The columns are fields that have Yes/No values, The calculated values are convert Yes values to number 1s and sum. In the resulting Pivot Table, I see a count of all the Yes values, a count of all the No values, and the totals. How can adding another column trigger the error?
  2. If I am inserting a new payment that has a payment date and a payment amount, I cannot know whether the payment date is the most recent date of payments for that loan. It could be that someone is entering a date that is prior to other dates in the payments table. I have triggers invoked when a payment is made or deleted. When a payment is entered into the Payments table, I thought I could update the MostRecentPaymentDate in the parent Loans table by saying MostRecentPaymentDate = SELECT TOP 1 from PaymentsTable. Payment Date, Order By PaymentDates (desc) in the Payments table. I'm not
  3. Situation: Parent LOAN table includes fields: Date, Amount, SumOfPayments, MostRecentPayment, MostRecentPaymentAmount Child PAYMENTS table includes fields: PaymentDate, PaymentAmount When a PAYMENT is inserted, the SumOfPayments should increase by PaymentAmount, and if Payment is deleted, SumOfPayments should decrease by that amount. Easy enough in a trigger. The problem comes in the MostRecent fields. I can create a TASK to reorder PAYMENT table entries by PaymentDate and then reset those fields in the LOAN table, and loop thru PaymentAmounts to recalculate SumOfPayments. B
  4. On insertdata trigger, I would like to set a text field to concatenate two #inserted text fields. Does anyone have an example or link to documentation?
  5. How kind of you for working on this, I am grateful. I will implement your suggestion. Your explanation is very clear.
  6. I have a table where the responses are stored as numbers. A lookup table has the pairing of labels to numbers, and the labels are used for the radio button responses. One reason for this is that I want to compare the rating a respondent gives to each question over time to the same question.
  7. In a survey, I am using a Likert Scale of 4 values (Strongly Disagree -> Strongly Agree) to answer several questions on a submission form. I would like to create a Pivot Table with questions on one dimension, scale names on the other, with a count of User-Ids as the values. How do I use the scale values (Strongly Agree...) from a lookup table to specify the rows (or columns) ? ALSO, I kept getting an ERROR when I submitted this question telling me to try again, so Sorry for the multiple submissions.
  8. I had the same problem in Wordpress v3.xxx. I tried this suggestion to wrap the embedded Caspio code in a div, where I set the width to a percentage. And you need to disable RESPONSIVE on the datapage. But it still failed because Wordpress stripped out the div tags in my HTML code. <div style=”width: 100px; height: 100px; overflow: auto”> <!–Embedded Deploy Code–> </div> If that is what you see too, then edit your theme's functions.php and add this function to stop WP from removing div tags, and other tags as well: // stop wp removing ALL Html tag
  9. I had the same problem in Wordpress v3.xxx. I tried this suggestion to wrap the embedded Caspio code in a div, where I set the width to a percentage. And you need to disable RESPONSIVE on the datapage. But it still failed because Wordpress stripped out the div tags in my HTML code. <div style=”width: 100px; height: 100px; overflow: auto”> <!–Embedded Deploy Code–> </div> If that is what you see too, then edit your theme's functions.php and add this function to stop WP from removing div tags, and other tags as well: // stop wp removing ALL Html tag
  10. In parent table, I use prefix autonumber as identifier, named ID. In child tables, the identifier is to inherit, so I use same identifier name, ID, but as datatype string. (1) Now, I want to create datapages for a submission form that will use fields from the parent form and pass the identifier to the datapage for the child table. In the child form, I hide the identifier ID but use external, with parameter InsertRecordID. After submitting the form, I am actually seeing "@InsertRecordID" as the entry for ID in the child table. (2) The child table is in a one-to-many relationship w
×
×
  • Create New...