I'm new to Caspio and trying to figure out if/how it might do what I need to create a version of my Access app online. Not using VB code or creating regular queries is a bit confusing to me so I was hoping that if I put a specific scenario up in the forum someone might explain if/how to do it here. This would help me extrapolate to other scenarios in Caspio.
I have a table for 'Invoices' that uses a field called 'Invoice Display' to show the invoice number. This isn't the unique 'primary key' (InvoiceID) used in relationships and linking. It's just an editable text field for an alphanumeric value that shows/displays the desired invoice number on printouts.
What I need to do is, when a user creates a new invoice, have it auto-number populate to the next highest number in 'Invoice Display' BUT also be editable to any alphanumeric value the user may want. This is because half my customers want to use the internal auto-number system to come up with invoice numbers but the other half wants to be able to overwrite that number with their own custom alphanumeric numbering system.
For example, if the highest 'Invoice Display' value is 545 then when the user makes a new invoice it needs to show 546 in the new record's 'Invoice Display' field. But then the user may overwrite that and type in something like 546CA.
On the next invoice creation I need to be able to 'pull' the 546 out and autonumber-populate the new 'Invoice Display' value with 547 (which the user can overwrite if they want).
This way it accommodates both auto-number and user edited scenarios, sometimes within the same customer account.
In Access I can use an expression in a query like Invoice Display: (Val(Nz([invoice Display]))) and then do Max +1 to show the next number. Is there a way to do something similar in Caspio, and if so, can someone put the basic steps, as I'm just starting out here? Many thanks in advance!
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
DesiLogi
Hello,
I'm new to Caspio and trying to figure out if/how it might do what I need to create a version of my Access app online. Not using VB code or creating regular queries is a bit confusing to me so I was hoping that if I put a specific scenario up in the forum someone might explain if/how to do it here. This would help me extrapolate to other scenarios in Caspio.
I have a table for 'Invoices' that uses a field called 'Invoice Display' to show the invoice number. This isn't the unique 'primary key' (InvoiceID) used in relationships and linking. It's just an editable text field for an alphanumeric value that shows/displays the desired invoice number on printouts.
What I need to do is, when a user creates a new invoice, have it auto-number populate to the next highest number in 'Invoice Display' BUT also be editable to any alphanumeric value the user may want. This is because half my customers want to use the internal auto-number system to come up with invoice numbers but the other half wants to be able to overwrite that number with their own custom alphanumeric numbering system.
For example, if the highest 'Invoice Display' value is 545 then when the user makes a new invoice it needs to show 546 in the new record's 'Invoice Display' field. But then the user may overwrite that and type in something like 546CA.
On the next invoice creation I need to be able to 'pull' the 546 out and autonumber-populate the new 'Invoice Display' value with 547 (which the user can overwrite if they want).
This way it accommodates both auto-number and user edited scenarios, sometimes within the same customer account.
In Access I can use an expression in a query like Invoice Display: (Val(Nz([invoice Display]))) and then do Max +1 to show the next number. Is there a way to do something similar in Caspio, and if so, can someone put the basic steps, as I'm just starting out here? Many thanks in advance!
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.