Simple list of items and add-on's to a total price?
I would like to create a simple form that a customer could make several choices and see the total price. Question 1. A dropdown list of sizes of a product available. (10x10 = $100.00) (20x20 = $200.00) (25x30 = $230.00) Question 2. Optional Paint Color (Red + $2.00) (Blue + $1.00) (White + $0.00) Question 3. Optional Clear Coat (yes) or (no) if yes add $5.00 Total ________ = (Selection 1 + 2 + 3) Submit button would forward the selections and the total price to an entered email address? Can someone
Decimal fields in Pivot Tables and Charts
When I try to create a Pivot Table or Pivot Chart report, only certain types of fields are available. Specifically I need to use the decimal fields from a View, but none of these fields are available to select.
Rename uploads automatically?
Hi, all. I'm researching the possibility of using Zoho Creator to organize an academic conference. I'd like to know if Zoho Creator has a way of automatically renaming files as a user submits them (or else batch-renaming all the files at once). In the past, we have manually collected conference submissions as email attachments and then numbered them by hand, associating those numbers with a last name in a Google Doc. With hundreds of submissions, this is a laborious process. But, if each user could
Problem sending automatic emails
HI! in one app i built, i use an auto-send-email function, which sends a message to an address belonging to a person who is assigned a task (i.e., "To: input.assigned_to"). it works perfectly well. in another app i tried to apply the same function, but the Creator seems to add ".toString()" at the end of the code ("To: input.assigned_to.toString"), thus causing the code to fail sending the email. no matter that i delete this addition and save it to the code - when i re-access the app, the change
Script function editor: show full function name
I create custom functions and starting to get annoyed by the function names being cut off, see screenshot below. My suggestion would be to show the full function name. I don't mind if the name wraps around as long as it is not cut off.
Displaying subform results as sets
Hi, My suggestions would be to display subform results by a set number of result eg 1-10, or 1-20, etc. This will allow users to see a small subset of the subform results and increase page load times. I have many instances where I have 100+ subform rows and raised an issue about slow performance at https://help.zoho.com/portal/en/community/topic/form-load-is-very-slow#2266000004566169 Zoho, can you please implement the feature to improve page load times? Thanks
Script name change
When I change the script name of a field or eliminate it, Creator doesn't recognize the change. I have to exit Creator altogether and restart.
field-level view&edit access in creator app?
hi there is about 10 fields in app and 1 manager and 1 supervisor who works with app how make view (access for viewing&editing): only fields 1,2,3,4,5 - for manager all 10 fields - for supervisor ?
Filter rows and then batch-download attachments?
Hi, all. I'm researching the possibility of using Zoho Creator to organize an academic conference. We plan to have users upload their submissions to a central database, where we will later blind the filenames and assign them to referees. It would be great, once the referees were assigned, if we could run a report that would filter all the rows in the database that match Referee X and then download all of the file attachments from those rows at once to ZIP and send to the referee. The alternative
Educational pricing for Zoho Creator?
I'm researching the possibility of using Zoho Creator to organize a conference at my public university. I understand Zoho Creator has a free tier, but I would like to know if they have discounts on the higher tiers. I think the next level up would be perfect for our use, specifically because of the higher number of reports that tier allows. Thanks for your time! Ryan
One entry per drawing number
Hello, My problem is kind of like a "no duplicate entries" option but it needs to be a bit more complex and I am hoping someone can help me out. I have a form called Operation and there are two look-up fields; 1 is called Customers the other is called Drawing no. The user selects a Customer and then a drawing number [which is filtered by the Customer selected] then the user enters in the operation number which is a number valve. My question is how do I make sure that the user can't duplicate an operation
Button in Zoho creator view/report.
Hi All, I was looking into marketplace to get idea on designing my application. The first application i found is "Order Management". In some of the reports (views), it has given button to perform some actions. For example in "Pending delivery", it shows list of items, which needs to be delivered. For each items, it has given one button called "Delivered". When you click on button "Delivered", the entry will moved from "Pending delivery" view. I want to implement same where in in my form view called
Collection variables and formula fields...
Thank you for your help. I am trying to use a collection variable to bring field values form one form to another - one them is a formula value. I have been able figure out the collection variable (I think) Some values (publication) will come over but not the formula value (insertion cost). Here is the script written: PropPub1 = LUX_Enrollment [Street_Address == input.Prop1]; if (input.Prop1 == PropPub1.Street_Address) { if (PropPub1.Pub1 == "") { PropPub1.Pub1 = input.PubNameLPC;
Where is the Customize Theme feature in the new builder?
Folks, I am reading the article on Theme customization using the following link: https://www.zoho.com/creator/help/customize/theme.html But in my new App Builder under Setting -> Customize section, I am not seeing the "Customize Theme" option. Is this option only enabled for paid user? I am using the free version for now. Any input will be greatly appreciated. Thanks.
Need to replace Null with 0 in formula
I am struggling wiht a probably easy solution. I have 2 fetched fields (decimal) that I need to divide. input.pubcost/input.allocation if there is no returned value I need the field value t to be 0 not null. Can anyone advise of the solution? Thank you.
Exporting data from reports to a Letter template
Hi, I'm looking for a way to export data from my reports such as <First_name> and <Last_name> in order to create a personal printed letter that I can then post. Thanks
Embedding a report without displaying menus and edit features
I have no technical knowledge and do not understand the majority of what I am reading. I have report embedded on my site (iframe). Someone set it up for me so that only the records of the person searching are displayed, while suppressing all records not belonging to the person searching. Everything works fine - but, when the report displays it also shows all of my menus and edit options that the person can see and click on. I only want them to see their results - not all the administrative options
Page boarders using permalink
Is their any code that can be added to the permalink to set margins. I'm working on a form that will be accessed through smartphone 99% of the time and it looks like the left/top margin is around 6 - 8 px. Not only is screen space important it also leaves the form looking of center as the right margin is about half that of the left.
Form security breach
I created a form SITE_ADDRESS and have not shared it yet. I have a SITE form that lets users pick a SITE_ADDRESS with an option to add a new site address if it does not exist. However, users are able to add new site addresses even though I have not shared the SITE_ADDRESS form yet. Why is the form not being restricted? How come users can see the "Add new site address" link even if they do not have privileges. I am hoping to restrict the form to a specific group but it appears anyone who can access
The lookup field type is long() , not String() ?
Please check.
Issue about Richtext.
An issue occurred after disable Richtext in Layout "Pane Left"or "Tabbed Pane left". Please see the screenshot. Please fix it asap.
Forms or views embedded within html views are not shown
Hi, I had created some html views with embedded forms and views. They worked fine until i used the old app builder.Now they are not shown when i am using the new app builder. I think it might be bcoz of the new app builder or bcoz of some update or fix. Please update about it this issue. Abhishek
View attachment in subform
Hi, I have encountered a problem when using Subform. I created a Subform that allow user to attach any number of file attachment. For example, if the user want to attach only 1 file, he just need to add 1 row and attach the file; if he want to attach 3 files, he need to add 3 rows etc.. Now the problem is: after the user attached the files in the subform and submit successfully. When the admin is checking the record in a list (or summary) view; the admin can only see the name of the attached files,
Images from iphone too big
Hi there, Just created form to use from iPhone. When I attach an image from iphone into form, the form will not upload to Zoho server. Red error message says that image is too big. Anyway to reduce size of image prior to attachment ? What image size is preferred ? THanks Jai
Scripting "On user input" for Subforms and a Bug
My subform contains a dropdown field. I want a textbox in the subform's same row to display a value depending on what the user selects in the dropdown. Clearly the "on add row" is not where to put this code. So I selected "configure filed actions" from the form builder: And it loads a page that is totally not editable. If I hit the "free-flow scripting" button, nothing happens. I did note the url for this strange page is: creator.zoho.com/appbuilder/sigroup/lab-audit/form/Audit_Form/Audit_Findings/workflow/edit#OnUserInput
Invalid entries found. Please correct and submit again
I am getting this error on specific entries only Please take a look at the application and let me know what to do! For "Owner to Trade With" when Mitch is selected, Martin Prado causes the error message https://creator.zoho.com/wetalkfs/trade-machine
Code Editor downgrade?
Is it possible to downgrade the latest upgrade in the Code Editor via some user preference? All of this gradient, fading, animation, ghost text is very difficult to work with. I like the color coding and the line numbers. But I think Zoho went way too far with the eye candy animation. Tony.
Catch error thrown by built in functions
Hi, I would like to know if there is any method to catch or find if there is any error thrown during the deluge script execution and handle the same? Basically I am looking for something like a try-catch block. Any alternative will be appreciated. Scenario: Parsing input text into date time format using toTime() function
Regular expression - return expression
I want to extract the street number from a street address. I know that zoho supports using regular expressions to match and replacing strings. Can zoho support extracting strings and returning them?
Code Suggestion to Get Date for Previous Thursday
Greetings all... Any quick code suggestions for calculating the correct date for the previous Thursday from a certain date.... Ex: The date given is Tuesday, August 20, 2013. What is the date of the previous Thursday? I know there has to be some use of the varied date functions here but I can't seem to get my mind around the correct logic. Thanks, Joel
Regex for a Date Time Expression
Hi, Can anyone help me or has anyone in the past worked out an expression that could match the following date time string: dd-MMM-yyyy HH:mm:ss i.e. "12-Mar-2013 13:52:30" Thank you, Guy
Notice of not secure web page in Zoho Creator Application
One of my application (on going development) has this this notice: What does it mean and how to deal with this? Thanks!
Creator Graphs can be so powerful !
Whilst the Report capability within Creator appears quite basic, it can still be very powerful. A simple 'Stacked Bar Chart' can provide my user with a simple yet powerful interface to easily review the data they need access to without having to review long reports. However, I am still unclear as to the mechanics within Zoho that executes the 'regeneration' of report data. I display some of my reports, via a HTML view with a 10 minute refresh, and sometimes the data displayed is not always up to
Modify radio button field names
I have a DB with 1000 entries. I just tried to modify one of the selectable field names. There was a radio button list of say Apple Banana Grape That I modified to 1 - Apple 2 - Banana 3 - Grape Now the fruit column in my table is blank. Is that data gone, or listed incorrectly or what. Any help would be greatly appreciated! I think I am in trouble.
Re-posting: Issue with new application builder's look-up feature
My app has a number of forms that have look-ups to a database of room names. Thus, records submitted pull these room names using the look-up. The reports of these records show the room names as expected. However if I try to write any code to reference a room name, only the ID values of the room names are available, not the text versions. How can I write any functions that have text value inputs when only ID numbers can be referenced? Here's an example
Advanced Record Security
I'm just passing along an advanced tip I recently implemented on an application. I had the need for more than the just the zoho.loginuserid to view and edit a record, but not everybody. I created a text box field to hold a list of emails: And populated it using another form. Viewing the record it looks like this: For the view (now called report in the new builder) I added criteria that enables the record creator OR anyone on the "admin_list" to view and edit. All others see nothing. Hope you like
Record Template (New App Builder)
In the new app builder, under form settings, I found "record template". It is described there as "A Record Template allows you to create beautiful visualization of your data. Some uses include estimate, brochures, certificates, newsletters, campaign mails, visiting cards, product phamplets* etc" So I made one and it looks like this: Please explain how I can use this to present my data? *spelling error
Creating a view
In zoho Creator with CRM: Is it Possible to have a view that doesn’t need à form but only a view that calculates automaticly many fields (from another Tabs… like the amounts of the potentiels Tab)?
error occured please contact application owner
Hi Zoho, I am facing an error on my application on Zoho creator. The user fills in all of his/her data and clicks on 'submit'. Once that happens this error message pops up 'Error occurred please contact application owner'. However, the data has been trapped in the database. The user doesn't know this and tries to re-enter the data, causing multiple entries. Can you please help? I can give you access to the application if required. Naveen
how to create a login for affiliates to check their commission earnings
Hi, I have a real-life Business Scenario that Calculates Sales commissions in Zoho Creator App, such as in this example: https://www.zoho.com/crm/help/automation/webhooks.html#Business_Scenario1 The commissions calculated belong to affiliates, and since affiliates are not staff members, we do not give them staff login access to our Zoho CRM/Creator. However, they would like to be able to log into their affiliate account (the above app) and check what their commissions are to date. Question: How do
Next Page