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
Updating a lookup field issue
Hi All, I have a subform that has a single select lookup that needs to be replaced with a multiple select lookup. Both lookups exist now in the form and access the same source "Add_Labels > Labels_Description". Before deleting the single select lookup field, I need to copy the single select data to the multi-select lookup field so I've created a temporay form and script to process make this change - and this is where I'm stuck. I appreciate that the mult-select lookup requires the record ID so I've
Update Subform with field from Parent Form
I am looking for deluge script to update multiple subform entries with the date of the parent form. The purpose of this is to allow me to run more detailed pivot reports with the subform data.
Schedule export of data
Hello - Is there a way to schedule the export of the data from a Zoho Creator application to an external server? Thanks Anil
How do you get the value of a lookup field instead of the record number
I using the value of a lookup field on a form in another formula on the same form and instead of the value being placed in the formula, the record number is placed there. The formula ---- input.Competitor + " - " + input.Media_Channel + " - " + input.Offer Competitor is a look up field on this form from another form/table. When this formula runs, I get the following result 3444267000000037515 - House File - 20% Off All Men's Wear I get the record #, not the value in the field. How do i fix this?
custom PDF name from Record Summary
Hello everyone, following this forum i tried to use a custom action in order to download pdf from a record summary with a customized name (for example the number of an invoice or something else) i've found this function and i've adapted it to my needs void scaricaPdf.scaricaPdf(Nuova_Fattura Numero_Fattura) { openUrl("https://creatorexport.zoho.com" + zoho.appuri + "record-pdf/Elenco_Fatture_Estero/" + Numero_Fattura.ID+ "/customName", "new window"); } everything was compiled correctly but when i
Invalid entries found Please correct and submit again.
Hi, Trying to add the first record to my first form...and got this "Invalid entries found Please correct and submit again." error. All mandatory fields are filled. Don't understand whats going on. Any help would be greatly appreciated. Thanks Cyrille
enter text on summary report with images
I would like to develop your classic shopping cart experience... on the right side of the screen an iframe with report of all available inventory with pictures, an input for the qty and a custom action to "add to cart" on the right of the screen an iframe with the contents of your shopping cart. But Zoho does not allow me to have the user enter a number in the qty field on the left report. How do I work around this.... any ideas?
Emailed link to record in report now broken as of last week
I have been using a scheduled script to email me a link to a report that will show one record. Example the script looks like this: linkToReport = ((((("https://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/html/reportName/") + reportSearchTerms) + "&showHTMLOnly=false"; it creates a link that looks like this: https://creator.zoho.com/zoho_user/zoho_appname/html/reportName/&ID=1986294000004712003&showHTMLOnly=false As of last week the link now pulls up "https://www.zoho.com/creator/"
use one lookup to reduce the records in another lookup
I have created a function and form to copy a few fields from one record and paste in another record. I select the record to be copied using a button on the report which also calls a form where the record to past to can be selected. The problem is the list of records to select from when choosing where to paste is 4000 records long. This makes it difficult to find the record to paste to. I want to reduce the selection by using another field that is linked to the selection or in other words I want
Getting extra Blank page on printing customised record summary
i am getting this problem on all browsers ,so its likely to be an issue with zoho creator itself. Whenever i make a new record summary in a report, It prints with one extra page (even if the data remains on a single page, the extra page just remains blank ). i have tried to create a blank summary still it prints 2 pages. My default paper size set in the printer is A6. If however I Keep the default template for the record summary the printout is limited to just one page. I am stuck on this.
Center a form
Hi, That's maybe a silly question but is there a way to center a form (without embedding it in a Page) ? Thanks!
Next Page