Jump to content

yaron

Members
  • Content Count

    30
  • Joined

  • Last visited

Community Reputation

0 Neutral

About yaron

  • Rank
    member
  1. thanks but can I do it in the same table?
  2. thanks. found and did, It worked.
  3. I have created a script using Scripts-> Script maker. how do I attach it to a button? thanks.
  4. Thanks, I just figured now how to write this script. How do I attach this script to a button, meaning how do I add it to the list of scripts so I can choose it on "Button Setup" ?
  5. Hi. I want to have a certain summary field in a record/table the summary should be like the sum of all records's field "amount" where field "deal_id" equals that record's "deal_id" field. I couldn't find how to do so in the basic sumary field options. thanks for your help, it is really important. yaron.
  6. yaron

    Verification field

    thanks. Good idea.
  7. Hi guys, and good morning. I have a small question hopefully Ill get the answer. Id like to create a button for "Next record" but I want it to take me not to the exact next record but to a record a head where a certain field's value is > 0. I tried several options and couldnt make it work . thanks. Yaron.
  8. Can I create a field that requires that the user will re-type the input for verification? Im talking about field like in password when most of systems ask the user to type the same password twice to make sure he doesnt make a mistake. Thanks. Yaron
  9. yaron

    portal as a ledger

    ok I created the join table named "journal" I will be able to make my report from that table I guess. but still have question about how to connect it to the other 2 tables. I want that when I enter receivable in the "receivables" table - I will automatically get a record in the journal. but it doesnt work. (the connection between them should be orderId)
  10. yaron

    Ledger report

    I want to create a ledger. I have 2 logical tables. Checks Due (amount, date) , id, forign key. Checks Received (amount date) , id, forign key. both of them have foreign key that represent a deal (where the money should be arriving in several payments) and I want a ledger to be created. where the lines are sorted by the date order. and I would have a total down at the bottom (or even a balance field on the right of the line) can I do it in a report? should I combine the "receivables" & the "received" tables into one table? I really dont want to do that.
  11. I hope this question is for the "portal" subject but Ill ask it also in layout. I want to create a ledger. I have 2 logical tables. Checks Due (amount, date) Checks Received (amount date) both of them have foreign key that represent a deal (where the money should be arriving in several payments) and I want a ledger to be created. where the lines are sorted by the date order. and I would have a total down at the bottom (or even a balance field on the right of the line) can I do it with portal? can I do it in a report? should I combine the "receivables" &
  12. Field Control-> Behavior -> goto next object using check the "return key" in that way when you press return it will just go to the next input field.
  13. yaron

    lookup value list

    well the solution was to leave the "include only values from related data" radio button - selected & with "unknown"
  14. yaron

    lookup value list

    Im getting confused between the database/value list declaration & the layout building. In the layout - there is display data from & display values from. what should I put in each of them?
  15. yaron

    lookup value list

    Not yet solved - I made the relationship between the fields (draging one to the other and now I see in the graph the relationship) but when declaring the value list -> use values from field - here I put the field from the table A (the one from where I need to take the data) and what shoukd I put in "Include onlt relevant values from" drop down? the second table I guess. but it doesnt work.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.