Copy link to clipboard
Copied
I am creating a fillable catalog, please attached, there are 100+ items my idea is when the user clicks any product check box product ID, product and qty and cost, etc will auto-populate at the end of the catalog on the last page.
I have this piece of code but am not sure how to tweak it to work in my scenario.
event.value = 0;if (this.getField("checkbox1").value!="Off") event.value=500;else if (this.getField("fullpageadregular").value!="Off") event.value=700;
PS: I have the cost of the product which I can add to that column.
Copy link to clipboard
Copied
How can you auto-populate the quantity?
Isn't it the user's choice?
Copy link to clipboard
Copied
No meant to auto calculate the qty with price so whatever qty user input will be auto multiply by price which I already have.
Copy link to clipboard
Copied
Here is the update list with price of each item.
Copy link to clipboard
Copied
Hi,
Is it possible for you to share the page at the end of the catalog where you want to indicate the products.
Retrieving data from the spreadsheet when checking a box is not the most complicated. How is the last page of your document where the checked items should appear?
The difficulty of the script will come from the layout of this step!
@+
Copy link to clipboard
Copied
Hi @bebarth Thanks for your reply, actually end list of items when clicked on checkboxes is the same as the above screenshot e.g product, item, dimension, qty, cost, etc.
PS: One update is I am now using the same text boxes for qty boxes at the end of the list and at catalog with the same qty will reflect when user put qty so now there are no checkboxes just text boxes with the same name.
Copy link to clipboard
Copied
Is it possible for you to share your catalog or an abstract? This would be easier to understand how it was made.
I send you a personal message.
@+
Copy link to clipboard
Copied
Sure, here is the Link so please note that I am currently creating two same text fields with the same name one for the quote form and one for the catalog area for the user to put their desired quantity and calculate at cost columns and the price will be a simplified tab with textbox name * price but this process taking too much time as there are 150 pages with 600+ items in this catalog, so my question is there is a better way to achieve this results with less time?
Copy link to clipboard
Copied
I wrote a script to generate the quantity field always at the same distance on top and centered of the reference.
I need some catalog pages for checking the position of items. At the moment if I suppose the clearance between the reference and the quantity field is always the same, the quantity field is sometime over the picture.
Do you know if the position of the pictures are always the same on every catalog pages?
@+
Copy link to clipboard
Copied
Thanks for your reply and really appreciate it, as you asked the distance each time each other is different but I am okay with it and I can manually adjust rather than place them manually, here are some catalog pages in case you need to see.
Copy link to clipboard
Copied
Hi,
Here is my answer and how to use it from the file I'll send you via your personal address.
You will copy then past in your file the "GENERATE FIELDS" button and import the .csv file saved from your Excel file where I added (fictive) prices.
Then you will click on the "GENERATE FIELDS" button.
All fields will be generated at a fixed place according to the reference.
In the example I did, more than 1600 fields have been created on 124 pages in less than 1 minute.
Then, when you enter a quantity in the field then you go the the relative page of the list,
the price quantity and price will be indicated.
It is unfortunate that the layout of the catalog was not more rigorous, it would not have been necessary to replace the fields that come above the images.
I suggest you did a test on a copy of your file, then you will be able to modify some variables in the script to adjust the position of the fields.
@+
Copy link to clipboard
Copied
Hi @bebarth I really appreciate your hard work on this script, so I just tried to update the .csv file but was not sure how to edit the file so that I can update it to reflect the actual price?
also, is this possible to put a placeholder "QTY" on each field just like I previously had this is a kind of requirement from this person or this catalog guy?