Stateless Forms - next previous buttons
Right so I have a multiple form app (using stateless forms) writing to a single table . What I can't work out is what the onclick command is for custom buttons to go to the next stateless form or previous ! Please help I know it's possible as done here https://creator.zoho.com/mobile/sampleapps/next-previous/#
How to save field settings???
I feel like there's some secret button I'm supposed to click to get Creator to save form field settings. I'll set something in the field, like the name of the field. Then a little yellow box appears that says "Saving Changes...". Then, when I go back to the edit the form, none of the changes are there. Sometimes I've given up and just let a field be called "Single Line" because I can't get Creator to save anything. Here's an example. Here's a screen shot of Creator saying it's saving changes to a
Replicate database to external Postgres or MySQL?
Operating in an environment where a lot of enterprise data is already getting warehoused in a Postgres db and would like to replicate/sync creator tables/data there for reporting and backup purposes. Is this possible?
Need help creating a simple search interface
Hi, I've researched and I found some sample apps for search interface https://app.zohocreator.com/sampleapps/search-records-in-a-form/#Report:Search_records_in_a_form_View https://app.zohocreator.com/sampleapps/embed-search/#Form:Form_A But at old entries; they say you can copy that applications. On new interface, there is no option like that. How can I install or edit these sample apps for looking the codes?
Data Lookup Field Action
Greetings, I have created a form and need to populate a lookup field based on a previous selection. This is the example. I have a form that has client information. The client information form has 5 statements provided by the client. In the evaluation form, we select the client from a lookup field. The next field needs to look up the 5 statement from the client information form based on the client that was selected. I have used the following script with limited the success. My issue is while it
Error in Advanced App Building example tutorial
HI, I am trying below example from Zoho Creator site. I am getting errors. Total Amount is not showing accurately. Please find link for the example I am trying Also attached screen shot of the same Advanced App Building Please Help Thanks Anand
Validation Question
I have a form Expenses. I have two field I need to work with, (1) Reason for expense and (2) order#. I need to write a script that when you select a reason " Fees", that you MUST enter an order # before yo can submit. my script said; (Order is a number field) (Reason is a drop down select-Boolean) order_Temp =input.order; if reason = "Fee" { order_Temp=input.order>0; alert "an order must be inputted when "Fees are selected" } I keep getting errors any idea what I am doing incorrectly?
Fetching record ID of last added record not working
Hi, Let me start with I am very new to Creator. I have a view that list all requests for an agreement with custom actions, one of these links to the function below. Once the "Complete" custom action is clicked, I want to add a record to the NDA_Details_Form so that the new record is linked to the same customer. Then it opens that new NDA_Details_Form record that was just added for editing. I do not want to use a subform on the Request_NDA_Form because after the request is complete, I will delete
Embed dynamic Form inside HTML Page
Hi, I am trying to create a HTML Page So I can embed several forms inside a HTML Page dynamically.See below screenshot there I like to embed the respective form of Buttons into selected area just when user clicks on the Button. Is it possible Thanks Arfater
Freelance Zoho Creator Developer Wanted
I'm looking to hire a Zoho Creator Developer to help me build a Project/Task system. I've created something similar in Oracle NetSuite for our business and would like to create something for personal projects and tasks. I need help assessing if we can simply customize one of the template Zoho applications vs. building one from scratch. If interested please provide me your Zoho experience and hourly development rate.
Global Variables in Report Criteria
Is it possible to call a variable in a Report Criteria that comes from another form?
Zoho Creator - using form fields without using a form layout
I have created several forms in Zoho Creator but, rather than the single- or double-column layout, the owner wants them to look like the final version (nicely arranged, custom colors, logo in the corner, etc) from the get-go. She saw the signup screen (https://www.zoho.com/creator/signup.html) and signin screen (https://www.zoho.com/creator/signin.html). The signup screen is almost a double-column and the signin screen is a centered box--neither of which I can figure out how to replicate. I can tweak
imagen
Could you help me how to use the code "" <img width = '100' src = 'https: //creatorexport.zoho.com "+ zoho.appuri +" viewLinkName / fieldDelugeName / download / "+ fieldDelugeName +"' /> "that is, I want to show an image registered in a form and it will be displayed in html page
Zoho CRM and Creator Communication
Hello Team Zoho, I would like to create an app on ZOHO Creator that communicates with our CRM. We use ZOHO CRM to manage our leads and when the lead turns into a DEAL we create an EVENT and invite our consultant via email to attend the meeting. We were wondering if we can create an app on ZOHO creator which allows the consultant to have a central Hub like system to manage all their meetings. Furthermore upon completing the event If the consultant can log any comments which SYNC with our CRM.
View link of uploaded file - Upload file to google drive
Hi, what is the view link of an uploaded file? Without having to publish report. I am trying to use Zapier to upload the file to google drive when I upload it to Zoho. I tried using the download link, but that doesnt seem to work. Any suggestions?
XML post api for sending sms?
Hi, I'm beginner of deluge script. I need simple connection between sms service and zoho, In my app telephone number and message will be written and with the send button push, relevant infos must send with post api parameters. Here is the sample xml tree: <SMS> <server> <user>[username]</user> <password>[password]</password> </server> <message> <subject>SUBJECT</subject> <text>SMS MESSAGE</text> <numbers>1238970875</numbers> <date>YYYY-MM-DD HH:MM:SS</date> </message> <blacklist>true</blacklist>
Conditionally Send Email
Hi, I want to be able to send an email automatically based on the status of a dropdown. If the user chooses 'Request' from the dropdown it sends an email (and sets the status of the dropdown to 'Awaiting' however I haven't got to that stage yet) if(REF_Status == "Request") { sendmail [ from: me@me.com to: you@you.com subject: This is an email message: Hello ] } I keep getting an error when trying to put the sendmail function in the if statement? What am I doing wrong?
Unable to Choose (Field Type) in (Appearance) section under (Field Properties) on (Form Builder)
We developing a application like Inventory Management using creator from this we have an issue Unable to Choose (Field Type) in (Appearance) section under (Field Properties) on (Form Builder). we have to choose the field type=Submit , then only we write the code on submit button onclick action. so please give us a solution to solve this issue.
Is it possible to pass an unsubmitted form to a function for processing?
I am in the process of streamlining code in an app I'm enhancing by creating functions for large sections with repeated code. I wondered if it is possible to send an un-submitted form to a function for doing validation, setting field values and using actions.
how to send the current form as parameter to a function
Hi there, I have a form where several fields need to be recalculated everytime several other fields are changed. Thus I would like to have a function that will take the current form as a parameter and gather input data, recalculate and re-populate fields with new result. However I cant figure out how to send the current form as a parameter - I can send the datatable so I can get access to the input fields, but I cannot change the value of existing fields through the function ?! Can anyone point me
Event Production Management Application
I am working on an application for an event production management company, and am trying to figure out a solution for being able to select a project and have all report views change to the current project. I was hoping I would be able to set up a criteria function in each Report that would filter fields based on a current project variable, but haven't had success. I found the Global Variables Sample Application, but am not seeing how it would be possible for reports to call for functions. Does
Purpose of "On Update" in field actions
Hi, Good Morning.In Zoho Creator, For every field we have two field actions such as On User Input and On Update. When I changed any field value in edit mode,The script in on user input had worked. Could you please explain the purpose of On Update in field actions. Thank you. Have a great day!
Unable to Save due to (Data Access operations are not supported for stateless form)
Hi I'm Kishore Kumar as Developer in Sixty One Steps Advertising Private Limited. We developing a application like Inventory Management using creator from this we have an issue under workflow -> Form Actions -> Submit -> On Click. we unable to save the code , getting this error (Data Access operations are not supported for stateless form), so please give us a solution to solve this issue.
Offline data entry
Hi everyone! Does Zoho Creator have an offline mobile data entry app? Android or IOS? If yes, how effective is it? Does it have skip logic (dependent questions)? Any major complaints? Thanks in advance for your responses.
Any way to know where all a certain deluge field us used?
Is there any way to know in creator where all a certain Deluge field is reffered to? e.g. I've a field "Target_Dispatch_Date_from_Factory" This was a date entry field but I am planning to change it to an autocalculated formula based on another field. But before I do this I want to make sure if changing this is going to break anything else (e.g. forms/ reports) that access this field. Any way to do this?
Unable to Choose (Field Type) in (Appearance) section under (Field Properties) on (Form Builder)
We developing a application like Inventory Management using creator from this we have an issue Unable to Choose (Field Type) in (Appearance) section under (Field Properties) on (Form Builder). we have to choose the field type=Submit , then only we write the code on submit button onclick action. so please give us a solution to solve this issue.
My Automation Section has vanished?!
The automation section of several of my forms has just vanished?!? Help please!! This is 20+ hours of work that is just gone?!
eMAIL on Add
Whenever I add an entry into a form, two emails got sent. One is from the "on add" script/event, and the other? Where is that from? I think I configured it myself but forgot where to turn it off. Thanks.
Update Field on Other app ?
Hi, I have 2 apps one is QAQI App and other is Sales App in QAQI app i have form which is EMS form in that i have field Account which is lookup from Account form which is from sales app i want when in ems form i select account field and if any value added in Call dispatcher name field then it should update in Account form field call dispatcher name which is on other app in sales app . Let me know any function ,script. Thanks
Customer Portal Customization
Hi Zoho, Please - add an option to edit the customer portal. Fonts, colors, making it responsive... It's 99$ per month - please develop the options available there. Thanks Ravid
Show/Hide Fields
Hi, I'm trying to show/hide fields based on the status of a dropdown. I've created a test form with the following fields.... Dropdown Items 1 Items 2 Items 3 Field 1a Field 1b Field 1c Field 2a Field 2b Field 2c Field 3a Field 3b Field 3c I'm trying to use a workflow to only show fields 1a,b,c when Items 1 is selected, fields 2a,b,c when items 2 is selected and fields 3a,b,c when items 3 is selected but I can't seem to get it to work. Ideally I will be using this
Display a field list from all records to aid in data entry to prevent duplicates
I have an "Add new customer" form with a Single Line text input field to get the customer name but to prevent users from accidentally adding the same customer which existed already I want to show them a list of existing customers from the same form. What's a good way of doing that. I tried a formula but that only refers to the current customer. I want a list of all customers already in the db to be displayed maybe next to the entry field. Thoughts?
Can I highlight a field to indicate out of range numeric inputs?
I want to indicate an out of range numeric input on the form to the user by (say) putting a red box or highlighting it in some way. Is this possible in Zoho creator? e.g. say the form is a quality control form and if a parameter is greater than 10 I will flag it. Note, I know about alert and cancel submit. That's not what I want. The user should only be gently nudged not that the form entry should be prohibited.
Criteria involving Lookup List of BigInt
Hi, I have a form (Class_Rooms)with one of the lookup fields being a list of Students ID (BigInt). How does set a criteria for Class_Rooms where the list contains a particular student ID. This is what i wrote for each Class_Records in Class_Rooms [List_of_Students.contains(Student.iD)] { } But I've been getting the following error. Error at line number : -1 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Error in deluge behaviour: Currency type
Hi guys! It seems there was an update in Zoho deluge scripting, and now we get a error with Currency type field: If I use Currency type field as a float type in expression, it works well. If I try to send it as a float parameter to function, the function get "null" value instead. Examples: Contract.Amount is a form field of Currency type y = Contract.Amount + 1000.00; - works well, and return the amount increased by 1000, as a float variable. Now, we define function with float argument: string
Filter Aggregate Records by Month?
I'm trying to use criteria to filter records by month, e.g.: Date_Field.getMonth() == zoho.currentdate.getMonth() or Date_Field.getMonth() == zoho.currentdate.subMonth(1).getMonth() However, it doesn't seem like I can use a function on the left side of this equation. If that's the case, how is it possible more me to aggregate all the records from a certain month? Thanks!:)
open a record from a form
hi, as you can see in this screeen, https://photos.app.goo.gl/qDVQPK4Dpblm0rqj1 in my form "nuovo compito" (that means new task) i have a "candidato" lookup field. this field take value from another form (applicants). may i find a way to open, maybe using the url field, the relative record of "applicants"? obviously setting the url after input of "candidato" field thx
from subform entry - link to mainform
hi! there is mainform (contacts) and subform (purchases) one contact has many purchases - in one mainform's entry there are many entries inside subform after adding entry to subform - we can view such entries in subform's report how from subform entry can view to which contact they correspond? example 1) open subform entry 2) click on link inside this entry 3) opens corresponding mainform's entry
Powershell REST API
Hi! I'm using Powershell to do REST operations with various online services, such as Dropbox etc and it works fine. Now I'm trying Zoho Creator but with no success. Does anybody have a general Powershell script that would for listing applications and return the result in json format? Preferably I would simply replace the token-code with mine to get the concept. Any input would be appreciated. I have looked at all the examples available and tested for several hours but I've run into a dead end...
Sum of formulas (within subform)
Hi, I have a timesheet subform, with an "Hours worked" field, an "Overtime" field and a "Total" formula field that combines the two values. In the main form, I want to include a grand total field that would be the sum of the "Total" formula for each row. I've achieved this with "Hours worked" only, but not the sum of "Hours worked" and "Overtime". input.Total_Amount = input.Total_Amount + row.Hours_Worked; That works. (in Main Form>Subform>Hours_Worked>On User Input) input.Total_Amount = input.Total_Amount
Next Page