Bernd Krell
-
Convert "Credit Term" to Date plus credit term
Hello. I have 2 fields. CREDIT TERM (number field) DUE (date field) If I add 30 (or any other value) into the CREDIT TERM field, I want the DUE field to auto-update to 30 days from today.…
- Answered
-
Copy table including line items from subtable, to another table and subtable)
Hello everyone. I am trying for a few days to get this working but am stuck. Maybe someone can point me in the right direction. I have a table "Quote" and it has a subtable "quLineItems" where I add…
- Answered
-
Send email and include only fields with value
Hello. I do want to send service reports to customers. I have a code which works fine (see below) but I would like to exclude fields from the text in the body of the email,…
-
Copy contents of reference link to another field.
Hello. The "Select" field you see in the screenshot is a "Link to" reference. My intention is that whatever is selected, should be copied over to the "Description" field (text field).…
- Answered
-
Running number issue
Hello everyone. I've setup running numbers for our stock, invoices etc. That does work as intended. However, if any previous record is deleted, the next number created will be a duplicate.…
- Answered
-
Show value of line items depending on the choice field selection
Hello everyone. I have created a formula field to show the current total of our Petty Cash which is in a subtable. This needs to exclude amounts which were transferred to/from a bank.…
- Answered
-
Update Reference field from Text Field
Hello everyone. Assume I have 2 tables. 1. Customers -- It includes a field named "Company Name" 2. Service Reports -- It includes a popup field named "Customer" where I can select the company name…
- Answered
