Javascript can't handle Zoho Field ID from REST API
Zoho REST API returns an ID field for each record. Unfortunately Javascript (confirmed with Chrome 69.0.3497.81) can't accurately handle the field, I presume because it's too large to fit into a Javascript 'int'? Reproduced here: https://jsfiddle.net/cx8z9dhv/ Any suggestions?
Creator: Report Criteria for Select Users
Hi, Is it possible to set criteria so that the logged in user can only see records in the report that have been assigned to them? Note that they are not the addeduser as they did not create the record. I've tried: Assigned_Case_Mgr == zoho.loginuser But since not working, assume this is because the two names may be appearing differently, ie the zoho.loginuser = joebloggs and the Assigned Case Manager = Joe Bloggs. Any suggestions?
Web Tab Titles
Hi Everyone: In our use of Zoho Creator we have many web pages open at the same time. It would be a great aid to navigating between the different pages if the page title in the web tab could be customized to tell the user which form, report, or page, was on which tab. Is anyone aware of a method to do this? i attempted the <head> <title> method for one of my html pages but that had no effect. Many thanks, Dave
add lookup values dynamically
I currently have this code to add lookup values to lookup fields on my form dynamically. It works well, the only problem being that it resets the value of the field to null. I don't want it to erase what values might already be there. I currently have this: Locs = Locations[ID != null].ID.getAll(); Trip_From:ui.add(Locs); anyone have any ideas? i tried this workaround: Locs = Locations[ID != null].ID.getAll(); myvalue = Trip_From.iD; Trip_From:ui.add(Locs); Trip_From = myvalue; It works, but changing
Prevent workflow execution on API update
How can i prevent workflow execution on API update? the workflow is create to execute on Update and i need to prevent it happening during API Edit. what are the possible solutions?
Round-Half-Even (Banker's Rounding)
I'm trying to come up with the algorithm to round a number with the half-even method since the default round formula in Zoho Creator uses the standard Round-Half-Up. See here: https://www.eetimes.com/document.asp?doc_id=1274515#A2 The problem is my app is integrated with my accounting software, which uses the banker's rounding method, and as a result I'm getting conflicted values. Anyone has experience with using different rounding methods in Zoho?
How to create form by using Deluge in Zoho creator.
I have a requirement to create a form using Deluge. It would be possible? If yes then, what is the steps to follow? Please suggest syntax as well.
phone number field
how do i format a field to accept only a phone number in that format like (000)000-0000 ??? thx, sarah sjohnson
Adding Multilist options to a drop down list
Hello, I have a form called Job Data which contains and ID and a Operations in the form of a Multi select List. And then there is another form Planning which also has an ID and a Operation but in the form of a drop down. First the Job Data is Filled and Submitted. When the ID is put is in the Planning form, I want the Multiselect List in the Job Data form appear as a drop down in the Planning form. Can this be done ?
View and sign an added file
Hi what i want to achieve is to upload a PDF through the file upload allow the user to view the file and digitally sign and then saving it to the form to submit it. If anyone knows how to view the uploaded file that would be very helpful Thank you Amanda
Zoho Creator integration with zoho sign
Hi I would like to integrate zoho sign with zoho creator. Ultimately what I need is a signed PDF If anyone can help me with this i would be very grateful Kind Regards Amanda
2/3 column view
Hi, any chance to have 2/3 column view in Zoho Creator form? J
Get calendar date
When i click on my calendar report, i would like the form to open, with the date field autofilled to the date i clicked on the calendar. Is this possible?
Execute function, update fields in response to Button click in Add Note field
Hi guys I want to add an HTML button in an Add Note field that calls a custom function (which calls an external REST API). The function returns a List of data which I want to populate a drop-down control. Is this possible? Thanks
Autofill a Lookup
Hi there, I've got a report with my customer portfolio. When I swipe left (or right), it runs a workflow: openUrl("#Form:New_Event?Customer=" + Customer_Name,"popup window"); This workflow opens the Form New_Event. Also, I would like that autofill the field "Customer" that is a Look Up from the form "Add_Customer" "Customer" field is a dropdown, and it's not a string, so the code above doesn't work... Any idea?
FInd and Replace
Is there a Find & Replace feature in Creator similar to all word processing programs ? I want to highlight a certain word (s) and replace it with another word or phrase, across all the records in a database.
Need Subform Field to Populate Based on Parent Form Field
I have a form with a subform. This is done to create a one to many relationship. The main form is Vendor and the subform is Vendor Account Number. On another form I enter the subform Vendor Account Number and want the Vendor Name field on that form to be filtered for the Vendor Name from the Vendor form based on the Vendor Account Number selected. The only way I've determined this can be accomplished is to include the Vendor Name in an additional field within the Vendor subform alongside the Vendor
How to force text to be upper case in a field?
Hey guys, I'm really starting to enjoy Creator and putting my database/forms together. However, I have another question: How can I force all text to be upper case? This field will have a mixture of text and numeric characters. Oh... and how to not allow special characters? Thanks, Joe
All Caps (Uppercase) Actions on User Input LOOP
Hello All, I am wanting to have all the text in a user input field converted to Uppercase. The following does the trick, but then I get a endless revolving arrow icon next to the field. This tells me that it is in a loop replacing the same All Caps data. How do I get the loop to stop. I hit the ESC. button and the revolving icon does stop. Is there a way to have it stop immediately and remove the revolving icon? Here is my current code for the Actions on User Input script. course_all_caps=input.Course_number_section.toUpperCase();
fetch and modify data in another application
hi i found already a 4 yr. old answer to this topic - so if nothing changed with Creator 5 i will use this approach. - create a function that provides the data in App A - call this function in App B and fetch the data same with modification of data or is there a more elegant approach in Creator 5? eg. something more "query-like" thank you kind regards Lambert
InteGreat 02: Integrate Zoho Creator with Clickatell
Hi everyone, Today, we'll look at how to integrate your Zoho Creator app with Clickatell. Many of you need to regularly send SMS notifications to your users when a Form is submitted, or based on a specific set of criteria. For example, you might need to send a reminder for a task, or update the customer about an order status, or alert your customer when a payment is due. The solution is to either use the default SMS connection provided by Zoho Creator or create a new connection with any of the
Customer Portal Access with different Customers
Hi i need to share Creator Records with my customers. The application is somehow a "Task Management". Either the customer (persons) can create tasks for me, or I create tasks for the Customer. One customer can have up to three persons, who can access the Portal and work with the tasks. - customer must not see any records created for another customer - it should be easy to maintain, if persons at customer change which approach should i take? my ideas User Field i create a User Field on every record,
I want to run a comparison across attributes that can be selected by a user during profile creation
I have an application having two forms, one seller form with a list of attribute and the other a buyer form with a list of attributes. I want to create a compare function such that once the buyer uploads a form with any matching attributes to that of the seller, a notification (email and SMS) goes to the seller
Can I add data in a field automatically when a dropdown option is selected?
The dropdown is a lookup field that takes the information from another form, the form has the product name and price, I want that when selecting a product I get the price in another field
Download Record Summary as PDF using Zoho Creator Mobile App
Hi all, Is there a way to download the Record Summary as PDF on the Zoho Creator Mobile App? I found the print option, but I want the file to be downloaded. Thanks.
Recurring tasks
I have a form which has a date field "Insurance renewal date". Does anyone know if it is possible to have this automatically update to same date next year once the date has passed, or is that asking too much? Thanks.
Compare Field data of 2 different application form fields
I have 2 applications. 1. daily records (contains form name as ORDERS) 2. monthly records (contains form name as ORDERS) Both forms contains email field, such as 1. daily records(app)->orders(form)->Email(filed) 2. monthly records(app)->orders(form)->Email(filed) now i want to compare those two emails, e.g. if(form1 email == form2 email){ cancel submit; } No any idea, how can i achieve this?
Unable to make it work... automatic date update after selecting or unselecting a boolen field
Hi, I'm trying to make something really easy (I guess...) What I want to do is to set a boolean field to be selected if I need to trigger 2 events in an application: another field updated with the current date and an automatic email notification to be sent. I created the following script, which is suposed to be run when I'm creating or updating my form, but for a reason that I can´t understand is only working after the first submision of my form (meaning only works while updating a form) if(Estatus_de_emision
Create Setting Page
Hi, I want to build a simple Settings Page from one record. Use Case: A Portal User clicks in the Menu on a Link (Component in a Section) with the name "Setting". This opens a specific record (not creating a new record) where the user can change field values. After he is finish with it he can save it and is redirected to the "Setting" again to make changes if necessary (Example in the Attachment). How can I do it? Thanks for your support Best Regards Marcus
Dropdown list input.FIELD gives an error when I try to parse it.
I have a dropdown list. I populate it with a LOT number + ~ + Date of the lot. ie: '123456 ~ 09/05/2018' This works because I can see the lot and date. If I used a lookup field it only showed the lot number and no date. The problem I have is when I save the form, in my onSuccess script I have the following code { ... lot = input.LOT; l = lot.startsWith('~'); ... } the line with the startsWith gives an error Mismatch data type for function startsWith at argument index 1 expected data type [TEXT]
Retrieving FIFO purchase price
Hello Would it be be possible to retrieve the last "purchase price" of an inventory tracked item according to the FIFO ( First in first out) track system? Using Zoho creator in combination with Zoho inventory etc. Kind regards
Save Script button missing in Free-Flowing Script
Save Script button is not available in Free-Flowing Script. Even the shortcut Ctrl+S is not working. Please see attached screenshot.
Deluge for embedded custom report filtering using multi-select criteria
I need to create a custom report, that I can embed on an html page. The scenario is this: Table 1 (generated by form 1) has a few multi-select fields. Table 2 (generated by form 2) has individual fields with the same choices of values available in the multi-select fields in Table 1 I'd like to generate a filtered report of Table 2 based on the criteria present in the multi-select field(s) of Table 1. For example: Table 1 has a multi select field with potential values of A, B, C (in any combination)
Scheduled backup
Hi I miss a feature in your backup procedure. I need a way to schedule my backups. It is okay if the old version is overwritten by the new one. I would like the automatic backup to start every day at 17.00 CET. BR Skouboe
Select records with field value matching any one value in multi-select field?
Is it possible to create a many-to-one query? Value of multi-select field for record 1 is (TEST1, TEST2) Value of multi-select field in record 2 = (TEST1) Value of multi-select field in record 3 = (TEST2) Can I query the table to select record 2 and record 3 as matches for record 1, based on having one shared value rather than an exact match for both values?
Error at on submit script
Im having this error on my application even i do not have any problem on my script. please see images below:
String value assignment spanning multiple lines of input - similar to PHP's HEREDOC syntax or "Concatenation Operator" (Which is a period -> '.')
I've searched for quite a while now and have not found this question asked anywhere else. Does Zoho Creator support syntax similar to the HEREDOC syntax in PHP or some kind of concatenation operator?
Remove Text from a string.
I was wondering if there was anyway to display a certain part of a string that appears before a dash. Example: Report: - Item Record: R0000-00 Form: - Display: R0000
HTML formatting and editing lost in Creator 5 - workaround?
Previous version of Creator used to allow for inserting HTML on a page, and evoking a rich text editor to apply WYSIWYG type formatting. This functionality appears to now be gone in Creator 5 when using HTML snippets. Worse than that, HTML that IS formatted and displays correctly when using another HTML editor does not honor the text formatting (such as the /strong attribute). Previous pages migrated from old Creator have lost all of the text formatting. So none of the old Pages with HTML now look
"onaddrow in subform" Event in Form - only first row is executed
i want to pass data from a Parent form to a field in a subform and use the "on add row in subform" in the parent form. However this event seems to be triggered only for the FIRST row i add in the subform field When adding a second or third row - the script is not executed and the values are not passed to the subform :-( Any ideas?
Next Page